We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Filter problem for foreign key keyword relation in grid grouping control

Thread ID:

Created:

Updated:

Platform:

Replies:

92581 Jan 23,2010 06:12 AM UTC Mar 30,2010 02:09 PM UTC WinForms 9
loading
Tags: GridControl
Santosh U
Asked On January 23, 2010 06:12 AM UTC

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 [Syncfusion]
Replied On January 25, 2010 06:53 AM UTC

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
Replied On January 25, 2010 12:16 PM UTC

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 [Syncfusion]
Replied On January 27, 2010 12:21 PM UTC

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
Replied On January 30, 2010 07:29 AM UTC

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
Replied On February 4, 2010 03:55 AM UTC

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
Replied On February 11, 2010 01:42 PM UTC

Hi,

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

Regards,
Santosh

Rajadurai C [Syncfusion]
Replied On February 12, 2010 12:43 PM UTC

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
Replied On March 23, 2010 12:55 PM UTC

Any updates?, I am also having this issue

Rajadurai C [Syncfusion]
Replied On March 30, 2010 02:09 PM UTC

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

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;