{"id":1294,"date":"2017-08-02T11:55:50","date_gmt":"2017-08-02T10:55:50","guid":{"rendered":"http:\/\/vger.datos.co.uk\/ClientKnowledgebase\/?p=1294"},"modified":"2017-08-02T11:55:50","modified_gmt":"2017-08-02T10:55:50","slug":"how-to-open-a-query-definition","status":"publish","type":"post","link":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/?p=1294","title":{"rendered":"How to open and run a pre-defined Query Definition"},"content":{"rendered":"<ol>\n<li>Click on the Season icon- &gt; Office Tools -&gt; \u00a0Season Query&#8230;<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1295 size-full\" src=\"http:\/\/vger.datos.co.uk\/ClientKnowledgebase\/wp-content\/uploads\/2017\/08\/1-e1502458446529.jpg\" alt=\"\" width=\"484\" height=\"424\" \/><\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol start=\"2\">\n<li>This will bring up the &#8216;Query Definition&#8217; program.<\/li>\n<li>Click on the folder icon at the top of the window to select a pre-defined query (highlighted in the image below).<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1297 size-full\" src=\"http:\/\/vger.datos.co.uk\/ClientKnowledgebase\/wp-content\/uploads\/2017\/08\/2-1-e1502458076168.jpg\" alt=\"\" width=\"799\" height=\"546\" \/><\/p>\n<ol start=\"4\">\n<li>This will bring up the standard Windows file open dialog.<\/li>\n<li>Query definitions are stored in a folder per user. It may be necessary to navigate to the correct folder to find the query definition to be run.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1299\" src=\"http:\/\/vger.datos.co.uk\/ClientKnowledgebase\/wp-content\/uploads\/2017\/08\/3-2.png\" alt=\"\" width=\"939\" height=\"524\" \/><\/p>\n<p>&nbsp;<\/p>\n<ol start=\"6\">\n<li>Double click on the Query you wish to open. This will load the query definition.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1300\" src=\"http:\/\/vger.datos.co.uk\/ClientKnowledgebase\/wp-content\/uploads\/2017\/08\/4.png\" alt=\"\" width=\"772\" height=\"529\" \/><\/p>\n<ol start=\"7\">\n<li>Click in to the &#8216;Selection&#8217; tab to amend any of the selection criteria as necessary.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1693 aligncenter\" src=\"http:\/\/vger.datos.co.uk\/ClientKnowledgebase\/wp-content\/uploads\/2017\/08\/SeasonQuerySelectionGrid.png\" alt=\"\" width=\"451\" height=\"266\" \/><\/p>\n<ol start=\"8\">\n<li>Click on the &#8216;Default Value&#8217; button to enter in the new criteria. This will popup a form to enter in the new values.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1694 aligncenter\" src=\"http:\/\/vger.datos.co.uk\/ClientKnowledgebase\/wp-content\/uploads\/2017\/08\/SeasonQuerySelectionDefaultValue.png\" alt=\"\" width=\"390\" height=\"219\" \/><\/p>\n<ol start=\"9\">\n<li>Enter the values and click OK.<\/li>\n<li>Now click on the &#8216;Output&#8217; tab to select output criteria.\n<ul>\n<li>If outputting to a file you will need to make sure the file path is valid.<\/li>\n<li>If outputting to a printer, click the &#8216;Printer&#8217; button to set printer options.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1695 aligncenter\" src=\"http:\/\/vger.datos.co.uk\/ClientKnowledgebase\/wp-content\/uploads\/2017\/08\/seasonqueryoutputtab.png\" alt=\"\" width=\"750\" height=\"369\" \/><\/p>\n<ol start=\"11\">\n<li>Click on the &#8216;Run&#8217; button to run the report.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Click on the Season icon- &gt; Office Tools -&gt; \u00a0Season Query&#8230; &nbsp; This will bring up the &#8216;Query Definition&#8217; program. Click on the folder icon at the top of the window to select a pre-defined query (highlighted in the image below). This will bring up the standard Windows file open dialog. Query definitions are stored [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,20],"tags":[254,291],"class_list":["post-1294","post","type-post","status-publish","format-standard","hentry","category-howtoguides","category-howtooffice","tag-season-query","tag-query"],"_links":{"self":[{"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/posts\/1294","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1294"}],"version-history":[{"count":0,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/posts\/1294\/revisions"}],"wp:attachment":[{"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1294"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1294"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1294"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}