I was talking about the Open Window action...it uses a qual of ( 'Group List' LIKE ( $Group Number$ + ";%" )) OR ( 'Group List' LIKE (( "%;" + $Group Number$) + ";%" )) OR ( 'Computed Grp List' LIKE ( $Group Number$ + ";%" )) OR ( 'Computed Grp List' LIKE (( "%;" + $Group Number$) + ";%" )) if you make this your join criteria, I think....you should get the same results...
_____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Warren Baltimore Sent: Friday, December 05, 2008 10:27 AM To: arslist@ARSLIST.ORG Subject: Re: Group and User join ** Good thought, I actually had tried that. It set's a display only char. field on the Group form with the group ID, and then runs the query to pull back members. The only way for me to do that would be to create a new field on the Group form, and I really don't want to do that! I may just have to tell the folks who want it no. On Fri, Dec 5, 2008 at 12:17 PM, LJ Longwing <[EMAIL PROTECTED]> wrote: ** Take a look at the active link that fires on 'SHOW MEMBERS' button in the group form. Copy that open window qualification....and use that as your join criteria for the join form....see if that works for you...:) _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Warren Baltimore Sent: Friday, December 05, 2008 10:05 AM To: arslist@ARSLIST.ORG Subject: Group and User join ** Folks, I've got a need to join the Group and user forms so that I can report off of the group form and show the members of each group. I can't figure out how to do it! Something in the back of my head keeps saying I'm approaching it wrong, but I try not to listen to the voices in my head! ARsystem 6.3 ITSM 5.5 Oracle Any advice would be most appreciated! Warren -- Warren R. Baltimore II Remedy Developer 410-533-5367 __Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" html___ -- Warren R. Baltimore II Remedy Developer 410-533-5367 __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
