Checklist Query Request

Checklist Query Request

Hi,

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@