{"id":4200,"date":"2021-03-15T19:20:22","date_gmt":"2021-03-15T18:20:22","guid":{"rendered":"https:\/\/help.r2docuo.com\/knowledge-base\/find-and-detailfind-functions-find-a-value-in-a-dropdown-list\/"},"modified":"2023-11-21T12:29:35","modified_gmt":"2023-11-21T11:29:35","slug":"find-and-detailfind-functions-find-a-value-in-a-dropdown-list","status":"publish","type":"ht_kb","link":"https:\/\/help.r2docuo.com\/en\/knowledge-base\/find-and-detailfind-functions-find-a-value-in-a-dropdown-list\/","title":{"rendered":"Find and detailFind functions – Find a value in a Dropdown List"},"content":{"rendered":"

Through the Find and detailFind functions, fields of the Drop Down List to Another Category (LDAOC) type can be defined by means of a formula.<\/p>\n

A formula in this type of field must return one of three possible results:<\/p>\n

    \n
  1. A number corresponding to the ID of a document.<\/li>\n
  2. A text corresponding to the code of a document.<\/li>\n
  3. The result of a call to the Find<\/strong> function.<\/li>\n
  4. The result of a call to the detailFind<\/strong> function.<\/li>\n<\/ol>\n
    Document.find(Order,[Condici\u00f3n] )<\/tt><\/div>\n

    The function returns the first document found according to the specified order and conditions.<\/p>\n

    Document.detailFind(Field_list, Order,[Condici\u00f3n] )<\/tt><\/div>\n

    The function returns the first document found in a detail tab of the current document, according to the specified order and conditions.<\/p>\n

    Where:<\/p>\n

    Field_list<\/strong> : is the name of the Drop-Down List in the child category, where the document of the parent category is selected. Its syntax is that of a tag type< @CodeCategory:Group:Field<\/strong>> . For example, in the Country<\/em> category, we can search among its Provinces<\/em> by entering the value in Campo_lista:<\/p>\n

    '<@PRV:Data:Country>'<\/tt><\/div>\n

    Order<\/strong> : is an ordering text string. Indicates by which field or fields we want to order the results. The syntax must include the name of one or more fields separated by commas. After each of them we will specify the ASC or DESC clause to indicate the ordering sense. For example, to find the first Province<\/em> of the Country<\/em> in alphabetical order, Order should have the value:<\/p>\n

    '< @PRV:Properties:Name> ASC'<\/tt><\/div>\n

    Condition<\/strong> : is an optional parameter with a T-SQL condition text string of the same type used in Dropdown Lists. It allows us to filter the search results. For example, to search only among the Provinces<\/em> of this Country<\/em> that begin with Al<\/em> , we would use the value for Condition:<\/p>\n

    \"<@PRV:Properties:Name> LIKE 'Al%'\"<\/tt><\/div>\n

    If the Country<\/em> were Spain<\/em> , the value in this list would automatically show \u00c1lava<\/em> .<\/p>\n","protected":false},"excerpt":{"rendered":"

    Through the Find and detailFind functions, fields of the Drop Down List to Another Category (LDAOC) type can be defined by means of a formula. A formula in this type of field must return one of three possible results: A number corresponding to the ID of a document. A text…<\/p>\n","protected":false},"author":1,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"content-type":"","footnotes":""},"ht-kb-category":[62],"ht-kb-tag":[83],"class_list":["post-4200","ht_kb","type-ht_kb","status-publish","format-standard","has-post-thumbnail","hentry","ht_kb_category-functions-javascript","ht_kb_tag-docuo-enterprise"],"yoast_head":"\nFind and detailFind functions - Find a value in a Dropdown List - R2 Docuo | Help center<\/title>\n<meta name=\"description\" content=\"Through the Find and detailFind functions, fields of type Dropdown List to Other Category can be defined by means of a formula.\" \/>\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=\"Find and detailFind functions - Find a value in a Dropdown List - R2 Docuo | Help center\" \/>\n<meta property=\"og:description\" content=\"Through the Find and detailFind functions, fields of type Dropdown List to Other Category can be defined by means of a formula.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/help.r2docuo.com\/en\/knowledge-base\/find-and-detailfind-functions-find-a-value-in-a-dropdown-list\/\" \/>\n<meta property=\"og:site_name\" content=\"R2 Docuo | Help center\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-21T11:29:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/help.r2docuo.com\/wp-content\/uploads\/2021\/03\/Post-type-Guias-de-usuario.png\" \/>\n\t<meta property=\"og:image:width\" content=\"845\" \/>\n\t<meta property=\"og:image:height\" content=\"564\" \/>\n\t<meta property=\"og:image:type\" content=\"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\\\/find-and-detailfind-functions-find-a-value-in-a-dropdown-list\\\/\",\"url\":\"https:\\\/\\\/help.r2docuo.com\\\/en\\\/knowledge-base\\\/find-and-detailfind-functions-find-a-value-in-a-dropdown-list\\\/\",\"name\":\"Find and detailFind functions - Find a value in a Dropdown List - R2 Docuo | Help center\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/help.r2docuo.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/help.r2docuo.com\\\/en\\\/knowledge-base\\\/find-and-detailfind-functions-find-a-value-in-a-dropdown-list\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/help.r2docuo.com\\\/en\\\/knowledge-base\\\/find-and-detailfind-functions-find-a-value-in-a-dropdown-list\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/help.r2docuo.com\\\/wp-content\\\/uploads\\\/2021\\\/03\\\/Post-type-Guias-de-usuario.png\",\"datePublished\":\"2021-03-15T18:20:22+00:00\",\"dateModified\":\"2023-11-21T11:29:35+00:00\",\"description\":\"Through the Find and detailFind functions, fields of type Dropdown List to Other Category can be defined by means of a formula.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/help.r2docuo.com\\\/en\\\/knowledge-base\\\/find-and-detailfind-functions-find-a-value-in-a-dropdown-list\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/help.r2docuo.com\\\/en\\\/knowledge-base\\\/find-and-detailfind-functions-find-a-value-in-a-dropdown-list\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/help.r2docuo.com\\\/en\\\/knowledge-base\\\/find-and-detailfind-functions-find-a-value-in-a-dropdown-list\\\/#primaryimage\",\"url\":\"https:\\\/\\\/help.r2docuo.com\\\/wp-content\\\/uploads\\\/2021\\\/03\\\/Post-type-Guias-de-usuario.png\",\"contentUrl\":\"https:\\\/\\\/help.r2docuo.com\\\/wp-content\\\/uploads\\\/2021\\\/03\\\/Post-type-Guias-de-usuario.png\",\"width\":845,\"height\":564},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/help.r2docuo.com\\\/en\\\/knowledge-base\\\/find-and-detailfind-functions-find-a-value-in-a-dropdown-list\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/help.r2docuo.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Find and detailFind functions – Find a value in a Dropdown List\"}]},{\"@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":"Find and detailFind functions - Find a value in a Dropdown List - R2 Docuo | Help center","description":"Through the Find and detailFind functions, fields of type Dropdown List to Other Category can be defined by means of a formula.","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":"Find and detailFind functions - Find a value in a Dropdown List - R2 Docuo | Help center","og_description":"Through the Find and detailFind functions, fields of type Dropdown List to Other Category can be defined by means of a formula.","og_url":"https:\/\/help.r2docuo.com\/en\/knowledge-base\/find-and-detailfind-functions-find-a-value-in-a-dropdown-list\/","og_site_name":"R2 Docuo | Help center","article_modified_time":"2023-11-21T11:29:35+00:00","og_image":[{"width":845,"height":564,"url":"https:\/\/help.r2docuo.com\/wp-content\/uploads\/2021\/03\/Post-type-Guias-de-usuario.png","type":"image\/png"}],"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\/find-and-detailfind-functions-find-a-value-in-a-dropdown-list\/","url":"https:\/\/help.r2docuo.com\/en\/knowledge-base\/find-and-detailfind-functions-find-a-value-in-a-dropdown-list\/","name":"Find and detailFind functions - Find a value in a Dropdown List - R2 Docuo | Help center","isPartOf":{"@id":"https:\/\/help.r2docuo.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/help.r2docuo.com\/en\/knowledge-base\/find-and-detailfind-functions-find-a-value-in-a-dropdown-list\/#primaryimage"},"image":{"@id":"https:\/\/help.r2docuo.com\/en\/knowledge-base\/find-and-detailfind-functions-find-a-value-in-a-dropdown-list\/#primaryimage"},"thumbnailUrl":"https:\/\/help.r2docuo.com\/wp-content\/uploads\/2021\/03\/Post-type-Guias-de-usuario.png","datePublished":"2021-03-15T18:20:22+00:00","dateModified":"2023-11-21T11:29:35+00:00","description":"Through the Find and detailFind functions, fields of type Dropdown List to Other Category can be defined by means of a formula.","breadcrumb":{"@id":"https:\/\/help.r2docuo.com\/en\/knowledge-base\/find-and-detailfind-functions-find-a-value-in-a-dropdown-list\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/help.r2docuo.com\/en\/knowledge-base\/find-and-detailfind-functions-find-a-value-in-a-dropdown-list\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/help.r2docuo.com\/en\/knowledge-base\/find-and-detailfind-functions-find-a-value-in-a-dropdown-list\/#primaryimage","url":"https:\/\/help.r2docuo.com\/wp-content\/uploads\/2021\/03\/Post-type-Guias-de-usuario.png","contentUrl":"https:\/\/help.r2docuo.com\/wp-content\/uploads\/2021\/03\/Post-type-Guias-de-usuario.png","width":845,"height":564},{"@type":"BreadcrumbList","@id":"https:\/\/help.r2docuo.com\/en\/knowledge-base\/find-and-detailfind-functions-find-a-value-in-a-dropdown-list\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/help.r2docuo.com\/"},{"@type":"ListItem","position":2,"name":"Find and detailFind functions – Find a value in a Dropdown List"}]},{"@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\/4200","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=4200"}],"version-history":[{"count":0,"href":"https:\/\/help.r2docuo.com\/en\/wp-json\/wp\/v2\/ht-kb\/4200\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/help.r2docuo.com\/en\/wp-json\/wp\/v2\/media\/4053"}],"wp:attachment":[{"href":"https:\/\/help.r2docuo.com\/en\/wp-json\/wp\/v2\/media?parent=4200"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/help.r2docuo.com\/en\/wp-json\/wp\/v2\/ht-kb-category?post=4200"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/help.r2docuo.com\/en\/wp-json\/wp\/v2\/ht-kb-tag?post=4200"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}