Expression Fields

Expression fields are used to calculate, and display the results of the calculation, on a column report, a Detailed report or a Quicklist report. For example, you might use a numeric expression to calculate the sum of two or more fields within an issue.  The Default value of the expression field may store an expression that will be evaluated as the default when the field is placed on a report. See the section in this guide for Reporting and Querying for a discussion of valid expressions.

Expression fields with a type of Duration are used as filters in queries, where they compute the value associated with a date or day field.  For example, you might use an expression to filter all the issues with a date created of last month.

This list shows the built-in expressions provided with ExtraView.  Adminstrators may create their own expressions.  It is recommended that you do not alter the value of the built-in duration expressions.  You may add additional expressions of any type.

Data dictionary field name Title Type
EVDTF_LAST_FISCAL_QUARTER Last fiscal quarter DURATION
EVDTF_LAST_FISCAL_YEAR Last fiscal year DURATION
EVDTF_LAST_FQ_TO_DATE Last fiscal quarter to date DURATION
EVDTF_LAST_FY_TO_DATE Last fiscal year to date DURATION
EVDTF_LAST_MONTH Last month DURATION
EVDTF_LAST_MONTH_TO_DATE Last month to date DURATION
EVDTF_LAST_WEEK Last week DURATION
EVDTF_LAST_WEEK_TO_DATE Last week to date DURATION
EVDTF_LAST_12_MONTHS Last 12 months DURATION
EVDTF_NEXT_4_WEEKS Next 4 weeks DURATION
EVDTF_NEXT_FISCAL_QUARTER Next fiscal quarter DURATION
EVDTF_NEXT_FISCAL_YEAR Next fiscal year DURATION
EVDTF_NEXT_MONTH Next month DURATION
EVDTF_NEXT_WEEK Next week DURATION
EVDTF_THIS_FISCAL_QUARTER This fiscal quarter DURATION
EVDTF_THIS_FISCAL_YEAR This fiscal year DURATION
EVDTF_THIS_FQ_TO_DATE This fiscal quarter to date DURATION
EVDTF_THIS_FY_TO_DATE This fiscal year to date DURATION
EVDTF_THIS_MONTH This month DURATION
EVDTF_THIS_MONTH_TO_DATE This month to date DURATION
EVDTF_THIS_WEEK This week DURATION
EVDTF_THIS_WEEK_TO_DATE This week to date DURATION
EVDTF_TODAY Today DURATION
EVDTF_YESTERDAY Yesterday DURATION
EXP_CURRENCY Expression - Currency CURRENCY
EXP_DATE Expression - Date DATE
EXP_DAY Expression - Day DAY
EXP_DECIMAL Expression - Decimal DECIMAL
EXP_NUMBER Expression - Number NUMBER
EXP_TEXTFIELD Expression - Text Field TEXTFIELD