Reserved Words

Reserved words can be used to add specific types of data to the filterset. These are provided in the dropdown list for the web application, but you must manually type them in for the desktop application. The available Reserved Words are described below:

Note: When using the reserved words above, make sure that you enter them in all uppercase letters and enclose them in percent symbols (%) and single quotes (').

• '%FISCALYEAR%' - You must own GBA Work Master to use this string. It uses the current fiscal year from the Planning and Budgeting, Fiscal Year module in the gbaMS Desktop application.
• '%CURRENTYEAR%' - Inserts the current calendar year.
• '%CURRENTQUARTER%' - Inserts the current quarter.
• '%CURRENTDAY%' - Inserts the current day.
• '%CURRENTWEEK%' - Inserts the current week.
• '%PREVIOUSDAY%'- Inserts the previous day.
• '%PREVIOUSWEEK%'-Inserts the previous week.
• '%PREVIOUSMONTH%'-Inserts the previous month.
• '%PREVIOUSYEAR%'-Inserts the previous year.
• '%FIRSTHALFOFTHEMONTH%' - Inserts the first half of the month (days 1-15).
• '%SECONDHALFOFTHEMONTH%' - Inserts the second half of the month (days 15-31).
• '%CURRENTMONTH%' - Inserts the current month.
• '%ONEWEEKAHEAD%' - Inserts the next week.
• '%TWOWEEKSAHEAD%' - Inserts the next two weeks.
• '%ONEWEEKAHEADANDBEFORE%' - Inserts seven ahead plus everything from the previous timespan. For example, you may use this string to query for all existing open work orders as well as those that are open/due in the next week.
• '%TWOWEEKSAHEADANDBEFORE%' - Inserts the next two weeks plus previous timespan.
• '%LOGGEDINUSERID%' - Allows you to filter on a Dashboard Frame or Frame Item based on the logged in User Name. Note that this is not on the Reserved Word list and must be manually entered into your filter.
• '%LOGGEDINEMPCODE%' - Inserts the current users employee code from the Work > Work Flow Setup > Employee module. This only works if the users login id is entered in the Login ID field on their employee record.

  Note: Reserved Words are NOT supported for:

• Access users
• Mobile Manager: as a filter sent to the field or for use in the field
• The Configure Live Data Layers tool in ArcGIS 9 or ArcGIS 10
• Work Routine Asset Filter