Hi All
Some time ago Qdabra created a dashboard form for us which works very well - but is now getting a little slow to load.
I thought I could try and update the REST Query so that it only found items younger than six months old.
The original REST Query is
http://xxx/departments/IT/EquipmentRequests/_vti_bin/ListData.svc/RequestLineItems/?$expand=RequestID,RequestID/Authoriser,RequestID/Requestor&$select=Id,Cost,Quantity,TotalCost,RequestID/Id,RequestID/RequestStatus,RequestID/Name,RequestID/PersonGoodsAreFor,RequestID/SumOfTotalCost,RequestID/POStatus,RequestID/DeliverySite,RequestID/RequestReason,RequestID/Authoriser/Name,RequestID/Authoriser/Account,ProductIDId,ProductGroupIDId,RequestID/FormName&$filter=RequestID
ne null and
tolower(RequestID/Requestor/Account) eq tolower('xxxltd\xxx.xxx) or
tolower(RequestID/Authoriser/Account) eq tolower('xxxltd\xxx.xxx')
I have tried adding a date filter - shown below (3rd line) but I don't know if this is a suitable format - it doesn't work so I am sure I have made an error.
http://xxx/departments/IT/EquipmentRequests/_vti_bin/ListData.svc/RequestLineItems/?$expand=RequestID,RequestID/Authoriser,RequestID/Requestor&$select=Id,Cost,Quantity,TotalCost,RequestID/Id,RequestID/RequestStatus,RequestID/Name,RequestID/PersonGoodsAreFor,RequestID/SumOfTotalCost,RequestID/POStatus,RequestID/DeliverySite,RequestID/RequestReason,RequestID/Authoriser/Name,RequestID/Authoriser/Account,ProductIDId,ProductGroupIDId,RequestID/FormName&$filter=RequestID ne null and Created ge datetime '2016-03-26' and tolower(RequestID/Requestor/Account) eq tolower('xxxltd\xxx.xxx) or tolower(RequestID/Authoriser/Account) eq tolower('xxxltd\xxx.xxx')
Any help gratefully received.
Catharine