anyone good with odata query?

[Gristy]

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.

[abm]

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.