Skip to main content
Solved

ODATAv4 IN Clause NOT WORKING


abhijit
Varsity I
Forum|alt.badge.img

I am trying to filter the data coming in from acumatica using an IN CLAUSE on the PMTask object.

My URL Looks like this

{{acumaticaurl}}/odatav4/PX_Objects_PM_PMTask?$format=json&filter=ProjectID in (683,684,687,686,685)&$select=ProjectID, TaskCD, TaskID,NoteID, ExtRefNbr,Description

No matter, what changes I do to the filter, it is fetching all the tasks from the database. How do I get the IN filter to work?

Edit:
The same syntax is working on the PMCostBudget object. The operation filters the records being fetched.

{{acumaticaurl}}/odatav4/PX_Objects_PM_PMCostBudget?$format=json&$filter=ProjectID in (683, 684, 687, 686, 685)&$select=ProjectID, Type, Qty, UOM, CuryUnitRate, Rate, CuryAmount


Thanks in advance!

 

Best answer by abhijit

Chris Hackett wrote:

Hi @abhijit  - Can you share your solution with the community? Thank you!

Hi @Chris Hackett, There is no problem. The issue is with the URLs. A colleague pointed out that the first URL is missing the $ sign before the filter

View original
Did this topic help you find an answer to your question?

3 replies

abhijit
Varsity I
Forum|alt.badge.img
  • Author
  • 43 replies
  • March 20, 2024

Nevermind, I figured this out.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2759 replies
  • March 20, 2024

Hi @abhijit  - Can you share your solution with the community? Thank you!


abhijit
Varsity I
Forum|alt.badge.img
  • Author
  • 43 replies
  • Answer
  • March 20, 2024
Chris Hackett wrote:

Hi @abhijit  - Can you share your solution with the community? Thank you!

Hi @Chris Hackett, There is no problem. The issue is with the URLs. A colleague pointed out that the first URL is missing the $ sign before the filter


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings