Special values
In addition to using numbers and text in the Value field, you can use special values.
Some special values can be followed by a + or - and a whole number. For example,
$$TODAY$$+1
is tomorrow, $$THISWEEK$$-1
is last week, and
$$THISYEAR$$+5
is five years after the current year. The following table lists and
describes the special values:
Value | Description |
---|---|
$$TODAY$$ | Used to compare a date to the current date. For example, if you do not want to
show training courses that were in the past, specify: General::Start Date After
$$TODAY$$ |
$$THISWEEK$$ | Used to compare a date to the current week. For example, to see training
courses that start in the current week, specify:
|
$$THISMONTH$$ | Used to compare a date to the current month. |
$$THISYEAR$$ | Used to compare a date to the current year. |
The following table lists and describes other special values:
Value | Description |
---|---|
$$RUNTIME$$ | The $$RUNTIME$$ special value allows the user to specify a
value for the filter when the report is run. If the user does not specify a value, the filter is
ignored.The Instead of using the |
$$USERID$$ | The $$USERID$$ special value is a valid field filter in
queries. A record passes the filter if it represents the current user. |
$$USERID::SectionName::FieldName$$ | The $$USERID::SectionName::FieldName$$ special value is a
valid filter in queries. Setting the Value field to the
$$USERID::SectionName::FieldName$$ special value indicates that a value is compared
with the field name FieldName in the SectionName section of the
record of the current user. |
$$PERSONID$$ | The $$PERSONID$$ special value is a valid field filter in
queries. When the $$PERSONID$$ special value is used, it resolves to the smart
object ID of the person that is associated to the current user. If the current user is not
associated to a person, an error is displayed.Similar to the |
$$PARENT::SectionName$$ | The $$PARENT::SectionName$$ special value is a valid field
filter in queries. Setting the Value field to the $$PARENT::SectionName$$ special
value indicates that a value is compared with the SectionName section of the
record that contains the query section or smart section. |
$$PARENT::SectionName ::FieldName$$ | You can indicate a filter that compares a value in the record that is
filtered with a value in the record that contains the smart section. To indicate that a value is
compared with the FieldName field in the SectionName
section of the record that contains the query section or smart section, use the following value
field: When the value of the
|