{"id":24112,"date":"2024-02-15T14:53:34","date_gmt":"2024-02-15T22:53:34","guid":{"rendered":"https:\/\/docs.extraview.com\/v25\/book\/complex-runtime-filters-1\/"},"modified":"2024-02-27T16:59:15","modified_gmt":"2024-02-28T00:59:15","slug":"complex-runtime-filters-1","status":"publish","type":"page","link":"https:\/\/docs.extraview.com\/v25\/complex-runtime-filters-1\/","title":{"rendered":"Complex Runtime Filters"},"content":{"rendered":"

There are occasions when you might want a user to run a report that has a complex set of advanced filters, including the use of several and<\/b> and or<\/b> conjunctions. For example, you might want to pose the following query filters (this is not a real query, but it is useful as an example):<\/p>\n

\u00a0\u00a0\u00a0(Customer = * Ask at runtime *<\/b> AND Status = Open<\/b>)<\/div>\n
OR (Customer = * Ask at runtime *<\/b> AND Status = Fixed<\/b>)<\/div>\n
OR (Customer = * Ask at runtime *<\/b> AND Status = Duplicate<\/b>)<\/div>\n

This would be represented in the report editor like this:<\/p>\n

<\/p>\n

When the report is run, the user will see the following screen:<\/p>\n

When the user selects a customer from the top list, all the bottom filters that require a Customer will be set to use the value set from the top list. To accomplish this type of query with complex runtime filters, you set up Session Variable type fields in the Data Dictionary. Session Variable fields are created as follows:<\/p>\n

    \n
  • Administration<\/b> menu<\/li>\n
  • Site Configuration<\/b> tab<\/li>\n
  • Data Dictionary<\/b> menu<\/li>\n
  • Session Variables<\/b> tab<\/li>\n
  • Add<\/b> button<\/li>\n
  • Provide a Fixed Name<\/b> for the field<\/li>\n
  • Provide a Title<\/b> for the field. It is helpful to use a title like Choose the XXXXX<\/em> so that the runtime filter will show a useful title. Obviously, XXXXX<\/em> represents the title of the filter field<\/li>\n
  • Choose the Display Type<\/b> for the field. It is important to understand that you need a session variable field for every filter that you will use in your complex queries, and that the display type must match the display type of the filter field it is being used with<\/li>\n
  • Add<\/b> the field to the data dictionary.<\/li>\n<\/ul>\n

    Once this has been done, you will see that the advanced filter lists look something like this to the end users:<\/p>\n

    <\/p>\n

    Note that the Session Variables appear at the bottom of list fields. If you are using the Session Variable as a filter within a text, date or number field, you should enter it as $$FIELD_NAME$$, substituting FIELD_NAME with the name of your Session Variable field.<\/p>\n","protected":false},"excerpt":{"rendered":"

    There are occasions when you might want a user to run a report that has a complex set of advanced filters, including the use of several and and or conjunctions. For example, you might want to pose the following query filters (this is not a real query, but it is useful as an example): \u00a0\u00a0\u00a0(Customer…<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_lmt_disableupdate":"","_lmt_disable":"","_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"class_list":["post-24112","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"\nComplex Runtime Filters - Product Documentation<\/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:\/\/docs.extraview.com\/v25\/complex-runtime-filters-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Complex Runtime Filters - Product Documentation\" \/>\n<meta property=\"og:description\" content=\"There are occasions when you might want a user to run a report that has a complex set of advanced filters, including the use of several and and or conjunctions. For example, you might want to pose the following query filters (this is not a real query, but it is useful as an example): \u00a0\u00a0\u00a0(Customer...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.extraview.com\/v25\/complex-runtime-filters-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Product Documentation\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-28T00:59:15+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\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:\/\/docs.extraview.com\/v25\/complex-runtime-filters-1\/\",\"url\":\"https:\/\/docs.extraview.com\/v25\/complex-runtime-filters-1\/\",\"name\":\"Complex Runtime Filters - Product Documentation\",\"isPartOf\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\"},\"datePublished\":\"2024-02-15T22:53:34+00:00\",\"dateModified\":\"2024-02-28T00:59:15+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/complex-runtime-filters-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.extraview.com\/v25\/complex-runtime-filters-1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/complex-runtime-filters-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.extraview.com\/v25\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Complex Runtime Filters\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\",\"url\":\"https:\/\/docs.extraview.com\/v25\/\",\"name\":\"ExtraView Product Documentation\",\"description\":\"ExtraView Documentation\",\"publisher\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/docs.extraview.com\/v25\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#organization\",\"name\":\"ExtraView Corporation\",\"url\":\"https:\/\/docs.extraview.com\/v25\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png\",\"contentUrl\":\"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png\",\"width\":512,\"height\":512,\"caption\":\"ExtraView Corporation\"},\"image\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Complex Runtime Filters - Product Documentation","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:\/\/docs.extraview.com\/v25\/complex-runtime-filters-1\/","og_locale":"en_US","og_type":"article","og_title":"Complex Runtime Filters - Product Documentation","og_description":"There are occasions when you might want a user to run a report that has a complex set of advanced filters, including the use of several and and or conjunctions. For example, you might want to pose the following query filters (this is not a real query, but it is useful as an example): \u00a0\u00a0\u00a0(Customer...","og_url":"https:\/\/docs.extraview.com\/v25\/complex-runtime-filters-1\/","og_site_name":"Product Documentation","article_modified_time":"2024-02-28T00:59:15+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/docs.extraview.com\/v25\/complex-runtime-filters-1\/","url":"https:\/\/docs.extraview.com\/v25\/complex-runtime-filters-1\/","name":"Complex Runtime Filters - Product Documentation","isPartOf":{"@id":"https:\/\/docs.extraview.com\/v25\/#website"},"datePublished":"2024-02-15T22:53:34+00:00","dateModified":"2024-02-28T00:59:15+00:00","breadcrumb":{"@id":"https:\/\/docs.extraview.com\/v25\/complex-runtime-filters-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.extraview.com\/v25\/complex-runtime-filters-1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.extraview.com\/v25\/complex-runtime-filters-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.extraview.com\/v25\/"},{"@type":"ListItem","position":2,"name":"Complex Runtime Filters"}]},{"@type":"WebSite","@id":"https:\/\/docs.extraview.com\/v25\/#website","url":"https:\/\/docs.extraview.com\/v25\/","name":"ExtraView Product Documentation","description":"ExtraView Documentation","publisher":{"@id":"https:\/\/docs.extraview.com\/v25\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/docs.extraview.com\/v25\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/docs.extraview.com\/v25\/#organization","name":"ExtraView Corporation","url":"https:\/\/docs.extraview.com\/v25\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/","url":"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png","contentUrl":"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png","width":512,"height":512,"caption":"ExtraView Corporation"},"image":{"@id":"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/"}}]}},"taxonomy_info":[],"featured_image_src_large":false,"author_info":{"display_name":"carl.koppel","author_link":"https:\/\/docs.extraview.com\/v25\/author\/carl-koppel\/"},"comment_info":0,"_links":{"self":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24112","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/comments?post=24112"}],"version-history":[{"count":0,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24112\/revisions"}],"wp:attachment":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/media?parent=24112"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}