Diaries - Quick List
From All n One's bxp software Wixi
1 Overview
This engine is an adaptation of the engine Main Menu > Diary Reporting > Diary - Filtered Quick Listing.
It provides a quick listing engine for all entries in the diaries configured for the ESS across multiple diaries and categories.
2 Sections
Category : The top drop down list allows filtering by Category. Appointment_Management_-_Categories Only categories specified in the Diaries section of the config will be listed.
Person : Provides a filtering mechanism to look at one individual.
Quick Dates : Provides easy date management relevant to to day. Instead of selecting From and To, the engine quickly calculates date ranges based on today.
Showing : The engine for speed will limit the display of the report to a maximum of 400 entries.
Export to Excel : Transfers the report data displayed below into an Excel spreadsheet for export.
Print page : Allows easy printing of the data displayed on the page.
Fields :
- Id : The unique Id of the entry in the diary (time_event table)
- Diary : The diary in which the entry has been made
- Category : The category that has been assigned to that diary entry
- Name : The name the diary entry has been given (user input)
- From Date : The date the diary entry starts
- From Day : The day of the from date
- To Date : The date the diary entry starts
- To Day : The day of the to date
- Person : The person(s) allocated to the diary entry
- Days : The number of days of the entry (1 day or part thereof)
- Hours : The hours between the from and to dates.
Count : A row with three items grouped by person.
- First number is the entries for that person
- Second number is the total of days for that person
- Third number is the sum total of hours for that person
Total Count : As per count but for all records in the report.
Please note the total count will only be for the first 400 records displayed it does not include records not displayed on screen.
3 Query String parameters
The report supports a number of query string parameters for use of the link in various places, e.g. in KeyStats or Dashboards.
- dteReport_From for specific date time From
- dteReport_To for specific date time To
- strReport_Type is the keyword for the dates. e.g. ThisWeek
- strPerson the unique user id
- strCategory the id of the category to filter by
Please note that if strReport_Type is set then specific from and to dates are ignored.
