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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Group and User join
Take a look at the active link that fires on 'SHOW MEMBERS' button in the group form. Copy that open window qualificationand use that as your join criteria for the join formsee 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 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
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 qualificationand use that as your join criteria for the join formsee 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 ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- Warren R. Baltimore II Remedy Developer 410-533-5367 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Group and User join
Warren, I thought there was a way to do that already, but I am dealing with 7.x not 6.3. You might need to do a join. Howard On Fri, Dec 5, 2008 at 12:04 PM, Warren Baltimore [EMAIL PROTECTED] wrote: ** 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 ARSlist: Where the Answers Are html___ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Group and User join
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 thinkyou 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 qualificationand use that as your join criteria for the join formsee 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
Re: Group and User join
Gotcha! I'll give it a shot. Warren On Fri, Dec 5, 2008 at 1:50 PM, LJ Longwing [EMAIL PROTECTED] wrote: ** 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 thinkyou 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 qualificationand use that as your join criteria for the join formsee 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 ARSlist: Where the Answers Are html___ __Platinum Sponsor: 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___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- Warren R. Baltimore II Remedy Developer 410-533-5367 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are