Skip to main content
Answer

ODATAv4 IN Clause NOT WORKING

  • March 18, 2024
  • 3 replies
  • 83 views
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

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

3 replies

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

Nevermind, I figured this out.

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

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

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
abhijit
Varsity I
Forum|alt.badge.img
  • abhijit
  • Author
  • Answer
  • March 20, 2024

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

Chris Hackett
RohitRattan88
Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved