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.
Unfortunately, activation email could not send to your email. Please try again.

And filter on foreignkey fields

Thread ID:





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

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 04:36 AM

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.

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.