Overview
How to Create a Dashboard Group New Query.
Note: Variables available for use in queries are listed below the steps.
Step 1 - From the Dashboard Groups applet toolbar, click the Manage button; then select Queries.
Step 2 - Specify the name of the query, the chart type, and the query itself. Refer to the chart types located in the Wigets Tab section of this manual.
Step 3 - Click Save.
Variables
Variables are available for use in queries. Currently, the variables include the following:
@MYID@ - The employee id of the logged in user.
@MYCODE@ - The employee code of the logged in user.
@NOW@ - The current time
@MONTH@ - The current month
@DAY@ - The current day of the month
@YEAR@ - The current year
@DATE@ - The current date
@TIME@ - The current time
@CURRENTPERIODCODE@ - The current G/L period code
@CURRENTPERIODSTART@ - The starting date of the current G/L period
@CURRENTPERIODEND@ - The ending date of the current G/L period
@YEARSTART@ - The beginning of the current year.
@YEAREND@ - The end of the current year.
@MONTHSTART@ - The first of the current month
@MONTHEND@ - The end of the current month