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)