Create a New Dashboard Group Query

Description: 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