— The Forums are now read-only —

— All new activity now takes place here: —

Notifications

Clear all

Questions Having trouble getting @MyGroups to work in GI Filters

Acumatica Generic Inquiries & Pivot Tables

Last Post by Brett Nothan 7 years ago

5 Posts

3 Users

2 Reactions

3,109 Views

RSS

Posts: 14

Brett Nothan

Topic starter

May 23, 2019 11:36 am

(@brett-nothan)

Member

Joined: 7 years ago

This works fine - Utilizing the "Equals" condition and a specific Workgroup as the Value

When I change to utilize "Is In" as the condition and "@MyGroups" as the Value I get an error "Incorrect syntax near ')'."

Any thoughts?

Thanks,

Brett

4 Replies

Posts: 3204

Tim Rodman

Admin

June 1, 2019 2:13 pm

(@timrodman)

Famed Member

Joined: 11 years ago

Haven't tried it. Are you expecting Is In to provide additional functionality above and beyond Equals?

Brett Nothan

(@brett-nothan)

Joined: 7 years ago

Member

Posts: 14

June 3, 2019 12:41 pm

Reply to

Tim Rodman

Yes, "Is In" is designed to be utilized with the @ workgroup functions. I have opened a Case with Acumatica and they have been able to reproduce the issue.

Thanks,

Brett

Joe Satlin

(@jsatlin)

Joined: 6 years ago

New Member

Posts: 1

July 18, 2019 4:15 pm

Reply to

Brett Nothan

@brett-nothan

I just happen to see this posting and just wrote a sample inquiry for someone on how to make it work. Depending on your version, the filters in the inquiry may not work but at least since 2017R2 you can add @mygroups and @myworktree into the inquiry conditions and it does work. The trick is making sure you are using a schema field for the workgroupid that is of type PXCompanyTreeSelector. I have uploaded a simple inquiry using EPEmployee and EPCompanyTreeMember tables.

Joe

Right-click to Download