Skip to main content
Solved

Filtering by TimeEntries Boolean on Project Tasks

  • September 30, 2024
  • 1 reply
  • 63 views

Forum|alt.badge.img

Hi,

I’m trying to filter out Project Tasks via my API query but so far haven’t been able to get this to work correctly. So far, I’ve tried filtering like this:

“VisibilitySettings/TimeEntries eq 'true'”

and

“VisibilitySettings/TimeEntries eq true”

 

For both of these filters, I will still get back ProjectTasks whose TimeEntries Visibility settings are equal to “false”. Is this possible to do?

Best answer by Vignesh Ponnusamy

 

Hi @ryanmiter,

Filter does work with the detail entity. Map the field to the header level entity(ProjectTask) then use the filter like below

ProjectTask?$filter=TimeEntries eq false

Screenshot of the mapping and result,

 

 

For  more information on extending the endpoint kindly refer, https://help.acumatica.com/(W(6))/Help?ScreenId=ShowWiki&pageid=c450492e-06fe-4563-95c3-efa76975415b

Feel free to post back if you have any questions, Good Luck.!

1 reply

Vignesh Ponnusamy
Acumatica Moderator
Forum|alt.badge.img+5

 

Hi @ryanmiter,

Filter does work with the detail entity. Map the field to the header level entity(ProjectTask) then use the filter like below

ProjectTask?$filter=TimeEntries eq false

Screenshot of the mapping and result,

 

 

For  more information on extending the endpoint kindly refer, https://help.acumatica.com/(W(6))/Help?ScreenId=ShowWiki&pageid=c450492e-06fe-4563-95c3-efa76975415b

Feel free to post back if you have any questions, Good Luck.!