While this is surely possible, it beats me as to why such information might be useful?
Select C1 from T<whatever the Group form schemaid is> where C<whatever field ID contains the Group ID in the Group form> in (select C<whatever field in the user form contains the group list> from T<whatever schemaid corresponds to the User form> where C101 = '<user login name>'); This query when substituted for the actual values in the <> parts, should give you the Request ID's of all the groups that the user belongs to. You might probably need to replace the semi colon separators in the group list field with commas in the nested select statement. Joe _____ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sayali Mahajan Sent: Thursday, February 28, 2013 1:41 AM To: arslist@ARSLIST.ORG Subject: RequestID of Remedy Group Hi, Is there a query/table to get the RequestIDs of all groups connected to a Remedy User? Any help will be appreciated. Thanks in advance. Regards, Sayali _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
