If I am a member of a dynamic group based on field 112 (or AssignedTo
for that matter)-- why doesn't $GROUPS$ reflect this group? I tried
making a AL and a Filter to display $GROUPS$ in a field on display
and/or GET, but it does not include these groups.
How else can one query a form for $GROUPS$ LIKE %4;% OR $GROUPS$ LIKE
%7;% (Assignee and Assignee Group, respectively)
In other words, how can I query a form for records where I am in these
specific dynamic groups? There might be several other custom dynamic
groups that let me "see" a record, so using permissions alone as an
alternative to querying is not useful beyond basic use cases. Simple
example: You have read-only access to certain records because you are a
Vice President and you like to know what is going on-- however you want
to filter out those records and only see records where you are
"assigned" to do something, such as approve a specific request. So you
query by Assigned To Group field to only show records where a group you
are in is Assigned to do the task. Does that use case make sense? Does
using groups make sense for this?
Sorry if this seems whiny, I am at a loss as to why this is so
difficult, I thought groups would make things like this easier! Do I
really need to break up $GROUPIDS$ into pieces using an AL Guide and
build a really long query string?
end result being something like... (for 4 groups 501-504)..
'Assigned To Group' LIKE %501;% OR 'Assigned To Group' LIKE %502;% OR
Assigned To Group' LIKE %503;% OR Assigned To Group' LIKE %504;%
Obviously the above seems to be the wrong way to do things... but I'll
do it if it is the only way.
Thanks in advance, and sorry for the repost, my last question seemed too
vague so I've reworded it basically.
Brien
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
