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_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 |
