Skip to main content
Solved

REST API - Contract API - status filtering not working

  • May 20, 2025
  • 1 reply
  • 77 views

Filtering Activity by TimeActivity/Status ‘Released’ does not work. Specifically the released status does not work. It does work if I use the short form RL instead of Released.

 

Filtering with TimeActivity/Status OPEN works as expected.

http://52.168.110.150/AcumaticaNew/entity/Default/23.200.001/Activity?$select=TimeActivity/Status&$filter=TimeActivity/Status+eq+'Open'&$expand=TimeActivity

This works for both $filter=TimeActivity/Status+eq+'Open’ and $filter=TimeActivity/Status+eq+'OP’.

The same goes for status Completed (CD)

 

Based on the request profiler, Completed and Open are both translated to the short form prior to query execution. However, ‘Released’ is shortened to ‘Re’ instead of ‘RL’.

 

Is there a way to get this to work, or at least identify the columns that are of type ENUM specifically status type enums so that we can normalize this client side? The swagger response reports the field as string which is incorrect if we need to normalize the enum display/internal value.

Best answer by ruchikasharma23

Hi ​@indritb 

Unfortunately, there is no way to identify this as of today.
We will provide this feedback to our Engineering team so that it can be considered for future versions.

1 reply

Forum|alt.badge.img+3
  • Acumatica Moderator
  • Answer
  • June 20, 2025

Hi ​@indritb 

Unfortunately, there is no way to identify this as of today.
We will provide this feedback to our Engineering team so that it can be considered for future versions.