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,
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
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
.
_
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
(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
, 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
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
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
(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
9 matches
Mail list logo