{"id":17345354,"date":"2024-01-15T20:02:12","date_gmt":"2024-01-15T20:02:12","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/server-side-processing-search-functionality\/"},"modified":"2024-01-15T20:02:12","modified_gmt":"2024-01-15T20:02:12","slug":"server-side-processing-search-functionality","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/server-side-processing-search-functionality\/","title":{"rendered":"Server-Side Processing Search Functionality"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Hello there, <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I am looking for some help in relation to the search functionality within a WpDataTable while the server side processing functionality is enabled. I am aware that the server-side processing is activated when a table is pass a certain amount of rows, which is the case in this scenario. I read elsewhere that you should simplify the query as much as possible so that the dynamic creation of the new queries is not affected. We are pulling from a SQL server with a view via this query:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SELECT * FROM XXXXXXXXXXXXXX.dbo.vccAdapterLog<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The search functionality was operating fine before the table got to such a size that the server-side processing was triggered, and now there are no matching records being returned in the table when a search is attempted. Is there something on the server side that needs to be configured in order to allow for server-side processing, or a setting within WpDataTables that would need to be configured differently for this? Any help in relation to this issue would be greatly appreciated. <\/p>\n","protected":false},"template":"","class_list":["post-17345354","topic","type-topic","status-publish","hentry","topic-tag-search-function","topic-tag-sql-server"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/17345354","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/17345354\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=17345354"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}