{"id":6255,"date":"2019-10-25T06:40:50","date_gmt":"2019-10-25T06:40:50","guid":{"rendered":"http:\/\/www.datapost.co.za\/help\/?page_id=6255"},"modified":"2021-03-17T11:56:24","modified_gmt":"2021-03-17T09:56:24","slug":"how-to-build-a-saved-query","status":"publish","type":"page","link":"https:\/\/datapost.co.za\/help\/how-to-build-a-saved-query\/","title":{"rendered":"Saved Queries"},"content":{"rendered":"[et_pb_section fb_built=”1″ fullwidth=”on” _builder_version=”4.5.3″ _module_preset=”default”][et_pb_fullwidth_header title=”How to build a saved query” button_one_text=”Back” button_one_url=”https:\/\/datapost.co.za\/help\/advanced\/” _builder_version=”4.9.2″ _module_preset=”default” custom_button_one=”on” button_one_icon=”%%19%%” global_colors_info=”{%22gcid-434e3e7c-aba7-49f2-8895-830dae15ee9e%22:%91%93}”][\/et_pb_fullwidth_header][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.5.3″ _module_preset=”default”][et_pb_row _builder_version=”4.5.3″ _module_preset=”default”][et_pb_column type=”4_4″ _builder_version=”4.5.3″ _module_preset=”default”][et_pb_text _builder_version=”4.5.3″ _module_preset=”default”]\n

What is a saved query?<\/strong><\/h4>\n

A saved query, is a collection of search criteria\/results, saved with a unique name that can be used across multiple content lists. A container mode will have to be added to the saved query to control the behaviour of the content in the saved query.<\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.5.3″ _module_preset=”default”][et_pb_column type=”4_4″ _builder_version=”4.5.3″ _module_preset=”default”][et_pb_text _builder_version=”4.5.3″ _module_preset=”default”]\n

Step-by-step guide on how to build a saved query<\/strong><\/h4>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_column type=”3_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_image src=”https:\/\/datapost.co.za\/help\/wp-content\/uploads\/2020\/04\/Expand-Search-Builder.jpg” title_text=”Expand-Search-Builder” _builder_version=”4.5.3″ _module_preset=”default”][\/et_pb_image][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_text _builder_version=”4.5.3″ _module_preset=”default”]\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

1. Expand the\u00a0Search Builder\u00a0in the panel on the left of the screen by clicking on the plus sign.<\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_column type=”3_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_image src=”https:\/\/datapost.co.za\/help\/wp-content\/uploads\/2020\/04\/Select-AND-Find.jpg” title_text=”Select-AND-Find” _builder_version=”4.5.3″ _module_preset=”default”][\/et_pb_image][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_text _builder_version=”4.5.3″ _module_preset=”default”]\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

2. Select the Search Logic you want to use to build your query from the drop-down. Options: \u00a0AND Find; OR Find<\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_column type=”3_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_image src=”https:\/\/datapost.co.za\/help\/wp-content\/uploads\/2020\/04\/Select-Field.jpg” title_text=”Select-Field” _builder_version=”4.5.3″ _module_preset=”default”][\/et_pb_image][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_text _builder_version=”4.5.3″ _module_preset=”default”]\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

3. Select the field you want to use in your query from the Search Field drop-down.<\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_column type=”3_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_image src=”https:\/\/datapost.co.za\/help\/wp-content\/uploads\/2020\/04\/Select-Search-Mode.jpg” title_text=”Select-Search-Mode” _builder_version=”4.5.3″ _module_preset=”default”][\/et_pb_image][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_text _builder_version=”4.5.3″ _module_preset=”default”]\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

4. Select the Search Mode you want to use in your search from the drop-down.\u00a0<\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ _builder_version=”4.5.3″ _module_preset=”default”][et_pb_column type=”3_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_image src=”https:\/\/datapost.co.za\/help\/wp-content\/uploads\/2020\/10\/Search-Builder-Add-Oct-2020.jpg” title_text=”Search Builder Add Oct 2020″ _builder_version=”4.5.3″ _module_preset=”default”][\/et_pb_image][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_text _builder_version=”4.5.3″ _module_preset=”default”]\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

\u00a05. Select the relevant Library Object from the drop-down and click on the Add button to add the search criteria to your query.<\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_column type=”3_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_image src=”https:\/\/datapost.co.za\/help\/wp-content\/uploads\/2020\/04\/Search-Query-1.jpg” title_text=”Search-Query-1″ _builder_version=”4.5.3″ _module_preset=”default”][\/et_pb_image][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_text _builder_version=”4.5.3″ _module_preset=”default”]\n

<\/figure>\n
\n

<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

6. Click on the Search button to run the query.<\/p>\n<\/div>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_column type=”3_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_image src=”https:\/\/datapost.co.za\/help\/wp-content\/uploads\/2020\/04\/Query-Results.jpg” title_text=”Query-Results” _builder_version=”4.5.3″ _module_preset=”default”][\/et_pb_image][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_text _builder_version=”4.5.3″ _module_preset=”default”]\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

\u00a07. Your search results will come up in the middle of the screen. If you are satisfied with your results, right-click on your results. \u00a0A menu will appear.\u00a0<\/span><\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_column type=”3_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_image src=”https:\/\/datapost.co.za\/help\/wp-content\/uploads\/2020\/04\/Save-Query.jpg” title_text=”Save-Query” _builder_version=”4.5.3″ _module_preset=”default”][\/et_pb_image][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_text _builder_version=”4.5.3″ _module_preset=”default”]\n

<\/figure>\n
\n

<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

8. \u00a0Move down to Result and across to the right. Click on Save Query. A new window will appear.<\/p>\n<\/div>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_column type=”3_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_image src=”https:\/\/datapost.co.za\/help\/wp-content\/uploads\/2020\/04\/Save-Query-Window.jpg” title_text=”Save-Query-Window” _builder_version=”4.5.3″ _module_preset=”default”][\/et_pb_image][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_text _builder_version=”4.5.3″ _module_preset=”default”]\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

9. Type the description of your query in the Query Label field and save.<\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_column type=”3_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_image src=”https:\/\/datapost.co.za\/help\/wp-content\/uploads\/2020\/05\/Drag-saved-query-into-content-list.jpg” title_text=”Drag-saved-query-into-content-list” _builder_version=”4.5.3″ _module_preset=”default”][\/et_pb_image][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_text _builder_version=”4.5.3″ _module_preset=”default”]\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

10. Drag and drop the saved query from your clipboard into the relevant content list. A container mode will have to be added to the saved query. Learn how below.<\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.5.3″ _module_preset=”default” locked=”off”][et_pb_column type=”4_4″ _builder_version=”4.5.3″ _module_preset=”default”][et_pb_text _builder_version=”4.5.3″ _module_preset=”default”]\n

Container modes explained<\/strong><\/h4>\n[\/et_pb_text][et_pb_text _builder_version=”4.5.3″ _module_preset=”default”]\n

What is a Container Mode?<\/strong><\/h4>\n

A Container Mode is an instruction the system gives the content in a container\/saved query, to behave in a certain way, when the content list plays.<\/p>\n[\/et_pb_text][et_pb_text _builder_version=”4.5.3″ _module_preset=”default”]\n

Types of Container Modes<\/strong><\/h4>\n
<\/h5>\n
<\/strong><\/h5>\n
<\/strong><\/h5>\n
Flatten<\/strong><\/h5>\n

When the system reaches the container, it will play all the media \u00a0in the container from top to bottom, and then move onto the next item in the content list.<\/p>\n[\/et_pb_text][et_pb_text _builder_version=”4.5.3″ _module_preset=”default”]\n

Consecutive – All<\/strong><\/h5>\n

The system will play the first piece of media in the container and then select the next in sequence to play every time it reaches the container.<\/p>\n[\/et_pb_text][et_pb_text _builder_version=”4.5.3″ _module_preset=”default”]\n

Consecutive \u2013 Best fit on Attributes\u00a0<\/strong><\/h5>\n

This container mode is used when scheduling within a network structure. The system will play the first piece of media in the container, with the best fit in terms of its media characteristics matching the player attributes. It will continue to select the next in sequence, \u00a0with the best fit, to play every time it reaches the container.<\/span><\/p>\n[\/et_pb_text][et_pb_text _builder_version=”4.5.3″ _module_preset=”default”]\n

Consecutive \u2013 Strict Match on Attributes<\/strong><\/h5>\n

This container mode is used when scheduling within a network structure. The system will play the first piece of media in the container that strict matches its media characteristics to the player attributes and will move down the list and continue doing so every time it reaches the container.<\/p>\n[\/et_pb_text][et_pb_text _builder_version=”4.5.3″ _module_preset=”default”]\n

Random – All<\/strong><\/h5>\n

The system will randomly pick a piece of media from the container to play every time it reaches the container.<\/p>\n[\/et_pb_text][et_pb_text _builder_version=”4.5.3″ _module_preset=”default”]\n

Random \u2013 Best fit on Attributes<\/strong><\/h5>\n

This container mode is used when scheduling within a network structure. The system will randomly pick a piece of media from the container, with the best fit in terms of its media characteristics matching the player attributes, \u00a0and continue doing so every time it reaches the container.<\/p>\n[\/et_pb_text][et_pb_text _builder_version=”4.5.3″ _module_preset=”default”]\n

Random \u2013 Strict Match on Attributes<\/strong><\/h5>\n

This container mode is used when scheduling within a network structure. The system will randomly pick a piece of media from the container that strict matches its media characteristics to the player attributes, to play every time it reaches the container.<\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_column type=”3_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_image src=”https:\/\/datapost.co.za\/help\/wp-content\/uploads\/2021\/02\/Right-click-on-Saved-Query-to-open-menu.jpg” title_text=”Corp-Dashboard-view” _builder_version=”4.5.3″ _module_preset=”default”][\/et_pb_image][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_text _builder_version=”4.5.3″ _module_preset=”default”]\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

\u00a01. Right-click on the saved query that you want to add the container mode to. A menu will appear.<\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_column type=”3_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_image src=”https:\/\/datapost.co.za\/help\/wp-content\/uploads\/2021\/02\/Right-clik-on-Saved-Query.jpg” title_text=”Corp-Dashboard-view” _builder_version=”4.5.3″ _module_preset=”default”][\/et_pb_image][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_text _builder_version=”4.5.3″ _module_preset=”default”]\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

2. Click on Container Mode. The Container Method window will open.<\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_column type=”3_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_image src=”https:\/\/datapost.co.za\/help\/wp-content\/uploads\/2019\/06\/Container-Mode-Window-Ilse-1.jpg” title_text=”Container-Mode-Window-Ilse-1″ _builder_version=”4.5.3″ _module_preset=”default”][\/et_pb_image][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.5.1″ _module_preset=”default”][et_pb_text _builder_version=”4.5.3″ _module_preset=”default”]\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

\u00a03. Click on the dot next to the container mode that you want to use. Remember to save your selection by clicking on the Save button in the bottom right corner of the window.<\/p>\n

