https://www.bxpsoftware.com/wixi/index.php?action=history&feed=atom&title=Diaries_-_Quick_ListDiaries - Quick List - Revision history2026-10-29T16:53:03ZRevision history for this page on the wikiMediaWiki 1.28.2https://www.bxpsoftware.com/wixi/index.php?title=Diaries_-_Quick_List&diff=8904&oldid=prevPhilip Lacey: Created page with "= 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 i..."2018-04-26T13:27:03Z<p>Created page with "= 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 i..."</p>
<p><b>New page</b></p><div>= Overview = <br />
<br />
<br />
This engine is an adaptation of the engine Main Menu > Diary Reporting > Diary - Filtered Quick Listing.<br />
<br />
<br />
It provides a quick listing engine for all entries in the diaries configured for the ESS across multiple diaries and categories.<br />
<br />
<br />
[[File:diaries_quick_list_001.png|800px]]<br />
<br />
<br />
= Sections =<br />
<br />
<br />
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.<br />
<br />
<br />
Person : Provides a filtering mechanism to look at one individual.<br />
<br />
<br />
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.<br />
<br />
<br />
Showing : The engine for speed will limit the display of the report to a maximum of 400 entries.<br />
<br />
<br />
Export to Excel : Transfers the report data displayed below into an Excel spreadsheet for export.<br />
<br />
<br />
Print page : Allows easy printing of the data displayed on the page.<br />
<br />
<br />
Fields : <br />
* Id : The unique Id of the entry in the diary (time_event table)<br />
* Diary : The diary in which the entry has been made<br />
* Category : The category that has been assigned to that diary entry<br />
* Name : The name the diary entry has been given (user input)<br />
* From Date : The date the diary entry starts<br />
* From Day : The day of the from date<br />
* To Date : The date the diary entry starts<br />
* To Day : The day of the to date<br />
* Person : The person(s) allocated to the diary entry<br />
* Days : The number of days of the entry (1 day or part thereof)<br />
* Hours : The hours between the from and to dates.<br />
<br />
<br />
Count : A row with three items grouped by person. <br />
* First number is the entries for that person<br />
* Second number is the total of days for that person<br />
* Third number is the sum total of hours for that person<br />
<br />
<br />
Total Count : As per count but for all records in the report. <br />
<br />
<br />
Please note the total count will only be for the first 400 records displayed it does not include records not displayed on screen.<br />
<br />
<br />
= Query String parameters =<br />
<br />
<br />
The report supports a number of query string parameters for use of the link in various places, e.g. in KeyStats or Dashboards.<br />
<br />
* dteReport_From for specific date time From<br />
* dteReport_To for specific date time To<br />
* strReport_Type is the keyword for the dates. e.g. ThisWeek<br />
* strPerson the unique user id<br />
* strCategory the id of the category to filter by<br />
<br />
<br />
Please note that if strReport_Type is set then specific from and to dates are ignored.</div>Philip Lacey