Skip to main content

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

@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