Web Service ODATA Date_Filter ge 'date'

agomes_17

Hi guys,

I'm Consuming a NAV Web Service(ODATA) which expose a Page(source table "Customer").

Until Now, I've done many Request's, and always works fine but now, i want request this:

"<= date_filter" (NAV= "Date..") but it don't work,the strange is that the following requests works fine:

(Date..)
URL/PCustomer?$orderby=No&$filter=(Date_Filter ge '011214') -> FAIL

(..Date)
URL/PCustomer?$orderby=No&$filter=(Date_Filter le '011214') -> WORK

(Date1..Date2)
URL/PCustomer?$orderby=No&$filter=(Date_Filter ge '123113' and Date_Filter le '011214') -> WORK


anyone can help me?

TY

Egnaz

Hi there,

I published the default customer page (21).
If I check the metadata for this there won't be a filter that you described.
Only available filters are: Currency_Filter, Global_Dimension_1_Filter, Global_Dimension_2_Filter

Date_Filter isn't available.

So let us know what you are trying to do. Maybe you can show us the metadata for your page.

I made a test with the Last_Date_Modified field and got it work.

Kind regards,
Egnaz