Web Service ODATA Date_Filter ge 'date'

agomes_17
agomes_17 Member Posts: 9
edited 2012-07-23 in NAV Three Tier
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

Comments

  • Egnaz
    Egnaz Member Posts: 111
    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

Categories