where clause formating with selecting Blanks in excel filter

[Unknown]

Hello,

I am using my custom parameters for filtering grid by adding same structure as normal where request clause. If I have column with type date or datetime and with excel filter I am removing check box from Blanks - I am getting different normal where clause requests to webAPI.

If I am not pushing my additional parameters, I am getting this structure:

If I am adding my additional parameters, I am getting this structure:

In second case I am getting incorrect data when I am expanding excel filter again (no of other dates is selected and also other column filters show No records to display, but I am getting data for them):

I am not doing anything with normal where clause - I am only pushing my additional parameter with structure. I am attaching my method for adding additional parameters (for my needs this method works correctly but somehow it affects normal where clause)

Attachment: method_5f3892f9.zip

[Thavasianand Sankaranarayanan]

Hi AC, 

Thanks for contacting Syncfusion support. 

We have validated the provided information and if you want to generate predicate for complex filtering then we suggest you to use the below way instead of pushing predicate into where query. 

Help documentation: https://ej2.syncfusion.com/angular/documentation/data/querying/?no-cache=1#build-complex-filter-criteria-using-code-classlanguage-textpredicatecode 

If the above does not resolve the problem then share the below details that will helpful for us to validate further at our end. 

1. Did you want to use your own custom filtering instead of default filter
2. Or you need send only the additional parameter while filtering?
3. Share your full requirement and code example that will helpful to proceed further.

Regards, 

Thavasianand S. 

[Unknown]

Hello,

1. Yes I want to use my own filtering parameters and not use it with setting predicates.

2. I am doing my filtering by passing my additional parameters almost similar structure as default where clause

3. My code for adding additional parameters where attached in previously asked question in this thread.

I am only wondering how my additional parameters can have influence for default where clause structure? I am not doing anything with default where clause but as can you see in previous question - I see different where clause structure while I am additional my additional parameter and while not using my additional parameter.

[Thavasianand Sankaranarayanan]

Hi AC, 

Thanks for your update. 

We have validated the provided information and checked with our end and its working fine at our sample(it does not affect the default where structure). Please refer the below sample for more information. In the below sample, we have apply additional parameters to grid while perform filtering.  

Sample : https://www.syncfusion.com/downloads/support/directtrac/general/ze/server-1176927274 

We suspect that due to the object reference(assign from filterSettings) might cause the problem so please check and ensure this at your end(command addParams line only and check it once if you still face the problem then it’s because of the object reference). If you still face the problem then share the sample or hosted link or reproduce the reported problem at our sample that will be more helpful for us to validate further at our end. 

Regards, 

Thavasianand S.  

[Unknown]

Hello,

thank you for help. My problem is finally solved!

My problem was that I was changing filterSettings property type because in some cases it is undefined. So this change affects filtering settings structure.

[Seeni Sakthi Kumar Seeni Raj]

Hi AC,  

Thanks for your update.  

We are happy to hear that your requirement has been resolved and you are good to go.  

Please get back to us, if you require further assistance on this.  

Regards,  

Seeni Sakthi Kumar S. 

[Unknown]

Hello,

I renewed grid version to latest (18.1.57) and after that I am getting incorrect data with my additional parameters while sending them to WebAPI. I do not change my code that was working with version 17.1.48 but now I am getting different data.

I am trying to send my own filters to WebAPI and am getting incorrect dates when I am adding it to parameters (this is data while I am console log it before request to WebAPI):

But I am getting different data in request: