{"id":5232,"date":"2024-07-01T17:06:54","date_gmt":"2024-07-01T15:06:54","guid":{"rendered":"https:\/\/help.r2docuo.com\/knowledge-base\/advanced-query-configuration\/"},"modified":"2024-07-10T12:56:34","modified_gmt":"2024-07-10T10:56:34","slug":"advanced-query-configuration","status":"publish","type":"ht_kb","link":"https:\/\/help.r2docuo.com\/en\/knowledge-base\/advanced-query-configuration\/","title":{"rendered":"Advanced Query Configuration"},"content":{"rendered":"\n<p>When we create a query in R2 Docuo, we choose its category, the fields to be displayed in columns, the conditions that restrict its results and the parameters to be asked to the user.<\/p>\n\n<p>Docuo queries can be used for a variety of purposes, the most typical being:<\/p>\n\n<ul class=\"wp-block-list\">\n<li>Use them in a <strong>Start menu button<\/strong>.<\/li>\n\n\n\n<li>Use them directly in the <strong>query tree<\/strong> (green).<\/li>\n\n\n\n<li>Use them in the display of a <strong>tab in the detail window<\/strong>.<\/li>\n<\/ul>\n\n<p>In this article we will explain how, once created, we can configure additional aspects of the behavior of a query.<\/p>\n\n<h2 class=\"wp-block-heading\">How to access the configuration window of an existing query<\/h2>\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-alert\">The configuration window of a query can only be accessed from R2 Docuo for Windows.<\/p>\n\n<p>Step 1: Using a user account <strong>with administrative privileges<\/strong>, open the query.<\/p>\n\n<p>Step 2: Locate the three vertical dots icon next to the title:<\/p>\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"380\" height=\"247\" src=\"https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image.png\" alt=\"\" class=\"wp-image-5218\" srcset=\"https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image.png 380w, https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-50x33.png 50w, https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-60x39.png 60w, https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-100x65.png 100w\" sizes=\"auto, (max-width: 380px) 100vw, 380px\" \/><\/figure>\n\n<p>Step 3: In the pop-up menu, choose the &#8220;Settings&#8221; option.<\/p>\n\n<h2 class=\"wp-block-heading\">Configure the buttons available in the &#8220;toolbar&#8221; of the query<\/h2>\n\n<p>The queries display a series of actions in the top button bar:<\/p>\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"842\" height=\"364\" src=\"https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-2.png\" alt=\"\" class=\"wp-image-5222\" srcset=\"https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-2.png 842w, https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-2-600x259.png 600w, https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-2-768x332.png 768w, https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-2-50x22.png 50w, https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-2-60x26.png 60w, https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-2-100x43.png 100w\" sizes=\"auto, (max-width: 842px) 100vw, 842px\" \/><\/figure>\n\n<p>From the configuration window of a query, we can define which of these buttons should be available and which should be hidden:<\/p>\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"698\" height=\"425\" src=\"https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-3.png\" alt=\"\" class=\"wp-image-5224\" srcset=\"https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-3.png 698w, https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-3-600x365.png 600w, https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-3-50x30.png 50w, https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-3-60x37.png 60w, https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-3-100x61.png 100w\" sizes=\"auto, (max-width: 698px) 100vw, 698px\" \/><\/figure>\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\">The deleted actions will also not be available in the context menu (right mouse button).<\/p>\n\n<p>By deactivating actions, the button bar will be much cleaner, showing only what makes sense for the purpose of the query:<\/p>\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"839\" height=\"336\" src=\"https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-4.png\" alt=\"\" class=\"wp-image-5226\" srcset=\"https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-4.png 839w, https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-4-600x240.png 600w, https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-4-768x308.png 768w, https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-4-50x20.png 50w, https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-4-60x24.png 60w, https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-4-100x40.png 100w\" sizes=\"auto, (max-width: 839px) 100vw, 839px\" \/><\/figure>\n\n<h2 class=\"wp-block-heading\">Set the placement and width of columns and order of results for all users<\/h2>\n\n<p>In general, users are free to drag the columns of a query to position them as they wish, change their width and choose the order in which the results are displayed.<\/p>\n\n<p>Sometimes, it is convenient for a query to have a &#8220;fixed&#8221; position and order of columns and results for all users.  <\/p>\n\n<p>To achieve this, we must first set the query to our liking as any user would do.<\/p>\n\n<p>When we have the consutla ready, we will access the Configuration window and click on the &#8220;Use current&#8221; button:<\/p>\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"698\" height=\"425\" src=\"https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-5.png\" alt=\"\" class=\"wp-image-5228\" srcset=\"https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-5.png 698w, https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-5-600x365.png 600w, https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-5-50x30.png 50w, https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-5-60x37.png 60w, https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-5-100x61.png 100w\" sizes=\"auto, (max-width: 698px) 100vw, 698px\" \/><\/figure>\n\n<p>This takes a &#8220;snapshot&#8221; of our current layout and applies it to all users:  <\/p>\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"710\" height=\"452\" src=\"https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-6.png\" alt=\"\" class=\"wp-image-5230\" srcset=\"https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-6.png 710w, https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-6-600x382.png 600w, https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-6-50x32.png 50w, https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-6-60x38.png 60w, https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image-6-100x64.png 100w\" sizes=\"auto, (max-width: 710px) 100vw, 710px\" \/><\/figure>\n\n<p>Now all users will see the query columns and results exactly as you see them. You can change the order and layout temporarily, but as soon as you click &#8220;Refresh&#8221; or run the query again, you will return to the preset order.<\/p>\n\n<p>To deactivate this function and return to allowing each user to have his or her particular query layout, simply slide the &#8220;On&#8221; switch.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When we create a query in R2 Docuo, we choose its category, the fields to be displayed in columns, the conditions that restrict its results and the parameters to be asked to the user. Docuo queries can be used for a variety of purposes, the most typical being: In this&#8230;<\/p>\n","protected":false},"author":1,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"content-type":"","footnotes":""},"ht-kb-category":[72],"ht-kb-tag":[],"class_list":["post-5232","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-administrators"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Advanced Query Configuration - R2 Docuo | Help center<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Advanced Query Configuration - R2 Docuo | Help center\" \/>\n<meta property=\"og:description\" content=\"When we create a query in R2 Docuo, we choose its category, the fields to be displayed in columns, the conditions that restrict its results and the parameters to be asked to the user. Docuo queries can be used for a variety of purposes, the most typical being: In this...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/help.r2docuo.com\/en\/knowledge-base\/advanced-query-configuration\/\" \/>\n<meta property=\"og:site_name\" content=\"R2 Docuo | Help center\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-10T10:56:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@R2Docuo\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/help.r2docuo.com\\\/en\\\/knowledge-base\\\/advanced-query-configuration\\\/\",\"url\":\"https:\\\/\\\/help.r2docuo.com\\\/en\\\/knowledge-base\\\/advanced-query-configuration\\\/\",\"name\":\"Advanced Query Configuration - R2 Docuo | Help center\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/help.r2docuo.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/help.r2docuo.com\\\/en\\\/knowledge-base\\\/advanced-query-configuration\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/help.r2docuo.com\\\/en\\\/knowledge-base\\\/advanced-query-configuration\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/help.r2docuo.com\\\/wp-content\\\/uploads\\\/2024\\\/07\\\/image.png\",\"datePublished\":\"2024-07-01T15:06:54+00:00\",\"dateModified\":\"2024-07-10T10:56:34+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/help.r2docuo.com\\\/en\\\/knowledge-base\\\/advanced-query-configuration\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/help.r2docuo.com\\\/en\\\/knowledge-base\\\/advanced-query-configuration\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/help.r2docuo.com\\\/en\\\/knowledge-base\\\/advanced-query-configuration\\\/#primaryimage\",\"url\":\"https:\\\/\\\/help.r2docuo.com\\\/wp-content\\\/uploads\\\/2024\\\/07\\\/image.png\",\"contentUrl\":\"https:\\\/\\\/help.r2docuo.com\\\/wp-content\\\/uploads\\\/2024\\\/07\\\/image.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/help.r2docuo.com\\\/en\\\/knowledge-base\\\/advanced-query-configuration\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/help.r2docuo.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Advanced Query Configuration\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/help.r2docuo.com\\\/#website\",\"url\":\"https:\\\/\\\/help.r2docuo.com\\\/\",\"name\":\"R2 Docuo | Help center\",\"description\":\"Todos los recursos para usuarios, administradores y desarrolladores de de R2 Docuo a tu alcance\",\"publisher\":{\"@id\":\"https:\\\/\\\/help.r2docuo.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/help.r2docuo.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/help.r2docuo.com\\\/#organization\",\"name\":\"R2 Docuo | Help center\",\"url\":\"https:\\\/\\\/help.r2docuo.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/help.r2docuo.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/help.r2docuo.com\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/ILUDEST_CENTRODEAYUDA.png\",\"contentUrl\":\"https:\\\/\\\/help.r2docuo.com\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/ILUDEST_CENTRODEAYUDA.png\",\"width\":1200,\"height\":630,\"caption\":\"R2 Docuo | Help center\"},\"image\":{\"@id\":\"https:\\\/\\\/help.r2docuo.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/R2Docuo\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/r2docuo\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Advanced Query Configuration - R2 Docuo | Help center","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"Advanced Query Configuration - R2 Docuo | Help center","og_description":"When we create a query in R2 Docuo, we choose its category, the fields to be displayed in columns, the conditions that restrict its results and the parameters to be asked to the user. Docuo queries can be used for a variety of purposes, the most typical being: In this...","og_url":"https:\/\/help.r2docuo.com\/en\/knowledge-base\/advanced-query-configuration\/","og_site_name":"R2 Docuo | Help center","article_modified_time":"2024-07-10T10:56:34+00:00","og_image":[{"url":"https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_site":"@R2Docuo","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/help.r2docuo.com\/en\/knowledge-base\/advanced-query-configuration\/","url":"https:\/\/help.r2docuo.com\/en\/knowledge-base\/advanced-query-configuration\/","name":"Advanced Query Configuration - R2 Docuo | Help center","isPartOf":{"@id":"https:\/\/help.r2docuo.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/help.r2docuo.com\/en\/knowledge-base\/advanced-query-configuration\/#primaryimage"},"image":{"@id":"https:\/\/help.r2docuo.com\/en\/knowledge-base\/advanced-query-configuration\/#primaryimage"},"thumbnailUrl":"https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image.png","datePublished":"2024-07-01T15:06:54+00:00","dateModified":"2024-07-10T10:56:34+00:00","breadcrumb":{"@id":"https:\/\/help.r2docuo.com\/en\/knowledge-base\/advanced-query-configuration\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/help.r2docuo.com\/en\/knowledge-base\/advanced-query-configuration\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/help.r2docuo.com\/en\/knowledge-base\/advanced-query-configuration\/#primaryimage","url":"https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image.png","contentUrl":"https:\/\/help.r2docuo.com\/wp-content\/uploads\/2024\/07\/image.png"},{"@type":"BreadcrumbList","@id":"https:\/\/help.r2docuo.com\/en\/knowledge-base\/advanced-query-configuration\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/help.r2docuo.com\/"},{"@type":"ListItem","position":2,"name":"Advanced Query Configuration"}]},{"@type":"WebSite","@id":"https:\/\/help.r2docuo.com\/#website","url":"https:\/\/help.r2docuo.com\/","name":"R2 Docuo | Help center","description":"Todos los recursos para usuarios, administradores y desarrolladores de de R2 Docuo a tu alcance","publisher":{"@id":"https:\/\/help.r2docuo.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/help.r2docuo.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/help.r2docuo.com\/#organization","name":"R2 Docuo | Help center","url":"https:\/\/help.r2docuo.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/help.r2docuo.com\/#\/schema\/logo\/image\/","url":"https:\/\/help.r2docuo.com\/wp-content\/uploads\/2023\/06\/ILUDEST_CENTRODEAYUDA.png","contentUrl":"https:\/\/help.r2docuo.com\/wp-content\/uploads\/2023\/06\/ILUDEST_CENTRODEAYUDA.png","width":1200,"height":630,"caption":"R2 Docuo | Help center"},"image":{"@id":"https:\/\/help.r2docuo.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/R2Docuo","https:\/\/www.linkedin.com\/company\/r2docuo"]}]}},"_links":{"self":[{"href":"https:\/\/help.r2docuo.com\/en\/wp-json\/wp\/v2\/ht-kb\/5232","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.r2docuo.com\/en\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/help.r2docuo.com\/en\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/help.r2docuo.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/help.r2docuo.com\/en\/wp-json\/wp\/v2\/comments?post=5232"}],"version-history":[{"count":0,"href":"https:\/\/help.r2docuo.com\/en\/wp-json\/wp\/v2\/ht-kb\/5232\/revisions"}],"wp:attachment":[{"href":"https:\/\/help.r2docuo.com\/en\/wp-json\/wp\/v2\/media?parent=5232"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/help.r2docuo.com\/en\/wp-json\/wp\/v2\/ht-kb-category?post=5232"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/help.r2docuo.com\/en\/wp-json\/wp\/v2\/ht-kb-tag?post=5232"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}