Question

OData Date $Filter

  • 31 January 2023
  • 1 reply
  • 264 views
M
Rank
Userlevel 5
Badge +10

Hi,

 

Trying to construct and OData query (Apps10) to look for anything in the past year.

The query does not error in Power Query Editor but it is not seeing the $Filter when I execute.

There are various posts on the community relating to OData Filter issues - can anyone confirm or deny that dynamic date is possible in OData / IFS ‘Flavour’ of OData

 

let
    Source = OData.Feed("https://XXXXint/ifsapplications/projection/v1/CustomerOrderLinesHandling.svc/CustomerOrderJoinSet?$filter=DeliveredQty gt 0&filter=date(FirstActualShipDate)    ge  "&Date.ToText(Date.AddMonths(Date.From(DateTime.LocalNow()),-12),"yyyy-MM-dd")&"&$top=99&$select=Cf_Delivery_Post_Code,FirstActualShipDate,CustomerNo,Cf_Customer_Name,Cf_Catalog_Group,CatalogNo,CatalogDesc,Cf_Salesman_Code,LineTotalWeight,DeliveredQty,Cf_Order_Type_Desc",null,[Implementation="2.0"])
in
    Source

1 reply

M
Rank
Badge

@IFS RD Product Management These are the questions that need to be answered more timely.  Its not a good look when we consider cloud Odata becomes our main source to data and we need questions answered quicker!

Reply


Terms & ConditionsCookie settings