AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Acumatica Generic I...
Having trouble gett...
 
Notifications
Clear all

Questions Having trouble getting @MyGroups to work in GI Filters

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by Brett Nothan 6 years ago
5 Posts
3 Users
2 Reactions
2,680 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
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
June 1, 2019 2:13 pm
(@timrodman)
Famed Member
Joined: 10 years ago

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


Reply
 Brett Nothan
(@brett-nothan)
Joined: 7 years ago

Member
Posts: 14
June 3, 2019 12:41 pm
Reply toTim RodmanTim 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


Reply
Tim Rodman reacted
Joe Satlin
 Joe Satlin
(@jsatlin)
Joined: 6 years ago

New Member
Posts: 1
July 18, 2019 4:15 pm
Reply toBrett Nothan
Tim Rodman

@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


Reply
 Brett Nothan
(@brett-nothan)
Joined: 7 years ago

Member
Posts: 14
July 18, 2019 5:20 pm
Reply toJoe SatlinJoe Satlin
Tim Rodman

@joesatlin

Thanks Joe.  My issue was actually an Acumatica bug that they just fixed in 2019r1 (and r2).

 

Brett


Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 22 Online
  • 2,389 Members
Our newest member: Dan Hunting
Latest Post: Generic Inquiry Screenid changes to ScreenId=00000000
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

  • Julie Baker
Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×