{"id":1189,"date":"2013-07-12T18:23:41","date_gmt":"2013-07-12T18:23:41","guid":{"rendered":"https:\/\/clarionsharp.com\/blog\/?p=1189"},"modified":"2013-07-12T18:23:41","modified_gmt":"2013-07-12T18:23:41","slug":"c9-dictionary-search","status":"publish","type":"post","link":"https:\/\/clarionsharp.com\/blog\/c9-dictionary-search\/","title":{"rendered":"C9 &#8211; Dictionary Search"},"content":{"rendered":"<p>The Dictionary Editor search functionality allows you to search within a selected Dictionary entity , or all of the Dictionary entities (Tables\/Columns\/Keys\/Relations\/Pool Fields and Global Fields).<br \/>\n<a href=\"https:\/\/clarionsharp.com\/blog\/wp-content\/uploads\/2013\/07\/DCTsearch1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1194\" alt=\"DCTsearch1\" src=\"https:\/\/clarionsharp.com\/blog\/wp-content\/uploads\/2013\/07\/DCTsearch1.png\" width=\"418\" height=\"75\" srcset=\"https:\/\/clarionsharp.com\/blog\/wp-content\/uploads\/2013\/07\/DCTsearch1.png 418w, https:\/\/clarionsharp.com\/blog\/wp-content\/uploads\/2013\/07\/DCTsearch1-300x53.png 300w\" sizes=\"auto, (max-width: 418px) 100vw, 418px\" \/><\/a> <a href=\"https:\/\/clarionsharp.com\/blog\/wp-content\/uploads\/2013\/07\/DCTsearch2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1195\" alt=\"DCTsearch2\" src=\"https:\/\/clarionsharp.com\/blog\/wp-content\/uploads\/2013\/07\/DCTsearch2.png\" width=\"952\" height=\"308\" srcset=\"https:\/\/clarionsharp.com\/blog\/wp-content\/uploads\/2013\/07\/DCTsearch2.png 952w, https:\/\/clarionsharp.com\/blog\/wp-content\/uploads\/2013\/07\/DCTsearch2-300x97.png 300w\" sizes=\"auto, (max-width: 952px) 100vw, 952px\" \/><\/a><br \/>\nThe Search allows you to match any property for the entity you are interested in, for example when searching against Tables, you can search against Name, Description, Prefix, Driver, Driver Options, Owner, Full Path, Create, Encrypt, Bindable, Creation date and Modified date.<\/p>\n<p>You can also build very complex searches that combine multiple conditions. The screenshot above is an example of a multi-condition search, where we are searching all fields for the presence of &#8220;ID&#8221; and where the data types is not a LONG.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Dictionary Editor search functionality allows you to search within a selected Dictionary entity , or all of the Dictionary entities (Tables\/Columns\/Keys\/Relations\/Pool Fields and Global Fields). The Search allows you to match any property for the entity you are interested in, for example when searching against Tables, you can search against Name, Description, Prefix, Driver, &hellip; <a href=\"https:\/\/clarionsharp.com\/blog\/c9-dictionary-search\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">C9 &#8211; Dictionary Search<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31,5],"tags":[],"class_list":["post-1189","post","type-post","status-publish","format-standard","hentry","category-clarion9","category-clarionnews"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>C9 - Dictionary Search  - Clarion<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/clarionsharp.com\/blog\/c9-dictionary-search\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C9 - Dictionary Search  - Clarion\" \/>\n<meta property=\"og:description\" content=\"The Dictionary Editor search functionality allows you to search within a selected Dictionary entity , or all of the Dictionary entities (Tables\/Columns\/Keys\/Relations\/Pool Fields and Global Fields). The Search allows you to match any property for the entity you are interested in, for example when searching against Tables, you can search against Name, Description, Prefix, Driver, &hellip; Continue reading C9 &#8211; Dictionary Search &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/clarionsharp.com\/blog\/c9-dictionary-search\/\" \/>\n<meta property=\"og:site_name\" content=\"Clarion\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/softvelocity\/\" \/>\n<meta property=\"article:published_time\" content=\"2013-07-12T18:23:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/clarionsharp.com\/blog\/wp-content\/uploads\/2013\/07\/DCTsearch1.png\" \/>\n<meta name=\"author\" content=\"rzaunere\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"rzaunere\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/c9-dictionary-search\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/c9-dictionary-search\\\/\"},\"author\":{\"name\":\"rzaunere\",\"@id\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/#\\\/schema\\\/person\\\/b90e860529aea05ad064cf2687697ce3\"},\"headline\":\"C9 &#8211; Dictionary Search\",\"datePublished\":\"2013-07-12T18:23:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/c9-dictionary-search\\\/\"},\"wordCount\":116,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/c9-dictionary-search\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/wp-content\\\/uploads\\\/2013\\\/07\\\/DCTsearch1.png\",\"articleSection\":[\"Clarion 9\",\"Clarion News\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/c9-dictionary-search\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/c9-dictionary-search\\\/\",\"url\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/c9-dictionary-search\\\/\",\"name\":\"C9 - Dictionary Search - Clarion\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/c9-dictionary-search\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/c9-dictionary-search\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/wp-content\\\/uploads\\\/2013\\\/07\\\/DCTsearch1.png\",\"datePublished\":\"2013-07-12T18:23:41+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/c9-dictionary-search\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/c9-dictionary-search\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/c9-dictionary-search\\\/#primaryimage\",\"url\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/wp-content\\\/uploads\\\/2013\\\/07\\\/DCTsearch1.png\",\"contentUrl\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/wp-content\\\/uploads\\\/2013\\\/07\\\/DCTsearch1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/c9-dictionary-search\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C9 &#8211; Dictionary Search\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/\",\"name\":\"Clarion\",\"description\":\"Deliver your software on time, every time\",\"publisher\":{\"@id\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/#organization\",\"name\":\"SoftVelocity\",\"url\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/03\\\/svlogonew57.png\",\"contentUrl\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/03\\\/svlogonew57.png\",\"width\":221,\"height\":57,\"caption\":\"SoftVelocity\"},\"image\":{\"@id\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/softvelocity\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/SoftVelocity\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/#\\\/schema\\\/person\\\/b90e860529aea05ad064cf2687697ce3\",\"name\":\"rzaunere\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/91d95e38759c411d27f646b60da7f4769ce91e87b484669af240e51c729b1e7c?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/91d95e38759c411d27f646b60da7f4769ce91e87b484669af240e51c729b1e7c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/91d95e38759c411d27f646b60da7f4769ce91e87b484669af240e51c729b1e7c?s=96&d=mm&r=g\",\"caption\":\"rzaunere\"},\"url\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/author\\\/rzaunere\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"C9 - Dictionary Search  - Clarion","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/clarionsharp.com\/blog\/c9-dictionary-search\/","og_locale":"en_US","og_type":"article","og_title":"C9 - Dictionary Search  - Clarion","og_description":"The Dictionary Editor search functionality allows you to search within a selected Dictionary entity , or all of the Dictionary entities (Tables\/Columns\/Keys\/Relations\/Pool Fields and Global Fields). The Search allows you to match any property for the entity you are interested in, for example when searching against Tables, you can search against Name, Description, Prefix, Driver, &hellip; Continue reading C9 &#8211; Dictionary Search &rarr;","og_url":"https:\/\/clarionsharp.com\/blog\/c9-dictionary-search\/","og_site_name":"Clarion","article_publisher":"https:\/\/www.facebook.com\/softvelocity\/","article_published_time":"2013-07-12T18:23:41+00:00","og_image":[{"url":"https:\/\/clarionsharp.com\/blog\/wp-content\/uploads\/2013\/07\/DCTsearch1.png","type":"","width":"","height":""}],"author":"rzaunere","twitter_card":"summary_large_image","twitter_misc":{"Written by":"rzaunere","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/clarionsharp.com\/blog\/c9-dictionary-search\/#article","isPartOf":{"@id":"https:\/\/clarionsharp.com\/blog\/c9-dictionary-search\/"},"author":{"name":"rzaunere","@id":"https:\/\/clarionsharp.com\/blog\/#\/schema\/person\/b90e860529aea05ad064cf2687697ce3"},"headline":"C9 &#8211; Dictionary Search","datePublished":"2013-07-12T18:23:41+00:00","mainEntityOfPage":{"@id":"https:\/\/clarionsharp.com\/blog\/c9-dictionary-search\/"},"wordCount":116,"commentCount":0,"publisher":{"@id":"https:\/\/clarionsharp.com\/blog\/#organization"},"image":{"@id":"https:\/\/clarionsharp.com\/blog\/c9-dictionary-search\/#primaryimage"},"thumbnailUrl":"https:\/\/clarionsharp.com\/blog\/wp-content\/uploads\/2013\/07\/DCTsearch1.png","articleSection":["Clarion 9","Clarion News"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/clarionsharp.com\/blog\/c9-dictionary-search\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/clarionsharp.com\/blog\/c9-dictionary-search\/","url":"https:\/\/clarionsharp.com\/blog\/c9-dictionary-search\/","name":"C9 - Dictionary Search - Clarion","isPartOf":{"@id":"https:\/\/clarionsharp.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/clarionsharp.com\/blog\/c9-dictionary-search\/#primaryimage"},"image":{"@id":"https:\/\/clarionsharp.com\/blog\/c9-dictionary-search\/#primaryimage"},"thumbnailUrl":"https:\/\/clarionsharp.com\/blog\/wp-content\/uploads\/2013\/07\/DCTsearch1.png","datePublished":"2013-07-12T18:23:41+00:00","breadcrumb":{"@id":"https:\/\/clarionsharp.com\/blog\/c9-dictionary-search\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/clarionsharp.com\/blog\/c9-dictionary-search\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/clarionsharp.com\/blog\/c9-dictionary-search\/#primaryimage","url":"https:\/\/clarionsharp.com\/blog\/wp-content\/uploads\/2013\/07\/DCTsearch1.png","contentUrl":"https:\/\/clarionsharp.com\/blog\/wp-content\/uploads\/2013\/07\/DCTsearch1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/clarionsharp.com\/blog\/c9-dictionary-search\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/clarionsharp.com\/blog\/"},{"@type":"ListItem","position":2,"name":"C9 &#8211; Dictionary Search"}]},{"@type":"WebSite","@id":"https:\/\/clarionsharp.com\/blog\/#website","url":"https:\/\/clarionsharp.com\/blog\/","name":"Clarion","description":"Deliver your software on time, every time","publisher":{"@id":"https:\/\/clarionsharp.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/clarionsharp.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/clarionsharp.com\/blog\/#organization","name":"SoftVelocity","url":"https:\/\/clarionsharp.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/clarionsharp.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/clarionsharp.com\/blog\/wp-content\/uploads\/2019\/03\/svlogonew57.png","contentUrl":"https:\/\/clarionsharp.com\/blog\/wp-content\/uploads\/2019\/03\/svlogonew57.png","width":221,"height":57,"caption":"SoftVelocity"},"image":{"@id":"https:\/\/clarionsharp.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/softvelocity\/","https:\/\/www.youtube.com\/user\/SoftVelocity"]},{"@type":"Person","@id":"https:\/\/clarionsharp.com\/blog\/#\/schema\/person\/b90e860529aea05ad064cf2687697ce3","name":"rzaunere","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/91d95e38759c411d27f646b60da7f4769ce91e87b484669af240e51c729b1e7c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/91d95e38759c411d27f646b60da7f4769ce91e87b484669af240e51c729b1e7c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/91d95e38759c411d27f646b60da7f4769ce91e87b484669af240e51c729b1e7c?s=96&d=mm&r=g","caption":"rzaunere"},"url":"https:\/\/clarionsharp.com\/blog\/author\/rzaunere\/"}]}},"_links":{"self":[{"href":"https:\/\/clarionsharp.com\/blog\/wp-json\/wp\/v2\/posts\/1189","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/clarionsharp.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/clarionsharp.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/clarionsharp.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/clarionsharp.com\/blog\/wp-json\/wp\/v2\/comments?post=1189"}],"version-history":[{"count":4,"href":"https:\/\/clarionsharp.com\/blog\/wp-json\/wp\/v2\/posts\/1189\/revisions"}],"predecessor-version":[{"id":1209,"href":"https:\/\/clarionsharp.com\/blog\/wp-json\/wp\/v2\/posts\/1189\/revisions\/1209"}],"wp:attachment":[{"href":"https:\/\/clarionsharp.com\/blog\/wp-json\/wp\/v2\/media?parent=1189"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/clarionsharp.com\/blog\/wp-json\/wp\/v2\/categories?post=1189"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/clarionsharp.com\/blog\/wp-json\/wp\/v2\/tags?post=1189"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}