{"id":220,"date":"2022-06-09T19:46:30","date_gmt":"2022-06-09T19:46:30","guid":{"rendered":"https:\/\/docs.xlreport.com\/docs\/admin-user\/query-properties\/"},"modified":"2022-06-14T18:04:39","modified_gmt":"2022-06-14T18:04:39","slug":"query-properties","status":"publish","type":"docs","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/query-your-data\/query-properties\/","title":{"rendered":"Query Properties"},"content":{"rendered":"<h2>Edit Query Properties<\/h2>\n<ul>\n<li value=\"1\">Select <span class=\"DoIt\">&gt;Query Option&gt;Properties <\/span>on the menu bar.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/49.png\" \/><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/50.png\" \/><\/p>\n<ul>\n<li value=\"1\">To select only a certain number of top records click the <span class=\"DoIt\">TOP <\/span>field and enter a value.<\/li>\n<li value=\"2\">Assign DISTINCT or <span class=\"DoIt\">DISTINCTROW <\/span>option.<\/li>\n<\/ul>\n","protected":false},"featured_media":0,"parent":147,"menu_order":9,"comment_status":"open","ping_status":"closed","template":"","doc_tag":[],"_links":{"self":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/220"}],"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=220"}],"version-history":[{"count":1,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/220\/revisions"}],"predecessor-version":[{"id":221,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/220\/revisions\/221"}],"up":[{"embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/147"}],"next":[{"title":"Union Queries","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/query-your-data\/union-queries\/","href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/222"}],"prev":[{"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"}],"wp:attachment":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/media?parent=220"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/doc_tag?post=220"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}