anyone good at odata filters?
I would like to query a SharePoint List.
SharePoint list has date columns Start and End.
the query needs to get list items that over lap with a provided start and end time.
So if there were 3 list items with start and end as follows:
20/11/2019 -> 25/11/2019
25/11/2019 -> 27/11/2019
15/11/2019 -> 20/11/2019
and the user provided dates 23/11/2019 -> 28/11/2019 2 of the 3 items would be returned
if the user provided 19/11/2019 -> 25/11/2019 all 3 would be returned
and so on.
Hi @Gristy
Try to install this tool in your Sharepoint dev environment.
https://appsource.microsoft.com/en-us/product/office/WA104051159?src=Office&tab=Overview
This tool can generate the ODATA query via UI.
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogLearn to digitize and optimize business processes and connect all your applications to share data in real time.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.
User | Count |
---|---|
23 | |
23 | |
23 | |
22 | |
17 |
User | Count |
---|---|
57 | |
39 | |
37 | |
29 | |
26 |