Filter problem for foreign key keyword relation in grid grouping control

[Santosh U]

Hi,

We are not able to see filter for a column, which is created using Foreign Key keyword relation but are able to see filter for the other columns in the parent grid as seen in the screenshot attached.

As we were in need of a combo, we used Foreign Key keyword relation and which is working fine. But Filters and grouping are not working for this column.

Settings:
1. Allow filter = true (for all the columns displayed on grid)

It will be great if you help us with a solution ASAP.

Thanks in advance.
Santosh





FilterNotSeen_29e60c21_37cb0c5c.zip

[Ranjeet Kumar]

Hi Santosh,

Thanks for your interest in Syncfusion Products.

The sample attached implements ForeignKeyReference by setting RelationKind as ForeignKeyReference and also implements grouping of columns by dragging the parent table column to the GroupDropArea by setting ShowGroupDropArea to true on GridGroupingControl. This sample contains filter for all the columns of the parent table and is working fine.
Grouping And Filter have been implemented on Form1_Load event.

Please see the sample for its implementation.


Please find the sample attached from link mentioned below :

http://www.syncfusion.com/uploads/redirect.aspx?&team=support&file=F92581(GGC_CS)825720570.zip

Regards,
Ranjeet.

[Santosh U]

Hi,

Thanks for your reply.

But i need the solution for FOREIGN KEY KEYWORD relation in grid.

and you sent for foreign key reference relation.

Thanks,
Santosh

[Ranjeet Kumar]

Hi Santosh,

Thanks for your update.

Sorry for inconvenience caused due to misinterpreting your requirement.
The sample attached contains two tables named "table1" and "table2" with primary key defined on "Eid" column of table "table1" and foreign key defined on "Eid" column of table "table2". And finally a data relation has been set to show the relationship between two tables. The sample also contains filter enabled for all the columns of two tables as well as grouping.

To test the sample, try entering any numeric value lesser than 100 in last column and again try entering a value greater than 100 in the same column.

// Constructor : Form1()

             // Setting the foreign key on table "table2"
            ForeignKeyConstraint fk = new ForeignKeyConstraint("foreign", ds1.Tables["table1"].Columns["Eid"], ds1.Tables["table2"].Columns["Eid"]);
            ds1.Tables["table2"].Constraints.Add(fk);
            
            // adding a relation between "table1" and "table2"
            ds1.Relations.Add("Relation1", ds1.Tables["table1"].Columns["Eid"], ds1.Tables["table2"].Columns["Eid"]);
   

Please find the sample attached from link mentioned below :

http://www.syncfusion.com/uploads/redirect.aspx?&team=support&file=F-92581-1122533478.zip

Regards,
Ranjeet.

[Santosh U]

Hi Ranjeet,


Please find my attached file, which has code and the screenshot of what I am getting.

The code is the exact what I am trying to achieve through. I do not want a collapsible subgrid but a column with dropdown. You may refer to the screenshot given, just notice the column of the main grid named as "Customers Order Details", I am reaching upto that level, It is also giving me a coma separated Order Ids.

But now I just want a filter on the same column which I am not able to achieve eventhough using the same code as I have done on another grids. I am getting the filters on other columns of the same grid using the code which I have given here but not getting on this particular column.

Please help me through this.

thanks,
Santosh U



sample_24a3624e.zip

[Santosh U]

Hi,

I am waiting for reply.please see the attached code in my previous post.
It will be great if you reply as soon as possible.

Regards,
Santosh

[Santosh U]

Hi,

Please let me know the solution..
Waiting for reply..

Regards,
Santosh

[Rajadurai C]

Hi Santosh,

We apologize for the long delay caused in getting back to you.

We are able to see the behavior of ForeignKeyKeyWords RelationKind w.r.t FilterBar. We are analysing to find out whether this behavior is an expected one w.r.t this relationkind or an issue.

We will get back to you with the analysis details once it has been done.

Regards,
Rajadurai

[Justin Pauley]

Any updates?, I am also having this issue

[Rajadurai C]

Hi Justin,

Thanks for your interest in Syncfusion Products.

It seems you have submitted similar inquiry in Direct Trac as an incident(#66107) for which solution has been provided by handling the QueryFilterBarChoices event at the application level. Please followup with that incident for any further queries regarding this.

Regards,
Rajadurai