This is a migrated thread and some comments may be shown as answers.

Kendo grid long query string issue

1 Answer 81 Views
Grid
This is a migrated thread and some comments may be shown as answers.
MUDIAM
Top achievements
Rank 1
Veteran
MUDIAM asked on 26 Apr 2021, 02:36 PM

Hi 

We are using a kendo grid with a WCF service to load data in the grid. The grid has sorting, filtering and paging, we are getting 404 error due to long query strings that add the filters for EF behind the scene. These query strings are unmanageable, can you please suggest a way to reduce it and make it work for all clients.

https://xyz.net/DataService/Service.svc/vw_DataPending?$callback=jQuery33105090844870624116_1619444376254&%24inlinecount=allpages&%24format=json&%24top=20&%24orderby=EncounterDate&%24filter=(PracticeLocationsId%20eq%201%20or%20PracticeLocationsId%20eq%204%20or%20PracticeLocationsId%20eq%2016%20or%20PracticeLocationsId%20eq%2020%20or%20PracticeLocationsId%20eq%2025%20or%20PracticeLocationsId%20eq%20111%20or%20PracticeLocationsId%20eq%2092%20or%20PracticeLocationsId%20eq%2010%20or%20PracticeLocationsId%20eq%205%20or%20PracticeLocationsId%20eq%206%20or%20PracticeLocationsId%20eq%207%20or%20PracticeLocationsId%20eq%208%20or%20PracticeLocationsId%20eq%209%20or%20PracticeLocationsId%20eq%2017%20or%20PracticeLocationsId%20eq%2018%20or%20PracticeLocationsId%20eq%2019%20or%20PracticeLocationsId%20eq%2021%20or%20PracticeLocationsId%20eq%2022%20or%20PracticeLocationsId%20eq%2023%20or%20PracticeLocationsId%20eq%2024%20or%20PracticeLocationsId%20eq%2032%20or%20PracticeLocationsId%20eq%2039%20or%20PracticeLocationsId%20eq%2040%20or%20PracticeLocationsId%20eq%20112%20or%20PracticeLocationsId%20eq%2026%20or%20PracticeLocationsId%20eq%2027%20or%20PracticeLocationsId%20eq%2029%20or%20PracticeLocationsId%20eq%2030%20or%20PracticeLocationsId%20eq%20114%20or%20PracticeLocationsId%20eq%2043%20or%20PracticeLocationsId%20eq%2035%20or%20PracticeLocationsId%20eq%2031%20or%20PracticeLocationsId%20eq%2034%20or%20PracticeLocationsId%20eq%2041%20or%20PracticeLocationsId%20eq%2042%20or%20PracticeLocationsId%20eq%2038%20or%20PracticeLocationsId%20eq%20115%20or%20PracticeLocationsId%20eq%2037%20or%20PracticeLocationsId%20eq%2053%20or%20PracticeLocationsId%20eq%2054%20or%20PracticeLocationsId%20eq%2055%20or%20PracticeLocationsId%20eq%2056%20or%20PracticeLocationsId%20eq%2057%20or%20PracticeLocationsId%20eq%20119%20or%20PracticeLocationsId%20eq%2036%20or%20PracticeLocationsId%20eq%2033%20or%20PracticeLocationsId%20eq%20118%20or%20PracticeLocationsId%20eq%2058%20or%20PracticeLocationsId%20eq%2059%20or%20PracticeLocationsId%20eq%20113%20or%20PracticeLocationsId%20eq%20116%20or%20PracticeLocationsId%20eq%20120%20or%20PracticeLocationsId%20eq%20121%20or%20PracticeLocationsId%20eq%2060%20or%20PracticeLocationsId%20eq%2062%20or%20PracticeLocationsId%20eq%2063%20or%20PracticeLocationsId%20eq%2067%20or%20PracticeLocationsId%20eq%2083%20or%20PracticeLocationsId%20eq%2084%20or%20PracticeLocationsId%20eq%2074%20or%20PracticeLocationsId%20eq%2073%20or%20PracticeLocationsId%20eq%2070%20or%20PracticeLocationsId%20eq%2069%20or%20PracticeLocationsId%20eq%2064%20or%20PracticeLocationsId%20eq%2065%20or%20PracticeLocationsId%20eq%2066%20or%20PracticeLocationsId%20eq%2072%20or%20PracticeLocationsId%20eq%2068%20or%20PracticeLocationsId%20eq%2075%20or%20PracticeLocationsId%20eq%2081%20or%20PracticeLocationsId%20eq%2093%20or%20PracticeLocationsId%20eq%2061%20or%20PracticeLocationsId%20eq%2076%20or%20PracticeLocationsId%20eq%2077%20or%20PracticeLocationsId%20eq%2078%20or%20PracticeLocationsId%20eq%2079%20or%20PracticeLocationsId%20eq%2080%20or%20PracticeLocationsId%20eq%2082%20or%20PracticeLocationsId%20eq%2085%20or%20PracticeLocationsId%20eq%2086%20or%20PracticeLocationsId%20eq%2087%20or%20PracticeLocationsId%20eq%2094%20or%20PracticeLocationsId%20eq%2095%20or%20PracticeLocationsId%20eq%2096%20or%20PracticeLocationsId%20eq%2098%20or%20PracticeLocationsId%20eq%20100%20or%20PracticeLocationsId%20eq%2099%20or%20PracticeLocationsId%20eq%20101%20or%20PracticeLocationsId%20eq%20102%20or%20PracticeLocationsId%20eq%20103%20or%20PracticeLocationsId%20eq%20104%20or%20PracticeLocationsId%20eq%20105%20or%20PracticeLocationsId%20eq%20106%20or%20PracticeLocationsId%20eq%20107%20or%20PracticeLocationsId%20eq%20108%20or%20PracticeLocationsId%20eq%20109%20or%20PracticeLocationsId%20eq%20110%20or%20PracticeLocationsId%20eq%2089%20or%20PracticeLocationsId%20eq%2088%20or%20PracticeLocationsId%20eq%2090%20or%20PracticeLocationsId%20eq%2091%20or%20PracticeLocationsId%20eq%20123%20or%20PracticeLocationsId%20eq%20124%20or%20PracticeLocationsId%20eq%20125%20or%20PracticeLocationsId%20eq%20126%20or%20PracticeLocationsId%20eq%20128%20or%20PracticeLocationsId%20eq%20129)

1 Answer, 1 is accepted

Sort by
0
Anton Mironov
Telerik team
answered on 29 Apr 2021, 01:20 PM

Hello Mudiam,

Thank you for the query string and details provided.

Actually, the Kendo UI Grid is working on the visualization of the provided data. 

I am not sure why all the escaping is needed. Is it convenient for you to provide a runnable, isolated, sample project? Examining this project will let us replicate the issue locally and further troubleshoot it.

Looking forward to hearing back from you.

Kind Regards,
Anton Mironov
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Tags
Grid
Asked by
MUDIAM
Top achievements
Rank 1
Veteran
Answers by
Anton Mironov
Telerik team
Share this question
or