Forum Discussion

JeremyF's avatar
JeremyF
Experienced User
3 years ago

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
Experienced User
3 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.