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: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

And filter on foreignkey fields

Thread ID:





123504 Mar 23,2016 12:08 PM UTC Mar 24,2016 08:36 AM UTC ASP.NET MVC 1
Tags: Grid
Omar Muscatello
Asked On March 23, 2016 12:08 PM UTC

Hello Syncfusion Team,

I'm working with the grid control with some foreign key fields and URL Adaptor.
I want to filter the grid by these foreignkey field with an 'AND' condition.

Suppose that we have 2 columns with these values:

text: Value1, value: 1
text: Value12, value: 2
text: Value3, value: 3

text: Value3, value: 4
text: Value34, value: 5
text: Value5, value: 6

If I filter only Column1 by the value "Value1", it builds this sql query (I report only the where filter):

(1 = `Extent1`.`Column1`) OR (12= `Extent1`.`Column1`)

It is right.

But if I filter Column1 by value "Value1" and Column2 by value "Value3", it builds this sql query:

((1 = `Extent1`.`Column1`) OR (12= `Extent1`.`Column1`)) OR ((4 = `Extent1`.`Column2`) OR (5= `Extent1`.`Column2`))

Instead, I want to achive this:

((1 = `Extent1`.`Column1`) OR (12= `Extent1`.`Column1`)) AND ((4 = `Extent1`.`Column2`) OR (5= `Extent1`.`Column2`))

How can I do that?

Balaji Marimuthu [Syncfusion]
Replied On March 24, 2016 08:36 AM UTC

Hi Omar,

Thanks for contacting Syncfusion support.

We considered this “Multiple foreignkey columns filter on  “or” predicate instead of “and” operation” as an issue and a support incident has been created under your account to track the status of this requirement. Please log on to our support website to check for further updates. 


Balaji Marimuthu


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.

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

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