{"id":24009,"date":"2024-02-15T14:53:34","date_gmt":"2024-02-15T22:53:34","guid":{"rendered":"https:\/\/docs.extraview.com\/v25\/book\/id-and-altid-fields-1\/"},"modified":"2025-03-06T09:18:31","modified_gmt":"2025-03-06T17:18:31","slug":"id-and-altid-fields-1","status":"publish","type":"page","link":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/special-purpose-fields-1\/id-and-altid-fields-1\/","title":{"rendered":"ID and ALT_ID Fields"},"content":{"rendered":"<p>Each item added to the ExtraView database is automatically given an ID. The ID is a sequence which is incremented by one for each issue that is inserted into the database. The field is always read-only to users and developers. It may be used as a filter on reports. The ID is the primary key to all items. The sequence is applied without reference to which Business Area or Project to which the item belongs. For some purposes it is useful to have a unique sequence per Business Area or per Project, with the items within each Business Area or Project being given sequential numbers.<\/p>\n<p>Further, it can be advantageous to provide formatting to this identifier to easily distinguish items in different Business Areas\/Projects. This can be achieved through the use of the ALT_ID field. The ID field is still maintained automatically within ExtraView, but the mechanism described here can be set up to provide a unique sequence within the ALT_ID field. You should only set up this mechanism on a new database as existing items are not back-populated with the ALT_ID values. To set up separate sequences for each Business Area:<\/p>\n<ul>\n<li>Within the data dictionary entry for the ALT_ID field, place a pattern in the default value of ALT_ID<\/li>\n<li>You should not use the characters <code>&lt;<\/code> and <code>&gt;<\/code> within ALT_ID titles<img decoding=\"async\" style=\"width: 90%;\" src=\"\/v25\/extraview-media\/images\/ag\/fields_and_layouts\/alt-id-entry.png\" \/><br \/>\n<cite>Entering the ALT_ID pattern<\/cite><\/p>\n<p>This pattern is created as follows:<\/p>\n<ul>\n<li><strong>$$AREA.SEQ$$<\/strong>. This is the unique sequence for the area within which the item is being created. You should always include this<\/li>\n<li><strong>$$AREA.SHORT_TITLE$$<\/strong>. This is an optional set of characters entered into the definition for the Business Area. For example, you may provide a short title in the Business Area maintenance screen of CR to define a change request and a short title of FR to indicate a feature request. You enter the short title into the <strong>Abbreviated title for ALT_ID<\/strong> field<img decoding=\"async\" style=\"width: 90%;\" src=\"\/v25\/extraview-media\/images\/ag\/fields_and_layouts\/alt-id-title2.png\" \/><br \/>\n<cite>Entering an abbreviated title for the ALT_ID<\/cite><\/li>\n<li>Any constant string. For example, you may include punctuation characters such as : and \u2013<\/li>\n<li>Replaceable variables of the form <strong>$$<em>FIELD_NAME<\/em>$$<\/strong>. These allow the use of other fields on the input form to become part of the ALT_ID<\/li>\n<li>You must not use a space character within the pattern.\u00a0 This ensures that keyword searching is kept simple within installations that have enabled ALT_ID<\/li>\n<li>Set a starting number for the sequence at the prompt <strong>Starting sequence number for ALT_ID<\/strong><\/li>\n<\/ul>\n<\/li>\n<li>You must set the behavior setting <strong>ITEM_ID_DISPLAY<\/strong> to a value of ALT_ID<\/li>\n<li>Place the ALT_ID field onto all appropriate layouts as opposed to using the ID field. Typically this will be the <em>add, edit, detailed report, Quicklist<\/em> and other similar layouts. You may still set a layout cell attribute of FIELD\/LAYOUT VISIBLE IF ID is not null to hide the ALT_ID before the item is saved.<\/li>\n<li>If you clone an issue, then the new ALT_ID is generated from the default pattern if it is writeable, and the default value for ALT_ID is non-empty.<\/li>\n<\/ul>\n<p>To use this feature for Projects, within the definition for the PROJECT field, use the above instructions with <strong>$$PROJECT.SEQ$$<\/strong> as opposed to <strong>$$AREA.SEQ$$<\/strong>.<\/p>\n<p>Examples:<\/p>\n<table class=\"border\">\n<tbody>\n<tr>\n<td>ALT_ID Default Value<\/td>\n<td>Example Output<\/td>\n<\/tr>\n<tr>\n<td><strong>$$AREA.SHORT_TITLE$$:$$AREA.SEQ$$<\/strong><\/td>\n<td>FR:12345<\/td>\n<\/tr>\n<tr>\n<td><strong>$$AREA.SEQ$$($$AREA.SHORT_TITLE$$)<\/strong><\/td>\n<td>12345(CR)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Fields<\/h3>\n<table class=\"border\">\n<tbody>\n<tr>\n<td>Field Name<\/td>\n<td>Title<\/td>\n<td>Definition<\/td>\n<\/tr>\n<tr>\n<td>ALT_ID_START_SINCE<\/td>\n<td>Start Issue ID<\/td>\n<td>In conjunction with ALT_ID_STOP_SINCE, this field is used to establish a search range for issues on any query filter layout. Both this and ALT_ID_STOP_SINCE should be created on the layout. The user can enter the start of a range to search for in this field. If it\u2019s left blank, but the ALT_ID_STOP_SINCE field has a value, then all issues with values less than ALT_ID_STOP_SINCE will be returned<\/td>\n<\/tr>\n<tr>\n<td>ALT_ID_STOP_SINCE<\/td>\n<td>Stop Issue ID<\/td>\n<td>In conjunction with ALT_ID_START_SINCE, this field is used to establish a search range for issues on any query filter layout. Both this and ALT_ID_START_SINCE should be created on the layout. The user can enter the end of a range to search for in this field. If it\u2019s left blank, but the ALT_ID_START_SINCE field has a value, then all issues with values greater than ALT_ID_START_SINCE will be returned<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>Each item added to the ExtraView database is automatically given an ID. The ID is a sequence which is incremented by one for each issue that is inserted into the database. The field is always read-only to users and developers. It may be used as a filter on reports. The ID is the primary key&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":24000,"menu_order":10,"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-24009","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>ID and ALT_ID Fields - 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\/data-dictionary-4\/special-purpose-fields-1\/id-and-altid-fields-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ID and ALT_ID Fields - Product Documentation\" \/>\n<meta property=\"og:description\" content=\"Each item added to the ExtraView database is automatically given an ID. The ID is a sequence which is incremented by one for each issue that is inserted into the database. The field is always read-only to users and developers. It may be used as a filter on reports. The ID is the primary key...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/special-purpose-fields-1\/id-and-altid-fields-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Product Documentation\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-06T17:18:31+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=\"4 minutes\" \/>\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\/data-dictionary-4\/special-purpose-fields-1\/id-and-altid-fields-1\/\",\"url\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/special-purpose-fields-1\/id-and-altid-fields-1\/\",\"name\":\"ID and ALT_ID Fields - Product Documentation\",\"isPartOf\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\"},\"datePublished\":\"2024-02-15T22:53:34+00:00\",\"dateModified\":\"2025-03-06T17:18:31+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/special-purpose-fields-1\/id-and-altid-fields-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/special-purpose-fields-1\/id-and-altid-fields-1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/special-purpose-fields-1\/id-and-altid-fields-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\":\"Data Dictionary\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/\"},{\"@type\":\"ListItem\",\"position\":6,\"name\":\"Special Purpose Fields\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/special-purpose-fields-1\/\"},{\"@type\":\"ListItem\",\"position\":7,\"name\":\"ID and ALT_ID Fields\"}]},{\"@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":"ID and ALT_ID Fields - 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\/data-dictionary-4\/special-purpose-fields-1\/id-and-altid-fields-1\/","og_locale":"en_US","og_type":"article","og_title":"ID and ALT_ID Fields - Product Documentation","og_description":"Each item added to the ExtraView database is automatically given an ID. The ID is a sequence which is incremented by one for each issue that is inserted into the database. The field is always read-only to users and developers. It may be used as a filter on reports. The ID is the primary key...","og_url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/special-purpose-fields-1\/id-and-altid-fields-1\/","og_site_name":"Product Documentation","article_modified_time":"2025-03-06T17:18:31+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/special-purpose-fields-1\/id-and-altid-fields-1\/","url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/special-purpose-fields-1\/id-and-altid-fields-1\/","name":"ID and ALT_ID Fields - Product Documentation","isPartOf":{"@id":"https:\/\/docs.extraview.com\/v25\/#website"},"datePublished":"2024-02-15T22:53:34+00:00","dateModified":"2025-03-06T17:18:31+00:00","breadcrumb":{"@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/special-purpose-fields-1\/id-and-altid-fields-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/special-purpose-fields-1\/id-and-altid-fields-1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/special-purpose-fields-1\/id-and-altid-fields-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":"Data Dictionary","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/"},{"@type":"ListItem","position":6,"name":"Special Purpose Fields","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/special-purpose-fields-1\/"},{"@type":"ListItem","position":7,"name":"ID and ALT_ID Fields"}]},{"@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\/24009","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=24009"}],"version-history":[{"count":0,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24009\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24000"}],"wp:attachment":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/media?parent=24009"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}