Please note that when you drag a saved query\/container into a content list, the system automatically assigns the Flatten Container Mode.<\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.5.3″ _module_preset=”default”][et_pb_row _builder_version=”4.5.3″ _module_preset=”default”][et_pb_column type=”4_4″ _builder_version=”4.5.3″ _module_preset=”default”][et_pb_button button_url=”https:\/\/datapost.co.za\/help\/how-to-build-a-saved-query\/” button_text=”To Top” _builder_version=”4.5.3″ _module_preset=”default” custom_button=”on” button_text_color=”#e02b20″ button_icon=”%%17%%”][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"

What is a saved query? A saved query, is a collection of search criteria\/results, saved with a unique name that can be used across multiple content lists. A container mode will have to be added to the saved query to control the behaviour of the content in the saved query.Step-by-step guide on how to build […]<\/p>\n","protected":false},"author":148,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"\n

What is a saved query?<\/h3>\n\n\n\n

A saved query, is a collection of search criteria\/results, saved with a unique name that can be used across multiple content lists. A container mode will have to be added to the saved query to control the behaviour of the content in the saved query.<\/p>\n\n\n\n

How to build a saved query<\/h3>\n\n\n\n
\"\"<\/figure>
\n

\n\n1. Expand the Search Builder<\/em> in the panel on the left of the screen by clicking on the plus sign.\n\n<\/p>\n<\/div><\/div>\n\n\n\n

<\/div>\n\n\n\n
\"\"<\/figure>
\n

\n\n2. Select the Search Logic you want to use to build your query from the drop-down. Options:  AND Find; OR Find \n\n<\/p>\n<\/div><\/div>\n\n\n\n

<\/div>\n\n\n\n
\"\"<\/figure>
\n

\n\n3. Select the field you want to use in your query from the Search Field <\/em>drop-down.\n\n<\/p>\n<\/div><\/div>\n\n\n\n

<\/div>\n\n\n\n
\"\"<\/figure>
\n

\n\n4. Select the Search Mode<\/em> you want to use in your search from the drop-down. \n\n<\/p>\n<\/div><\/div>\n\n\n\n

<\/div>\n\n\n\n
\"\"<\/figure>
\n

5. Select the relevant Library Object from the drop-down and click on the Add<\/em> button to add the search criteria to your query.<\/p>\n<\/div><\/div>\n\n\n\n

<\/div>\n\n\n\n
\"\"<\/figure>
\n

6. Click on the Search<\/em> button to run the query. <\/p>\n<\/div><\/div>\n\n\n\n

<\/div>\n\n\n\n
\"\"<\/figure>
\n

7. Your search results will come up in the middle of the screen. If you are satisfied with your results, right-click on your results.  A menu will appear.  <\/p>\n<\/div><\/div>\n\n\n\n

<\/div>\n\n\n\n
\"\"<\/figure>
\n

8.  Move down to Result<\/em> and across to the right. Click on Save Query<\/em>. A new window will appear.  <\/p>\n<\/div><\/div>\n\n\n\n

<\/div>\n\n\n\n
\"\"<\/figure>
\n

9. Type the description of your query in the Query Label<\/em> field and save. <\/p>\n<\/div><\/div>\n\n\n\n

<\/div>\n\n\n\n
\"\"<\/figure>
\n

10. Drag and drop the saved query from your clipboard into the relevant content list. A container mode will have to be added to the saved query. Click on the link below to see how.<\/p>\n<\/div><\/div>\n\n\n\n

<\/div>\n\n\n\n

Let's add a container mode<\/strong><\/a><\/p>\n","_et_gb_content_width":"","footnotes":""},"class_list":["post-6255","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/datapost.co.za\/help\/wp-json\/wp\/v2\/pages\/6255","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/datapost.co.za\/help\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/datapost.co.za\/help\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/datapost.co.za\/help\/wp-json\/wp\/v2\/users\/148"}],"replies":[{"embeddable":true,"href":"https:\/\/datapost.co.za\/help\/wp-json\/wp\/v2\/comments?post=6255"}],"version-history":[{"count":58,"href":"https:\/\/datapost.co.za\/help\/wp-json\/wp\/v2\/pages\/6255\/revisions"}],"predecessor-version":[{"id":14110,"href":"https:\/\/datapost.co.za\/help\/wp-json\/wp\/v2\/pages\/6255\/revisions\/14110"}],"wp:attachment":[{"href":"https:\/\/datapost.co.za\/help\/wp-json\/wp\/v2\/media?parent=6255"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}