QueryBuilder - Condition not Change - Version 18.4.0.42

[Stefano Manto]

Good evening,

i am using version 18.4.0.42 and i have a problem with the QueryBuilder. Trying your example when I try to set the OR condition to GetSqlFromRules I always have an AND condition.

Even if I change between the two conditions, the result is always AND

Thanks

[Aravinthan Seetharaman]

Hi Stefano, 

 

Thanks for contacting Syncfusion Support. 

 

We have checked your reported query. We can not reproduce your reported issue in our end. And we suspect that this issue has been occurred due calling GetSqlFromRules method without giving valid rules as a parameter. We can resolve your reported issue by using GetValidRules method as like in the below code snippet. 

 

 

private async void getSql() 

    { 

        content = QueryBuilderObj.GetSqlFromRules(QueryBuilderObj.GetValidRules()); 

        await DialogObj.Show(); 

    } 

 

 

For your reference we have provided sample here. 

 

Sample: https://www.syncfusion.com/downloads/support/forum/162495/ze/QueryBuilder_GetValidRule-225490475  

 

Could you please check the above details, and get back to us, if you need assistance on this. 

 

Regards, 

Aravinthan S 

[Stefano Manto]

Perfect!

Thanks so much.

Is there a best practice to use the "is null" and "is not null" operator for the null type bit field?

[Aravinthan Seetharaman]

Hi Stefano, 

 

Thanks for the update. 

 

We have checked your reported query. We suspect that your requirement is about “is null and is not null operators for null type”. In QueryBuilder we have provided support for four types of column field namely Number, String, Date, Boolean. Is null and Is not null operators will work on the type Numer and String only. For your reference we have created video demo and sample here 

 

Sample: https://www.syncfusion.com/downloads/support/forum/162495/ze/QueryBuilder_GetValidRule-225490475  

 

Demo: https://www.syncfusion.com/downloads/support/forum/162495/ze/QueryBuilder_CoulmnType-1932097420  

 

If we misunderstood your requirement, please share more details. So that we can work on this and provide you a better solution quickly. 

 

Regards, 

Aravinthan S