{"id":24072,"date":"2024-02-15T14:53:34","date_gmt":"2024-02-15T22:53:34","guid":{"rendered":"https:\/\/docs.extraview.com\/v25\/book\/value-qualifiers-1\/"},"modified":"2025-02-13T11:44:35","modified_gmt":"2025-02-13T19:44:35","slug":"value-qualifiers-1","status":"publish","type":"page","link":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/business-rules-1\/language-description-1\/value-qualifiers-1\/","title":{"rendered":"Value Qualifiers"},"content":{"rendered":"<p>Qualifiers are applied to fields stored within the Data Dictionary or special values to return a condition or special value. You apply the value qualifier to the dictionary name of the field. They may be entered as lower or upper case. Some directives may only be used within specific directives. These constraints are listed below in the last column of the table.<\/p>\n<h3>\n\tGeneral Value Qualifiers<\/h3>\n<table class=\"border\">\n<tbody>\n<tr class=\"tableHeaderRow\">\n<td>\n\t\t\t\tValue Qualifier<\/td>\n<td>\n\t\t\t\tPurpose<\/td>\n<td>\n\t\t\t\tUsed within Directives<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{changed}<\/td>\n<td>\n\t\t\t\tThis has two possible interpretations, both of which return true or false. First, this qualifies a change if a field value has been changed when the rule is triggered. For example, if you have a field named MY_FIELD and the user enters or selects a new value for the field, you can then trigger a rule such as:<br \/>\n\t\t\t\t&nbsp;<\/p>\n<div class=\"fixedWidthFont\">\n\t\t\t\t\tif (MY_FIELD.{changed}) {<br \/>\n\t\t\t\t\t&nbsp; ANOTHER_FIELD = &#8216;value&#8217;;<br \/>\n\t\t\t\t\t}<\/div>\n<p>The second use is when the <em>Add another<\/em> button on a repeating row has been pressed, and you want to perform an action on the repeating row that is being added. This is a change action that allows you to manipulate fields, usually to set values in the repeating row being added. An example of this usage, where you have a repeating row named RR_LAYOUT and you want to alter the value of a repeating row field named FIELD_NAME is:<\/p>\n<div class=\"fixedWidthFont\">\n\t\t\t\t\tif (RR_LAYOUT.{changed} &amp;&amp; RR_LAYOUT.{max_row_num} = 3) {<br \/>\n\t\t\t\t\t&nbsp;&nbsp;FIELD_NAME[3] = &#8216;value&#8217;;<br \/>\n\t\t\t\t\t}<\/div>\n<p>Note that the value of 3 in the above example means to change the values on the 4th row, as the first row is row zero, the second is row one, etc.<\/p>\n<\/td>\n<td>\n\t\t\t\tonchange preupdate<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{changed from:<em>value<\/em>}<\/td>\n<td>\n\t\t\t\tThis returns true if the last value of the field was <em>&#8216;Value&#8217;<\/em>, else it returns false<\/td>\n<td>\n\t\t\t\tonchange preupdate<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{changed to:<em>value<\/em>}<\/td>\n<td>\n\t\t\t\tThis returns true if the field is changed to the new value <em>&#8216;Value&#8217;<\/em>, else it returns false<\/td>\n<td>\n\t\t\t\tonchange preupdate<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{clear}<\/td>\n<td>\n\t\t\t\tThis clears the value in the field<\/td>\n<td>\n\t\t\t\tany<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{company name}<\/td>\n<td>\n\t\t\t\tThis may only be applied to a field with a display type of <em>user<\/em> and returns the company name of the user referred to<\/td>\n<td>\n\t\t\t\tany<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{contains <em>value1<\/em>[, <em>value2<\/em>, <em>valuen<\/em>, &#8230;]}<\/td>\n<td>\n\t\t\t\tUsed to determine if one or mores values are selected within a multi-valued list.&nbsp;<\/p>\n<p>\t\t\t\tIf you use the syntax <code>MULTI_VALUE_LIST1.{contains MULTI_VALUE_LIST2}<\/code> the expression will return true if all the the checked values in <code>MULTI_VALUE_LIST2<\/code> are also checked in <code>MULTI_VALUE_LIST1<\/code>.<\/td>\n<td>\n\t\t\t\tany<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{default}<\/td>\n<td>\n\t\t\t\tThis value qualifer is used to set a field to its default value from the data dictionary<\/td>\n<td>\n\t\t\t\tany<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{excludes <em>value1<\/em>[, <em>value2<\/em>, <em>valuen<\/em>, &#8230;]}<\/td>\n<td>\n\t\t\t\tUsed to determine if one or more values are not selected within a multi-valued list. This qualifier is only used with multi-valued fields<\/td>\n<td>\n\t\t\t\tany<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{exists}<\/td>\n<td>\n\t\t\t\tThis qualifier is only used within a link directive to check whether a value is present or not present<\/td>\n<td>\n\t\t\t\tany<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{is active}<\/td>\n<td>\n\t\t\t\tThis may only be applied to a field with a display type of <em>user<\/em> and returns true if the User field references an active user<\/td>\n<td>\n\t\t\t\tany<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{is external}<\/td>\n<td>\n\t\t\t\tThis may only be applied to a field with a display type of <em>user<\/em> and returns true if the User&#8217;s company name is different from the site company name, as defined by the behavior setting named COMPANY_NAME<\/td>\n<td>\n\t\t\t\tany<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{is guest}<\/td>\n<td>\n\t\t\t\tThis may only be applied to a field with a display type of <em>user<\/em> and returns true if the user\u2019s only role is the role defined by the behavior setting named LIMITED_USER_ROLE<\/td>\n<td>\n\t\t\t\tany<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{is inactive}<\/td>\n<td>\n\t\t\t\tThis may only be applied to a field with a display type of <em>user<\/em> and returns true if the User field references a deactivated user<\/td>\n<td>\n\t\t\t\tany<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{is internal}<\/td>\n<td>\n\t\t\t\tThis may only be applied to a field with a display type of <em>user<\/em> and returns true if the company name of the User field specified matches the site company name defined by the behavior setting named COMPANY_NAME<\/td>\n<td>\n\t\t\t\tany<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{like:<em>value<\/em>}<\/td>\n<td>\n\t\t\t\tThis performs a like comparison on the value of text fields, text area fields and log area fields, providing a return of true or false. Use must use either an asterisk (*) or a question mark (?) as a wild card character in the value that you are evaluating. You must use one or more wildcard characters in a single rule. If the string you are searching to match on may be in the middle of a value found, then you should use a wildcard at the beginning as well as at the end of the string.<\/p>\n<p>For example <span class=\"fixedWidthFont\">{like:nation*}<\/span> will find the word <b>national<\/b> but not the word <b>international<\/b>. However, <span class=\"fixedWidthFont\">{like:*nation*}<\/span> will find both <b>national<\/b> and <b>international<\/b>. This value qualifier is case-sensitive.<\/p>\n<p>If you are using the qualifier on a log area display type field, then only the most current entry is used in the comparison.<\/p>\n<\/td>\n<td>\n\t\t\t\tany<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{lowercase}<\/td>\n<td>\n\t\t\t\tThis qualifier returns the value passed to it, after converting the text to lower case.<\/td>\n<td>\n\t\t\t\tany<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{match:<em>value<\/em>}<\/td>\n<td>\n\t\t\t\tThis performs an exact match using a regular expression on the value of text fields, text area fields and log area fields, returning true or false. True is returned only if the entire value of the text matches the value in the rule. This value qualifier is case-sensitive.<\/p>\n<p>\t\t\t\tIf you are using the qualifier on a log area display type field, then only the most current entry is used in the comparison.<\/td>\n<td>\n\t\t\t\tany<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{max_row_num}<\/td>\n<td>\n\t\t\t\tThis qualifier is used only with repeating row layouts and is used to provide an action on a row. For example, given a repeating row layout named RR_LAYOUT, and wanting to set the value of a field named FIELD_NAME, you can use the construct:<\/p>\n<div class=\"fixedWidthFont\">\n\t\t\t\t\t&nbsp;<\/div>\n<div class=\"fixedWidthFont\">\n\t\t\t\t\tif (RR_LAYOUT.{max_row_num} = 3 &amp;&amp; RR_LAYOUT.{changed}) {<\/div>\n<div class=\"fixedWidthFont\">\n\t\t\t\t\t&nbsp; FIELD_NAME[3] = &#8216;value&#8217;;<\/div>\n<div class=\"fixedWidthFont\">\n\t\t\t\t\t}<\/div>\n<p>This changes the value of the FIELD_NAME on the fourth row of the layout, when that row is added to screen through the use of the <em>Add another<\/em> button on the repeating row layout. If you reference a row number that does not exist, an error is generated, of the form <span class=\"fixedWidthFont\">Repeating row index too large: FIELD_NAME<\/span>.<\/p>\n<p>This indicates that your rule will not ever execute properly, and you must change the rule to avoid the error. If you set the value of a field with such a rule, and any of the preceding repeating rows do not have a value set, then a null value is set into the value of the field on the preceding row.<\/p>\n<\/td>\n<td>\n\t\t\t\tonchange preupdate<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{not like:<em>value<\/em>}<\/td>\n<td>\n\t\t\t\tThis is used in the same manner as <code>{like:value}<\/code> but provides the negative result set to<code> {like:value}<\/code><\/td>\n<td>\n\t\t\t\tany<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{not null}<\/td>\n<td>\n\t\t\t\tThis returns true if the field is not null<\/td>\n<td>\n\t\t\t\tany<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{null}<\/td>\n<td>\n\t\t\t\tThis is true if the field is null<\/td>\n<td>\n\t\t\t\tany<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{old value}<\/td>\n<td>\n\t\t\t\tThis returns the prior value of the field<\/td>\n<td>\n\t\t\t\tonchange preupdate<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{owner}<\/td>\n<td>\n\t\t\t\tThis qualifier is used to determine whether the field referred to has the same value as the value of the built-in OWNER field<\/td>\n<td>\n\t\t\t\tany<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{uppercase}<\/td>\n<td>\n\t\t\t\tThis qualifier returns the value passed to it, converting all the text to upper case.<\/td>\n<td>\n\t\t\t\tany<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>\n\tDate \/ Time Value Qualifers for Date Calculations<\/h3>\n<p>These may be used within any directive.<\/p>\n<table class=\"border\">\n<tbody>\n<tr class=\"tableHeaderRow\">\n<td>\n\t\t\t\tValue Qualifier<\/td>\n<td>\n\t\t\t\tPurpose<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{days}<\/td>\n<td>\n\t\t\t\tThis value qualifier is applied date calculations to determine the number of days between two dates.<\/p>\n<p>For example:<\/p>\n<p>\t\t\t\t\t<span class=\"fixedWidthFont\">X_NUMBER = (X_DATE1 &#8211; X_DATE2).{days};<\/span><\/p>\n<p>will return the number of days as an integer, between <span class=\"fixedWidthFont\">X_DATE1<\/span> and <span class=\"fixedWidthFont\">X_DATE2<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{hours}<\/td>\n<td>\n\t\t\t\tThis value qualifier is applied date calculations to determine the number of hours between two dates.<\/p>\n<p>For example:<\/p>\n<p><span class=\"fixedWidthFont\">X_NUMBER = (X_DATE1 &#8211; X_DATE2).{hours};<\/span><\/p>\n<p>will return the number of hours as an integer, between <span class=\"fixedWidthFont\">X_DATE1<\/span> and <span class=\"fixedWidthFont\">X_DATE2<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{minutes}<\/td>\n<td>\n\t\t\t\tThis value qualifier is applied date calculations to determine the number of minutes between two dates. For example:<\/p>\n<p>\t\t\t\t<span class=\"fixedWidthFont\">X_NUMBER = (X_DATE1 &#8211; X_DATE2).{minutes};<\/span><\/p>\n<p>\t\t\t\twill return the number of minutes as an integer, between <span class=\"fixedWidthFont\">X_DATE1<\/span> and <span class=\"fixedWidthFont\">X_DATE2<\/span><\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{seconds}<\/td>\n<td>\n\t\t\t\tThis value qualifier is applied date calculations to determine the number of seconds between two dates.<\/p>\n<p>For example:<\/p>\n<p>\t\t\t\t\t<span class=\"fixedWidthFont\">X_NUMBER = (X_DATE1 &#8211; X_DATE2).{seconds};<\/span><\/p>\n<p>\t\t\t\t\twill return the number of seconds as an integer, between <span class=\"fixedWidthFont\">X_DATE1<\/span> and <span class=\"fixedWidthFont\">X_DATE2<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>\n\tDate \/ Time Value Qualifers for Date Component Manipulations<\/h3>\n<p>These may be used within any directive.&nbsp; You may apply the qualifier to fields with a display type of DATE or DAY.&nbsp; In addition you may apply the qualifiers to the values of SYSDAY and SYSDATE .<\/p>\n<table class=\"border\">\n<tbody>\n<tr class=\"tableHeaderRow\">\n<td>\n\t\t\t\tValue Qualifier<\/td>\n<td>\n\t\t\t\tPurpose<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{day}<\/td>\n<td>\n\t\t\t\tThe day number of the current month<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{day of week}<\/td>\n<td>\n\t\t\t\tThe day number of the current week<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{day of year}<\/td>\n<td>\n\t\t\t\tThe day number within the current year<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{hour}<\/td>\n<td>\n\t\t\t\tThe hour number of the morning or the afternoon<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{hour of day}<\/td>\n<td>\n\t\t\t\tThe hour of the day<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{minute}<\/td>\n<td>\n\t\t\t\tThe minute number within the current hour<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{month}<\/td>\n<td>\n\t\t\t\tThe number of the current month<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{second}<\/td>\n<td>\n\t\t\t\tThe second number within the current minute<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{week of month}<\/td>\n<td>\n\t\t\t\tThe week number within the current month<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{week of year}<\/td>\n<td>\n\t\t\t\tThe week number within the current year<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\" valign=\"top\">\n\t\t\t\t{year}<\/td>\n<td>\n\t\t\t\tThe year as a number<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>Examples:<\/strong><\/p>\n<p>Set a text field on an <em>add<\/em> or an <em>edit<\/em> screen to the day number within the current month:<\/p>\n<p><code>MY_TEXTFIELD = SYSDATE.{day};<\/code><\/p>\n<p>Within an expression, if a date field shows that it is the 8th day of the month, set a text field to a string:<\/p>\n<p><code>if (MY_DATEFiELD.{day} = 8) {MY_TEXTFIELD = 'Today is the 8th';}<\/code><\/p>\n<h3>\n\tUser Field Qualifiers<\/h3>\n<p>These may be used within any directive.&nbsp; Each field in a user&#8217;s record has a value qualifier that can be accessed with the syntax <span class=\"fixedWidthFont\">USER.{<em>userfield<\/em>}<\/span>. For example, if you want to assign the value of a user&#8217;s company name to the field name <code>COMP_NAME<\/code> on screen, you would use this:<\/p>\n<div class=\"fixedWidthFont\">\n\tCOMP_NAME = USER.{company name};<\/div>\n<p>This is a complete list of the user field qualifiers that may be used.<\/p>\n<table class=\"border\">\n<tbody>\n<tr class=\"tableHeaderRow\">\n<td>\n\t\t\t\tValue Qualifier<\/td>\n<td>\n\t\t\t\tPurpose<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{area}<\/td>\n<td>\n\t\t\t\tThe user&#8217;s default Business Area<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{address}<br \/>\n\t\t\t\t{address 1}<\/td>\n<td>\n\t\t\t\tThe first line of the user&#8217;s address<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{address 2}<\/td>\n<td>\n\t\t\t\tThe second line of the user&#8217;s address<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{city}<\/td>\n<td>\n\t\t\t\tThe city within the user&#8217;s address<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{cell phone}<\/td>\n<td>\n\t\t\t\tThe user&#8217;s cell phone number<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{company name}<\/td>\n<td>\n\t\t\t\tThe user&#8217;s company name<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{country}<\/td>\n<td>\n\t\t\t\tThe user&#8217;s country within their address<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{email}<\/td>\n<td>\n\t\t\t\tThe user&#8217;s email address<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{fax}<\/td>\n<td>\n\t\t\t\tThe user&#8217;s fax number<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{home phone}<\/td>\n<td>\n\t\t\t\tThe user&#8217;s home phone number<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{image}<\/td>\n<td>\n\t\t\t\tThe user&#8217;s image or photograph.&nbsp; Note that this can be assigned to an image field within an issue<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{job title}<\/td>\n<td>\n\t\t\t\tThe user&#8217;s job title<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{first name}<\/td>\n<td>\n\t\t\t\tThe user&#8217;s first name<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{language}<\/td>\n<td>\n\t\t\t\tThe user&#8217;s language &#8211; this is expressed as the two character abbreviation of the country code<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{last name}<\/td>\n<td>\n\t\t\t\tThe user&#8217;s last name<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{pager}<\/td>\n<td>\n\t\t\t\tThe user&#8217;s pager number<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{project}<\/td>\n<td>\n\t\t\t\tThe user&#8217;s default Project within their Business Area<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{state}<br \/>\n\t\t\t\t{province}<\/td>\n<td>\n\t\t\t\tThe user&#8217;s State or Province<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{region}<\/td>\n<td>\n\t\t\t\tThe user&#8217;s Region<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{signature}<\/td>\n<td>\n\t\t\t\tThe user&#8217;s signature.&nbsp; Note that this can be assigned to an image field within an issue<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{time zone}<\/td>\n<td>\n\t\t\t\tThe user&#8217;s time zone<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t<nobr>{user defined nn}<\/nobr><\/td>\n<td>\n\t\t\t\twhere <span class=\"fixedWidthFont\">nn<\/span> is a number from 1 to 10. These correspond to the user defined fields within the user&#8217;s record<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{work phone}<\/td>\n<td>\n\t\t\t\tThe user&#8217;s work phone number<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{zip}<br \/>\n\t\t\t\t{postal code}<\/td>\n<td>\n\t\t\t\tThe user&#8217;s Zip Code or Postal Code<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>\n\tDocument &amp; Image Field Qualifiers<\/h3>\n<p>The metadata within Document and Image field display types can be accessed with the following qualifiers:<\/p>\n<table class=\"border\">\n<tbody>\n<tr class=\"tableHeaderRow\">\n<td>\n\t\t\t\tValue Qualifier<\/td>\n<td>\n\t\t\t\tPurpose<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{charset}<\/td>\n<td>\n\t\t\t\tThe character set of the document or image<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{content type}<\/td>\n<td>\n\t\t\t\tThe content or mime type of the document or image<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{created by user}<\/td>\n<td>\n\t\t\t\tThe user ID of the person who created the document or image<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{external ident}<\/td>\n<td>\n\t\t\t\t<span style=\"background-color: rgb(255, 255, 255);\">A string containing key information to identify the object externally; this is opaque to ExtraView base code.&nbsp; This is not normally used in rules<\/span><\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{file desc}<\/td>\n<td>\n\t\t\t\tThe description of the document or image<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{file extension}<\/td>\n<td>\n\t\t\t\tThe extension of the document or image that was uploaded<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{file format}<\/td>\n<td>\n\t\t\t\tThe format of the document or image that was uploaded.&nbsp; For example, this may be BINARY or TEXT<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{file name}<\/td>\n<td>\n\t\t\t\tThe complete filename&nbsp;of the document or image that was uploaded<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{file size}<\/td>\n<td>\n\t\t\t\tThe size in bytes of the document or image that was uploaded<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{last updated by user}<\/td>\n<td>\n\t\t\t\tThe user ID of the person who uploaded the document or image<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{mime type}<\/td>\n<td>\n\t\t\t\tThe mime type of the document or image<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{thumbnail size}<\/td>\n<td>\n\t\t\t\tThe size in bytes of the thumbnail image of the document or image that was uploaded<\/td>\n<\/tr>\n<tr>\n<td class=\"fixedWidthFont\">\n\t\t\t\t{udf id}<\/td>\n<td>\n\t\t\t\tThe UDF_ID of the document or image that was uploaded<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Qualifiers are applied to fields stored within the Data Dictionary or special values to return a condition or special value. You apply the value qualifier to the dictionary name of the field. They may be entered as lower or upper case. Some directives may only be used within specific directives. These constraints are listed below&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":24034,"menu_order":4,"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-24072","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>Value Qualifiers - 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\/language-description-1\/value-qualifiers-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Value Qualifiers - Product Documentation\" \/>\n<meta property=\"og:description\" content=\"Qualifiers are applied to fields stored within the Data Dictionary or special values to return a condition or special value. You apply the value qualifier to the dictionary name of the field. They may be entered as lower or upper case. Some directives may only be used within specific directives. These constraints are listed below...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/business-rules-1\/language-description-1\/value-qualifiers-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Product Documentation\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-13T19:44:35+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=\"10 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\/business-rules-1\/language-description-1\/value-qualifiers-1\/\",\"url\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/business-rules-1\/language-description-1\/value-qualifiers-1\/\",\"name\":\"Value Qualifiers - Product Documentation\",\"isPartOf\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\"},\"datePublished\":\"2024-02-15T22:53:34+00:00\",\"dateModified\":\"2025-02-13T19:44:35+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/business-rules-1\/language-description-1\/value-qualifiers-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\/language-description-1\/value-qualifiers-1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/business-rules-1\/language-description-1\/value-qualifiers-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\":\"Language Description\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/business-rules-1\/language-description-1\/\"},{\"@type\":\"ListItem\",\"position\":7,\"name\":\"Value Qualifiers\"}]},{\"@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":"Value Qualifiers - 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\/language-description-1\/value-qualifiers-1\/","og_locale":"en_US","og_type":"article","og_title":"Value Qualifiers - Product Documentation","og_description":"Qualifiers are applied to fields stored within the Data Dictionary or special values to return a condition or special value. You apply the value qualifier to the dictionary name of the field. They may be entered as lower or upper case. Some directives may only be used within specific directives. These constraints are listed below...","og_url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/business-rules-1\/language-description-1\/value-qualifiers-1\/","og_site_name":"Product Documentation","article_modified_time":"2025-02-13T19:44:35+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"10 minutes"},"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\/language-description-1\/value-qualifiers-1\/","url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/business-rules-1\/language-description-1\/value-qualifiers-1\/","name":"Value Qualifiers - Product Documentation","isPartOf":{"@id":"https:\/\/docs.extraview.com\/v25\/#website"},"datePublished":"2024-02-15T22:53:34+00:00","dateModified":"2025-02-13T19:44:35+00:00","breadcrumb":{"@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/business-rules-1\/language-description-1\/value-qualifiers-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\/language-description-1\/value-qualifiers-1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/business-rules-1\/language-description-1\/value-qualifiers-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":"Language Description","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/business-rules-1\/language-description-1\/"},{"@type":"ListItem","position":7,"name":"Value Qualifiers"}]},{"@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\/24072","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=24072"}],"version-history":[{"count":0,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24072\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24034"}],"wp:attachment":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/media?parent=24072"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}