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, arschema a where c.containerid = r.containerid and r.referenceid = a.schemaid and c.containerType = 2 and r.referencetype = 2 order by 1, 2 -- show the owner application name for a given form -- edit the last line with the form name you are looking for. select c.name from arcontainer c, arreference r, arschema a where c.containerid = r.containerid and r.referenceid = a.schemaid and c.containerType = 2 and r.referencetype = 2 and a.name = 'Alert Events' Thank You, Brad Fike (469) 759-0798 [email protected] On Thu, Mar 11, 2010 at 7:13 PM, Lyle Taylor <[email protected]> wrote: > ** > > 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 works, > but it’s very slow. Any other ideas? > > > > Thanks, > Lyle > > NOTICE: This email message is for the sole use of the intended recipient(s) > and may contain confidential and privileged information. Any unauthorized > review, use, disclosure or distribution is prohibited. If you are not the > intended recipient, please contact the sender by reply email and destroy all > copies of the original message. > > _Platinum Sponsor: [email protected] ARSlist: "Where the Answers > Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
