ODataV4Adaptor and apostrophe in column filter

[Tom Rebbettes]

Hey,

When filtering a coulmn and the filter contains an apostrophe (using contains and the ODataV4Adaptor) the controller returns an error due to incorectly formatted odata URI as seen here:

$filter=contains(Name, 'tes't')

Just pointing out the bug in case its not on your list of things to fix :)

[Jeevakanth Palaniappan]

Hi Tom, 

Greetings from Syncfusion support. 

We have checked your query but we need the few more details to proceed further on this. So kindly share us the below details, 

1. Share us the Syncfusion NuGet version details.
2. Kindly share us what type of Filter type you are using(FilterBar/Menu/Excel/Checkbox).
3. Kindly share us the video demo showing the reported problem.

The above requested details will be helpful for us to validate your query and to provide you with a better solution as early as possible. 

Regards, 

Jeevakanth SP. 

[Tom Rebbettes]

Screenshot here gives all the details of the error when using the ODataV4Adapter.

Note the apostrophee in the filter input.

I have attached an example project too.

Attachment: SyncfusionExamples_861f4c8.zip

[Jeevakanth Palaniappan]

Hi Tom, 

Thanks for sharing the issue reproducing sample. 

We have validated and considered your query as a bug and logged the defect report “Invalid Odata URI is passed when the filtervalue string contains single quotes(')” for the same. Thank you for taking the time to report this issue and helping us improve our product. At Syncfusion, we are committed to fixing all validated defects (subject to technological feasibility and Product Development Life Cycle) and including the fix in our upcoming patch release which is expected to be rolled out by mid of Jan, 2021. Until then we appreciate your patience. 

 

You can now track the current status of your request, review the proposed resolution timeline, and contact us for any further inquiries through this link.  

https://www.syncfusion.com/feedback/31066/invalid-odata-uri-is-passed-when-the-filtervalue-string-contains-single-quotes 

 

Regards,  

Jeevakanth SP. 

[Monisha Saravanan]

Hi Tom,

Sorry for the inconvenience caused.

Due to some unforeseen circumstances, we could not able to include the fix for this issue “Invalid Odata URI is passed when the filtervalue string contains single quotes(')” in our mentioned weekly release. But we will fix this issue and will include the defect fix in our upcoming patch release which will be rolled out on Feb 8th, 2022.

You can now track the current status of your request, review the proposed resolution timeline, and contact us for any further inquiries through this link.

https://www.syncfusion.com/feedback/31066/invalid-odata-uri-is-passed-when-the-filtervalue-string-contains-single-quotes 

We will update you once the issue was fixed. Until then we appreciate your patience.

Regards,
Monisha