[et_pb_section fb_built=”1″ _builder_version=”4.27.4″ _module_preset=”default” custom_margin=”0px|0px|0px|0px|false|false” custom_padding=”0px|0px|0px|0px|false|false” locked=”off” global_colors_info=”{}”][et_pb_row _builder_version=”4.27.4″ _module_preset=”default” custom_margin=”0px|0px|0px|0px|false|false” custom_padding=”0px|0px|0px|0px|false|false” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Returns dataset from table\/view query<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Select<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n
dbs<\/strong>*: Local database name or remote connection string (string) [\/et_pb_text][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ sticky_enabled=”0″]<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ sticky_enabled=”0″]<\/p>\n Column filters can be added using the search_column<\/strong> and search_column_fns<\/strong> parameters. You must provide both parameters! This feature requires a premium license.<\/p>\n [\/et_pb_text][et_pb_dmb_code_snippet _builder_version=”4.27.4″ _module_preset=”default” code=”WwogICAgewogICAgICAgICJpZCI6ICJib29rX2lkIiwKICAgICAgICAidmFsdWUiOiAiOCIKICAgIH0KXQ==” title=”Parameter search_columns format” hover_enabled=”0″ sticky_enabled=”0″][\/et_pb_dmb_code_snippet][et_pb_dmb_code_snippet _builder_version=”4.27.4″ _module_preset=”default” title=”Parameter search_column_fns format” hover_enabled=”0″ sticky_enabled=”0″ code=”ewogICAgImJvb2tfaWQiOiAiY29udGFpbnMiLAogICAgImJvb2tfdGl0bGUiOiAiY29udGFpbnMiLAogICAgImJvb2tfYXV0aG9yIjogImVxdWFscyIsCiAgICAiYm9va19nZW5yZSI6ICJlcXVhbHMiLAogICAgImJvb2tfc3ViZ2VucmUiOiAiZXF1YWxzIiwKICAgICJkYXRlX2FkZGVkIjogImNvbnRhaW5zIgp9″][\/et_pb_dmb_code_snippet][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Returns dataset from table\/view queryActionSelectArgumentsdbs*: Local database name or remote connection string (string)tbl*: Table or view name (string)col: Table\/view column names (object, value TRUE = queryable)page_index: Page number (integer, default=0, minimum=0)page_size: Rows per page (0=all) (interger, default=10, minimum=1)search: Global search filter (string)search_columns: Column search filters (object)search_column_fns: Column search filter modes (object)sorting: Order by (array of […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"doc_category":[69],"doc_tag":[],"knowledge_base":[],"class_list":["post-256","docs","type-docs","status-publish","hentry","doc_category-rest-api"],"year_month":"2026-06","word_count":388,"total_views":"103","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"peterschulz.nl@gmail.com","author_nicename":"peterschulz-nlgmail-com","author_url":"https:\/\/wpdataaccess.com\/author\/wpdataaccess_admin\/"},"doc_category_info":[{"term_name":"REST API","term_url":"https:\/\/docs.legacy.wpdataaccess.com\/docs\/non-knowledgebase\/rest-api\/"}],"doc_tag_info":[],"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/docs.legacy.wpdataaccess.com\/wp-json\/wp\/v2\/docs\/256","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.legacy.wpdataaccess.com\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/docs.legacy.wpdataaccess.com\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/docs.legacy.wpdataaccess.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.legacy.wpdataaccess.com\/wp-json\/wp\/v2\/comments?post=256"}],"version-history":[{"count":1,"href":"https:\/\/docs.legacy.wpdataaccess.com\/wp-json\/wp\/v2\/docs\/256\/revisions"}],"predecessor-version":[{"id":374,"href":"https:\/\/docs.legacy.wpdataaccess.com\/wp-json\/wp\/v2\/docs\/256\/revisions\/374"}],"wp:attachment":[{"href":"https:\/\/docs.legacy.wpdataaccess.com\/wp-json\/wp\/v2\/media?parent=256"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/docs.legacy.wpdataaccess.com\/wp-json\/wp\/v2\/doc_category?post=256"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/docs.legacy.wpdataaccess.com\/wp-json\/wp\/v2\/doc_tag?post=256"},{"taxonomy":"knowledge_base","embeddable":true,"href":"https:\/\/docs.legacy.wpdataaccess.com\/wp-json\/wp\/v2\/knowledge_base?post=256"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
tbl<\/strong>*: Table or view name (string)
col<\/strong>: Table\/view column names (object, value TRUE = queryable)
page_index<\/strong>: Page number (integer, default=0, minimum=0)
page_size<\/strong>: Rows per page (0=all) (interger, default=10, minimum=1)
search<\/strong>: Global search filter (string)
search_columns<\/strong>: Column search filters (object)
search_column_fns<\/strong>: Column search filter modes (object)
sorting<\/strong>: Order by (array of { id and desc })
row_count<\/strong>: Row count (integer, minimum=0)
row_count_estimate<\/strong>: Calculate row count estimate (boolean)
media<\/strong>: For internal use only (object)
client_side<\/strong>: For internal use only (boolean)<\/p>\nColumn Filters<\/h2>\n