Please can I request two querys in relation to Check List data.
Report 1 - Associated Checklists
Showing any Checklist that has been associated with a call.
Date Filter on Associated Date (Today, Yesterday, last week etc.)
Fields required: Request ID, Category, Subcategory, Item, Assigned Technician, Checklist Name, Date Associated, Associated By, Date Verified, Verified By, Checklist Items,
Report 2 - Checklist Item Updates
Showing breakdown details on the associated checklist
Date Filter on Associated Date (Today, Yesterday, last week etc.)
Fields required: Request ID, Checklist Name, Checklist Item, Updated By, Changed Date, Value changed to
Would be interested to see what other querys people run on checklists too please?
Many thanks,
Lisa
@Database Name = Microsoft SQL Server@
@Current Build = 11307@