{"id":211,"date":"2022-06-09T19:41:16","date_gmt":"2022-06-09T19:41:16","guid":{"rendered":"https:\/\/docs.xlreport.com\/docs\/admin-user\/criteria-filter\/"},"modified":"2022-06-14T18:04:39","modified_gmt":"2022-06-14T18:04:39","slug":"criteria-filter","status":"publish","type":"docs","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/query-your-data\/criteria-filter\/","title":{"rendered":"Criteria &#8211; Filter"},"content":{"rendered":"<p>XLReport allows to add any criteria &#8211; filter supported by the database you are connected to.<\/p>\n<h2>Add a Filter<\/h2>\n<ul>\n<li value=\"1\">Select the field <span class=\"DoIt\">Criteria <\/span>and <span class=\"DoIt\">double click<\/span> it.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/32.png\" \/><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/35.png\" \/><\/p>\n<ul>\n<li value=\"1\">To add an <span class=\"DoIt\">Operator double click<\/span> it .<\/li>\n<li value=\"2\">You can enter values manually or use the Values functionality.<\/li>\n<li value=\"3\"><span class=\"DoIt\">Click Show Values<\/span> to load all values contained in the database.<\/li>\n<li value=\"4\">To select a value <span class=\"DoIt\">double click<\/span> it.<\/li>\n<li value=\"5\">Click <span class=\"DoIt\">Ok <\/span>to add the expression to the Query.<\/li>\n<\/ul>\n","protected":false},"featured_media":0,"parent":147,"menu_order":7,"comment_status":"open","ping_status":"closed","template":"","doc_tag":[],"_links":{"self":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/211"}],"collection":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/comments?post=211"}],"version-history":[{"count":2,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/211\/revisions"}],"predecessor-version":[{"id":213,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/211\/revisions\/213"}],"up":[{"embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/147"}],"next":[{"title":"User Input Parameters","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/query-your-data\/user-input-parameters\/","href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/218"}],"prev":[{"title":"Aggregate Functions","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/query-your-data\/aggregate-functions\/","href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/209"}],"wp:attachment":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/media?parent=211"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/doc_tag?post=211"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}