Using Variable Expressions

Use of variable expression when defining filter criteria.

You can use variable expressions when defining filter criteria:

  1. Select a field from the list
  2. Click (Add).
  3. Select an operator.
  4. Enter the desired variable in the field after the operator.
  5. Click (Add).

The following variable expressions are available:

  • $curDay: today's date
  • $curfdYear: the first day of the current year
  • $curfdQuarter: the first day of the current quarter
  • $curfdMonth: the first day of the current month
  • $curfdWeek: the first day of the current week
  • $curYearFY: the first day of the current business year
  • $curLastLogin: the date of the current rep's last login
    Note: $curLastLogin only works in Aurea CRM.Web, not in Aurea CRM win, and can therefore not be used for queries that are processed by CRM.server.

    You can add or subtract days, weeks etc. from these dates, e. g. $curDay+1y+1d results in tomorrow one year from now. Available abbreviations: d (day), w (week), m (month), q (quarter), y (year).

  • $curTimeMin: the current time in format HH:MM
  • $curTimeSec: the current time in format HH:MM:SS
  • $curTimeMs: the current time in format HH:MM:SS:mmm
    Note: $curTimeMin, $curTimeSec and $curTimeMs can only be used depending on the time field's format. For further details, see Aurea CRM Field Types in the CRM.Core Administrator Guide.
  • $curRep: the currently logged in rep
  • $curOrgGroup: the Org.group of the currently logged in rep
  • $curGroup: the Org.group plus group allocation(s) of the currently logged in rep
  • $curAllGroups: Returns organizational group and all groups allocated to current logged in rep (without checking field datatype).
    Note: $curGroup returns only organizational group if "supplied db field" is singular. $curAllGroups returns all group assignment & allocations in all conditions and ignores the field details in its query. 
  • $curMyLeader: the group leader of the Org.group of currently logged in rep
  • $curLeader: all groups where currently logged in rep is group leader
  • $curMyDeputy: the deputy of the currently logged in rep
  • $curDeputy: all records where the currently logged in rep is the deputy
  • $curSuperior: the supervisor of the currently logged in rep
  • $curSupLine: the current superior line
  • $curExtGroup: all groups in the rep's extended group, i.e. the group entered in the Org. Group field and all groups directly allocated to this group in the Group Allocation info area.
    Note: $curGroup, $curExtGroup, $curLeader and $curDeputy cannot be used for default values since they potentially return more than one result. These variables are currently also not available for defining conditions in Aurea CRM.Web.
  • $curTenant: the tenant of the currently logged in rep
  • $cur(<infoAreaId>,<fieldId>): You can access any field value of the current rep from the info areas Rep (ID) and Station (AS), as well as the info area Rep Additional Info (AZ) in the OTC vertical.
    Note: Currently only rep fields are supported.

    Example: RepID = $cur(ID,72) compares the content of the field RepID (e.g. in MA) with the superior of the currently logged in user as defined in the Rep info area.

In addition, you can use custom variables defined in the Variables info area (Z5) for defining filter criteria. For further details, see Variables.

Syntax: $VAR(<variable name>)

For more information, see the article “Current Expressions” at https://support.aurea.com.