Dashboard Macros

Following is a list of supported Macros A series of commands and/or keystrokes that launches or runs a action. that can be used when creating SQL query statements for a New Data Source.

Date Macros
This group can be used only with date/datetime fields (OnDate, CREATED, etc.)
o <<~CURRENT_YEAR>>	current year
o <<~CURRENT_MONTH>>	current month
o <<~CURRENT_QUARTER>>	current quarter
o <<~CURRENT_DAY>>	current day
This group can be used only with date/datetime fields (OnDate,MODIFIED, etc.)
o <<~LAST_YEAR>>	last (previous) year
o <<~LAST_MONTH>>	last month
o <<~LAST_QUARTER>>	last quarter
o <<~LAST_DAY>>	last day
o <<~CURRENT_DATE>>	current date
o <<~FY_END>>	when fiscal year ends (month)

User Macros
o <<~CURRENT_USER>>	logged/current user
o <<~IS_CURRENT_USER_MASTER>>	replaced by
o <<~USER_GROUP_MEMBERS>>	user group’s name, replaced by group’s members list (“, ‘USER1’, ‘USER2’)

Runtime Filters
o <<__INACTIVE_STATE__>>	ignore runtime filter (by default value will be placed)
o <<__IGNORE_STATE__>>	ignore runtime filter and its default value
o <<VALUE>>	shows place where value from part will be replaced
o <<VALUES>>	the same as <<VALUE>>, but several values can be replaced (our grid supports multi selection)