Re: Retriving the application name for a form

2010-03-17 Thread Brad Fike
Lyle, I have an app that looks for forms in Packing Lists. To get the info I was running variations on the SQL below. -- list all applications and the forms in that app -- c.containerType = 2 (application) -- r.referencetype = 2 (forms) select c.name, a.name from arcontainer c, arreference r,

Re: Retriving the application name for a form

2010-03-13 Thread LJ Longwing
Sweet, glad to hear. _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Friday, March 12, 2010 5:40 PM To: arslist@ARSLIST.ORG Subject: Re: Retriving the application name for a form ** LJ, just wanted to let you know

Retriving the application name for a form

2010-03-12 Thread Lyle Taylor
Hi all, Does anyone know of a way to determine what application a given form belongs to using the Remedy API? So far, the best I've come up with is to pull a list of all the applications and then pull a list of forms for each application and then load that into a lookup data structure. That

Re: Retriving the application name for a form

2010-03-12 Thread LJ Longwing
. _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Thursday, March 11, 2010 6:13 PM To: arslist@ARSLIST.ORG Subject: Retriving the application name for a form ** Hi all, Does anyone know of a way to determine what application

Re: Retriving the application name for a form

2010-03-12 Thread Lyle Taylor
(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: Friday, March 12, 2010 8:26 AM To: arslist@ARSLIST.ORG Subject: Re: Retriving the application name for a form ** Lyle, Based on my short research this morning, I don't believe that the form knows what application it's a member

Re: Retriving the application name for a form

2010-03-12 Thread LJ Longwing
, March 12, 2010 10:31 AM To: arslist@ARSLIST.ORG Subject: Re: Retriving the application name for a form ** It shouldn't be, but realistically, I need to do it for every application if I want the full set of data, and while each individual application doesn't take too long, getting them all takes

Re: Retriving the application name for a form

2010-03-12 Thread Lyle Taylor
Perfectly. I like it. You're brilliant, LJ! Thanks! Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: Friday, March 12, 2010 10:40 AM To: arslist@ARSLIST.ORG Subject: Re: Retriving the application name for a form

Re: Retriving the application name for a form

2010-03-12 Thread LJ Longwing
Glad I could be of use to someone today :) _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Friday, March 12, 2010 10:55 AM To: arslist@ARSLIST.ORG Subject: Re: Retriving the application name for a form ** Perfectly

Re: Retriving the application name for a form

2010-03-12 Thread Lyle Taylor
(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: Friday, March 12, 2010 11:19 AM To: arslist@ARSLIST.ORG Subject: Re: Retriving the application name for a form ** Glad I could be of use to someone today :) From: Action Request System discussion