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

where clause formating with selecting Blanks in excel filter

Thread ID:

Created:

Updated:

Platform:

Replies:

145639 Jul 2,2019 06:39 AM UTC Jul 13,2020 11:26 AM UTC Angular - EJ 2 13
loading
Tags: Grid
Unknown
Asked On July 2, 2019 06:39 AM UTC

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 [Syncfusion]
Replied On July 4, 2019 10:09 AM UTC

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. 


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
Replied On July 22, 2019 11:26 AM UTC

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 [Syncfusion]
Replied On July 26, 2019 12:43 PM UTC

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.  


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
Replied On August 11, 2019 08:24 AM UTC

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 [Syncfusion]
Replied On August 12, 2019 07:42 AM UTC

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
Replied On June 29, 2020 11:34 AM UTC

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: