SharePoint REST _api DateTimeRange查询(SharePoint REST _api DateTimeRange query)

 我有一个包含数据类型DateTime开始日期和结束日期列表。 我想构造一个查询，以获取在查询日期范围内具有开始日期or结束日期的所有事件。 问题是查询使用and 。 所以我只能在日期范围查询中获得开始和结束日期的事件。 我试图替换and与or但我只在控制台中获得Unexpected token 。 我看了文档 。 但解决不了。 有什么建议么？ 
 
 这是我的代码： 
 
        var DateRAngeFormat = 'YYYY-MM-DDT00';

        var ThreeMonthsEarlier = moment().add(-3, 'months').format(DateRAngeFormat),
            ThreeMonthsFromNow = moment().add(3, 'months').format(DateRAngeFormat);

        var url = `${_spPageContextInfo.webAbsoluteUrl}/_api/web/lists/getbytitle('Program')/items?$select=Title%2CKontaktperson%2CBokning_x0020_till%2CBokning_x0020_fr_x00e5_n%2CMax_x0020_antal_x0020_platser%2CID&$filter=Bokning_x0020_fr_x00e5_n%20ge%20datetime'${ThreeMonthsEarlier}%3A00%3A00'%20and%20Bokning_x0020_till%20le%20datetime'${ThreeMonthsFromNow}%3A00%3A00'`;
 
 EDIT 
 
 我使用CAML查询（服务器端代码）进行查询，得到我想要的结果。 所以我的猜测是可以使用REST _api，我只需要弄清楚如何。 
 
 var q = new CamlQuery() { ViewXml = "<View><Query><Where><Or><Gt><FieldRef Name='Bokning_x0020_fr_x00e5_n' /><Value IncludeTimeValue='TRUE' Type='DateTime'>2017-10-03T00:28:05Z</Value></Gt><Lt><FieldRef Name='Bokning_x0020_till' /><Value IncludeTimeValue='TRUE' Type='DateTime'>2010-04-02T00:28:08Z</Value></Lt></Or></Where></Query></View>"};

I have a list with start dates and end dates columns with the data type DateTime. I want to construct a query that fetches all events that have the start date or the end date within the query date range. The problem is that the query uses and. So I only get events with start and end dates within the date range query. I tried replacing the and with or but I only get Unexpected token in the console. I looked at the docs. But could not solve it. Any suggestions?
 
This is my code:
 
        var DateRAngeFormat = 'YYYY-MM-DDT00';

        var ThreeMonthsEarlier = moment().add(-3, 'months').format(DateRAngeFormat),
            ThreeMonthsFromNow = moment().add(3, 'months').format(DateRAngeFormat);

        var url = `${_spPageContextInfo.webAbsoluteUrl}/_api/web/lists/getbytitle('Program')/items?$select=Title%2CKontaktperson%2CBokning_x0020_till%2CBokning_x0020_fr_x00e5_n%2CMax_x0020_antal_x0020_platser%2CID&$filter=Bokning_x0020_fr_x00e5_n%20ge%20datetime'${ThreeMonthsEarlier}%3A00%3A00'%20and%20Bokning_x0020_till%20le%20datetime'${ThreeMonthsFromNow}%3A00%3A00'`;
 
EDIT
 
I made a query using CAML query (serverside code) and I get the result I want. so my guess is that it is possible using the REST _api, I just have to figure out how.
 
 var q = new CamlQuery() { ViewXml = "<View><Query><Where><Or><Gt><FieldRef Name='Bokning_x0020_fr_x00e5_n' /><Value IncludeTimeValue='TRUE' Type='DateTime'>2017-10-03T00:28:05Z</Value></Gt><Lt><FieldRef Name='Bokning_x0020_till' /><Value IncludeTimeValue='TRUE' Type='DateTime'>2010-04-02T00:28:08Z</Value></Lt></Or></Where></Query></View>"};

原文：https://stackoverflow.com/questions/48067562