Re: REST Query to include a date

Hilary Stoupa — Mon, 26 Sep 2016 21:25:00 GMT

One thought - try what you believe the query will be in your browser (i.e., enter actual values for the account, etc) to verify you have results returned. It makes it easier to test.

This SharePoint StackExchange question suggests you'll need to include the time: http://sharepoint.stackexchange.com/questions/50975/sp-2010-rest-filter-column

REST Query to include a date

Catharine — Mon, 26 Sep 2016 12:15:58 GMT

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

Data Connections

Re: REST Query to include a date

REST Query to include a date