{"id":24076,"date":"2024-02-15T14:53:34","date_gmt":"2024-02-15T22:53:34","guid":{"rendered":"https:\/\/docs.extraview.com\/v25\/book\/limitations-1\/"},"modified":"2025-02-13T13:12:12","modified_gmt":"2025-02-13T21:12:12","slug":"limitations-1","status":"publish","type":"page","link":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/business-rules-1\/writing-rules-1\/limitations-1\/","title":{"rendered":"Limitations"},"content":{"rendered":"<ul>\n<li>\n\t\tRules may only use fields that physically store their value in the database or use the special values as specified above. They will not work with computed fields from the data dictionary. For example, you cannot create a rule that uses these fields:<\/p>\n<ul>\n<li>\n\t\t\t\tDATE_CLOSED_SINCE<\/li>\n<li>\n\t\t\t\tDATE_CREATED_DAY<\/li>\n<li>\n\t\t\t\tDATE_CREATED_MONTH<\/li>\n<li>\n\t\t\t\tDATE_CREATED_WEEK<\/li>\n<li>\n\t\t\t\tDATE_CREATED_TRUNC<\/li>\n<li>\n\t\t\t\tDATE_CREATED_YEAR<\/li>\n<li>\n\t\t\t\tDATE_LAST_STATUS_CHANGED_SINCE<\/li>\n<li>\n\t\t\t\tDAYS_IN_STATUS<\/li>\n<li>\n\t\t\t\tDAYS_OPEN<\/li>\n<li>\n\t\t\t\tMONTHS_OPEN<\/li>\n<li>\n\t\t\t\tWEEKS_OPEN<\/li>\n<li>\n\t\t\t\tTIMESTAMP_MONTH<\/li>\n<li>\n\t\t\t\tTIMESTAMP_SINCE<\/li>\n<li>\n\t\t\t\tTIMESTAMP_TRUNC<\/li>\n<li>\n\t\t\t\tTIMESTAMP_WEEK<\/li>\n<li>\n\t\t\t\tTIMESTAMP_YEAR<\/li>\n<li>\n\t\t\t\tWEEKS_IN_STATUS<\/li>\n<li>\n\t\t\t\tWEEKS_OPEN<\/li>\n<li>\n\t\t\t\tAny field with a display type of <em>Label<\/em><\/li>\n<li>\n\t\t\t\tAny field with a display type of <em>Custom<\/em>.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p class=\"rteindent1\">However, you can often provide your own expression in a rule to derive the same information. For example, to calculate the number of days since the creation of an issue you may create a field named <b>MY_DAYS_OPEN<\/b> with a display type of <b>Number<\/b> and then construct a rule such as:<\/p>\n<p>\t<span class=\"fixedWidthFont\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MY_DAYS_OPEN = (SYSDATE &#8211; DATE_CREATED).{days};<\/span><br \/>\n\t&nbsp;<\/p>\n<ul>\n<li>\n\t\tThis version of the Rules Engine does not support multi-value UDF\u2019s on repeating rows.<\/li>\n<li>\n\t\tRules cannot be localized with this version. All values should use the title or value of the field in the base locale, as opposed to a localized value.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Rules may only use fields that physically store their value in the database or use the special values as specified above. They will not work with computed fields from the data dictionary. For example, you cannot create a rule that uses these fields: DATE_CLOSED_SINCE DATE_CREATED_DAY DATE_CREATED_MONTH DATE_CREATED_WEEK DATE_CREATED_TRUNC DATE_CREATED_YEAR DATE_LAST_STATUS_CHANGED_SINCE DAYS_IN_STATUS DAYS_OPEN MONTHS_OPEN WEEKS_OPEN TIMESTAMP_MONTH&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":24074,"menu_order":1,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_lmt_disableupdate":"no","_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-24076","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Limitations - 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\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/business-rules-1\/writing-rules-1\/limitations-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Limitations - Product Documentation\" \/>\n<meta property=\"og:description\" content=\"Rules may only use fields that physically store their value in the database or use the special values as specified above. They will not work with computed fields from the data dictionary. For example, you cannot create a rule that uses these fields: DATE_CLOSED_SINCE DATE_CREATED_DAY DATE_CREATED_MONTH DATE_CREATED_WEEK DATE_CREATED_TRUNC DATE_CREATED_YEAR DATE_LAST_STATUS_CHANGED_SINCE DAYS_IN_STATUS DAYS_OPEN MONTHS_OPEN WEEKS_OPEN TIMESTAMP_MONTH...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/business-rules-1\/writing-rules-1\/limitations-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Product Documentation\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-13T21:12:12+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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/business-rules-1\/writing-rules-1\/limitations-1\/\",\"url\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/business-rules-1\/writing-rules-1\/limitations-1\/\",\"name\":\"Limitations - Product Documentation\",\"isPartOf\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\"},\"datePublished\":\"2024-02-15T22:53:34+00:00\",\"dateModified\":\"2025-02-13T21:12:12+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/business-rules-1\/writing-rules-1\/limitations-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/business-rules-1\/writing-rules-1\/limitations-1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/business-rules-1\/writing-rules-1\/limitations-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.extraview.com\/v25\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ExtraView 25\",\"item\":\"https:\/\/docs.extraview.com\/v25\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Administration Guide\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Site Configuration Menu\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Business Rules\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/business-rules-1\/\"},{\"@type\":\"ListItem\",\"position\":6,\"name\":\"Writing Rules\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/business-rules-1\/writing-rules-1\/\"},{\"@type\":\"ListItem\",\"position\":7,\"name\":\"Limitations\"}]},{\"@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":"Limitations - 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\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/business-rules-1\/writing-rules-1\/limitations-1\/","og_locale":"en_US","og_type":"article","og_title":"Limitations - Product Documentation","og_description":"Rules may only use fields that physically store their value in the database or use the special values as specified above. They will not work with computed fields from the data dictionary. For example, you cannot create a rule that uses these fields: DATE_CLOSED_SINCE DATE_CREATED_DAY DATE_CREATED_MONTH DATE_CREATED_WEEK DATE_CREATED_TRUNC DATE_CREATED_YEAR DATE_LAST_STATUS_CHANGED_SINCE DAYS_IN_STATUS DAYS_OPEN MONTHS_OPEN WEEKS_OPEN TIMESTAMP_MONTH...","og_url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/business-rules-1\/writing-rules-1\/limitations-1\/","og_site_name":"Product Documentation","article_modified_time":"2025-02-13T21:12:12+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/business-rules-1\/writing-rules-1\/limitations-1\/","url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/business-rules-1\/writing-rules-1\/limitations-1\/","name":"Limitations - Product Documentation","isPartOf":{"@id":"https:\/\/docs.extraview.com\/v25\/#website"},"datePublished":"2024-02-15T22:53:34+00:00","dateModified":"2025-02-13T21:12:12+00:00","breadcrumb":{"@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/business-rules-1\/writing-rules-1\/limitations-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/business-rules-1\/writing-rules-1\/limitations-1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/business-rules-1\/writing-rules-1\/limitations-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.extraview.com\/v25\/"},{"@type":"ListItem","position":2,"name":"ExtraView 25","item":"https:\/\/docs.extraview.com\/v25\/"},{"@type":"ListItem","position":3,"name":"Administration Guide","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/"},{"@type":"ListItem","position":4,"name":"Site Configuration Menu","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/"},{"@type":"ListItem","position":5,"name":"Business Rules","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/business-rules-1\/"},{"@type":"ListItem","position":6,"name":"Writing Rules","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/business-rules-1\/writing-rules-1\/"},{"@type":"ListItem","position":7,"name":"Limitations"}]},{"@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\/24076","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=24076"}],"version-history":[{"count":0,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24076\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24074"}],"wp:attachment":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/media?parent=24076"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}