Forum Discussion

JeremyF's avatar
JeremyF
Trusted User
4 years ago
Solved

Odata date queries intermittent error.

Hi Dev Folks,   Is anyone haveing problems with odata date queries on the /Purchase/Order/Item end point?   $filterArray = array('$filter' => "Date gt datetime''2021-01-01T00:00:00Z'");   Is th...
OData
  • JeremyF's avatar
    JeremyF
    4 years ago

    Hi an Update for any one interested

     

    The odata queries are really finicky

     

    By adding a second term 'Status eq 'Open' and Date gt datetime'2022-01-01'

     

    The query works and no errors are generated.

     

    NOTE: This appears to only be an issue with /Purchase/Order/Item on large company files with thousands of orders. 

    Weird!

     

     

     

     

     

JeremyF's avatar
JeremyF
Trusted User
4 years ago

Hi an Update for any one interested

 

The odata queries are really finicky

 

By adding a second term 'Status eq 'Open' and Date gt datetime'2022-01-01'

 

The query works and no errors are generated.

 

NOTE: This appears to only be an issue with /Purchase/Order/Item on large company files with thousands of orders. 

Weird!

 

 

 

 

 

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.