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, 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
b...@jbfike.com


On Thu, Mar 11, 2010 at 7:13 PM, Lyle Taylor tayl...@ldschurch.org 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: rmisoluti...@verizon.net ARSlist: Where the Answers
 Are_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are


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 that I implemented your suggestion, and it
works great.  For the forms we currently care about, there is no perceptible
delay while I determine the group to use from the role.  Thanks again for
the suggestion!

 

Lyle

 

From: Action Request System discussion list(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 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.  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

 

** 

This might get a bit complicated...but you have the role ID from the
formyou should be able to look in the role form and find out what
applications that role belongs to...it doesn't NEED to be unique, but might
be, if it's unique then you already have the mapping from role to group and
you can check to see if they are in that group.  In the case of the role id
not being unique, you then have a list of applications you can check to
determine which app the form is a member ofbut further...if the role ID
is not unique, you could check the role/group mapping and see if they are
the same, if they are, it's irrelevant which app the form belongs to because
both reference the same group, so you can check the users
membership.does this make sense?

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
Sent: Friday, 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 a good 30 seconds or so.  That
wouldn't be so bad, except that that's happening as the result of a user
interaction in an application and is way too long to wait for this
particular interaction to complete.

 

Perhaps I can just be smarter about it and only pull back applications until
I find the one that contains the given form.  I could also start with the
most likely applications and then go from there.  That way, most of the
time, I'll get a quick hit.  If a person selects a form that doesn't belong
to an application, however, I'm back to where I started, because then
they'll have to wait for the full list to get loaded to find out that it
doesn't belong to an application.

 

Or maybe there's a better way to do things.  This is what I'm really trying
to accomplish:  I have an application that allows people to create records
in Remedy.  For various reasons, I have the application running with an
administrative account, but I need to still limit the ability of people to
create records only in forms that they have permissions to.  For regular
group permissions, it's easy - I just pull their list of permissions from
the user form and compare them to the permissions on the form.  The snitch
comes in when the form belongs to an application and has roles assigned for
the permissions.  In that case, I either needs to find an easy way to relate
those roles back to permission groups or to find out which roles the user
has so I can make an accurate check.  The problem I'm seeing so far though,
is that I'm still stuck determine which application the form belongs to,
because if I want to pull the role/group associations from the Roles form, I
still need to know the application.  And if I want to use the API to find
out what roles a person has, I also need the name of the application.

 

Any other ideas?

 

Thanks,

Lyle

 

From: Action Request System discussion list(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 ofnot independently at least.  The
process of pulling the applications and doing something similar to a
'.contains()' on the form list shouldn't be too time consuming.

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:arsl

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 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.



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are


Re: Retriving the application name for a form

2010-03-12 Thread LJ Longwing
Lyle,
Based on my short research this morning, I don't believe that the form knows
what application it's a member ofnot independently at least.  The
process of pulling the applications and doing something similar to a
'.contains()' on the form list shouldn't be too time consuming.

  _  

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 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: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are


Re: Retriving the application name for a form

2010-03-12 Thread Lyle Taylor
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 a good 30 seconds or so.  That wouldn't be so 
bad, except that that's happening as the result of a user interaction in an 
application and is way too long to wait for this particular interaction to 
complete...

Perhaps I can just be smarter about it and only pull back applications until I 
find the one that contains the given form.  I could also start with the most 
likely applications and then go from there.  That way, most of the time, I'll 
get a quick hit.  If a person selects a form that doesn't belong to an 
application, however, I'm back to where I started, because then they'll have to 
wait for the full list to get loaded to find out that it doesn't belong to an 
application...

Or maybe there's a better way to do things.  This is what I'm really trying to 
accomplish:  I have an application that allows people to create records in 
Remedy.  For various reasons, I have the application running with an 
administrative account, but I need to still limit the ability of people to 
create records only in forms that they have permissions to.  For regular group 
permissions, it's easy - I just pull their list of permissions from the user 
form and compare them to the permissions on the form.  The snitch comes in when 
the form belongs to an application and has roles assigned for the permissions.  
In that case, I either needs to find an easy way to relate those roles back to 
permission groups or to find out which roles the user has so I can make an 
accurate check.  The problem I'm seeing so far though, is that I'm still stuck 
determine which application the form belongs to, because if I want to pull the 
role/group associations from the Roles form, I still need to know the 
application.  And if I want to use the API to find out what roles a person has, 
I also need the name of the application.

Any other ideas?

Thanks,
Lyle

From: Action Request System discussion list(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 ofnot independently at least.  The process 
of pulling the applications and doing something similar to a '.contains()' on 
the form list shouldn't be too time consuming.


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 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: rmisoluti...@verizon.net ARSlist: Where the Answers Are_
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are


Re: Retriving the application name for a form

2010-03-12 Thread LJ Longwing
This might get a bit complicated...but you have the role ID from the
formyou should be able to look in the role form and find out what
applications that role belongs to...it doesn't NEED to be unique, but might
be, if it's unique then you already have the mapping from role to group and
you can check to see if they are in that group.  In the case of the role id
not being unique, you then have a list of applications you can check to
determine which app the form is a member ofbut further...if the role ID
is not unique, you could check the role/group mapping and see if they are
the same, if they are, it's irrelevant which app the form belongs to because
both reference the same group, so you can check the users
membership.does this make sense?

  _  

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
Sent: Friday, 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 a good 30 seconds or so.  That
wouldn't be so bad, except that that's happening as the result of a user
interaction in an application and is way too long to wait for this
particular interaction to complete.

 

Perhaps I can just be smarter about it and only pull back applications until
I find the one that contains the given form.  I could also start with the
most likely applications and then go from there.  That way, most of the
time, I'll get a quick hit.  If a person selects a form that doesn't belong
to an application, however, I'm back to where I started, because then
they'll have to wait for the full list to get loaded to find out that it
doesn't belong to an application.

 

Or maybe there's a better way to do things.  This is what I'm really trying
to accomplish:  I have an application that allows people to create records
in Remedy.  For various reasons, I have the application running with an
administrative account, but I need to still limit the ability of people to
create records only in forms that they have permissions to.  For regular
group permissions, it's easy - I just pull their list of permissions from
the user form and compare them to the permissions on the form.  The snitch
comes in when the form belongs to an application and has roles assigned for
the permissions.  In that case, I either needs to find an easy way to relate
those roles back to permission groups or to find out which roles the user
has so I can make an accurate check.  The problem I'm seeing so far though,
is that I'm still stuck determine which application the form belongs to,
because if I want to pull the role/group associations from the Roles form, I
still need to know the application.  And if I want to use the API to find
out what roles a person has, I also need the name of the application.

 

Any other ideas?

 

Thanks,

Lyle

 

From: Action Request System discussion list(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 ofnot independently at least.  The
process of pulling the applications and doing something similar to a
'.contains()' on the form list shouldn't be too time consuming.

 

  _  

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 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: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are


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

**
This might get a bit complicated...but you have the role ID from the 
formyou should be able to look in the role form and find out what 
applications that role belongs to...it doesn't NEED to be unique, but might be, 
if it's unique then you already have the mapping from role to group and you can 
check to see if they are in that group.  In the case of the role id not being 
unique, you then have a list of applications you can check to determine which 
app the form is a member ofbut further...if the role ID is not unique, you 
could check the role/group mapping and see if they are the same, if they are, 
it's irrelevant which app the form belongs to because both reference the same 
group, so you can check the users membership.does this make sense?


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
Sent: Friday, 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 a good 30 seconds or so.  That wouldn't be so 
bad, except that that's happening as the result of a user interaction in an 
application and is way too long to wait for this particular interaction to 
complete...

Perhaps I can just be smarter about it and only pull back applications until I 
find the one that contains the given form.  I could also start with the most 
likely applications and then go from there.  That way, most of the time, I'll 
get a quick hit.  If a person selects a form that doesn't belong to an 
application, however, I'm back to where I started, because then they'll have to 
wait for the full list to get loaded to find out that it doesn't belong to an 
application...

Or maybe there's a better way to do things.  This is what I'm really trying to 
accomplish:  I have an application that allows people to create records in 
Remedy.  For various reasons, I have the application running with an 
administrative account, but I need to still limit the ability of people to 
create records only in forms that they have permissions to.  For regular group 
permissions, it's easy - I just pull their list of permissions from the user 
form and compare them to the permissions on the form.  The snitch comes in when 
the form belongs to an application and has roles assigned for the permissions.  
In that case, I either needs to find an easy way to relate those roles back to 
permission groups or to find out which roles the user has so I can make an 
accurate check.  The problem I'm seeing so far though, is that I'm still stuck 
determine which application the form belongs to, because if I want to pull the 
role/group associations from the Roles form, I still need to know the 
application.  And if I want to use the API to find out what roles a person has, 
I also need the name of the application.

Any other ideas?

Thanks,
Lyle

From: Action Request System discussion list(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 ofnot independently at least.  The process 
of pulling the applications and doing something similar to a '.contains()' on 
the form list shouldn't be too time consuming.


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 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: rmisoluti...@verizon.net ARSlist: Where the Answers Are_
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers

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.  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

 

** 

This might get a bit complicated...but you have the role ID from the
formyou should be able to look in the role form and find out what
applications that role belongs to...it doesn't NEED to be unique, but might
be, if it's unique then you already have the mapping from role to group and
you can check to see if they are in that group.  In the case of the role id
not being unique, you then have a list of applications you can check to
determine which app the form is a member ofbut further...if the role ID
is not unique, you could check the role/group mapping and see if they are
the same, if they are, it's irrelevant which app the form belongs to because
both reference the same group, so you can check the users
membership.does this make sense?

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
Sent: Friday, 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 a good 30 seconds or so.  That
wouldn't be so bad, except that that's happening as the result of a user
interaction in an application and is way too long to wait for this
particular interaction to complete.

 

Perhaps I can just be smarter about it and only pull back applications until
I find the one that contains the given form.  I could also start with the
most likely applications and then go from there.  That way, most of the
time, I'll get a quick hit.  If a person selects a form that doesn't belong
to an application, however, I'm back to where I started, because then
they'll have to wait for the full list to get loaded to find out that it
doesn't belong to an application.

 

Or maybe there's a better way to do things.  This is what I'm really trying
to accomplish:  I have an application that allows people to create records
in Remedy.  For various reasons, I have the application running with an
administrative account, but I need to still limit the ability of people to
create records only in forms that they have permissions to.  For regular
group permissions, it's easy - I just pull their list of permissions from
the user form and compare them to the permissions on the form.  The snitch
comes in when the form belongs to an application and has roles assigned for
the permissions.  In that case, I either needs to find an easy way to relate
those roles back to permission groups or to find out which roles the user
has so I can make an accurate check.  The problem I'm seeing so far though,
is that I'm still stuck determine which application the form belongs to,
because if I want to pull the role/group associations from the Roles form, I
still need to know the application.  And if I want to use the API to find
out what roles a person has, I also need the name of the application.

 

Any other ideas?

 

Thanks,

Lyle

 

From: Action Request System discussion list(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 ofnot independently at least.  The
process of pulling the applications and doing something similar to a
'.contains()' on the form list shouldn't be too time consuming.

 

  _  

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 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

Re: Retriving the application name for a form

2010-03-12 Thread Lyle Taylor
LJ, just wanted to let you know that I implemented your suggestion, and it 
works great.  For the forms we currently care about, there is no perceptible 
delay while I determine the group to use from the role.  Thanks again for the 
suggestion!

Lyle

From: Action Request System discussion list(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 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.  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

**
This might get a bit complicated...but you have the role ID from the 
formyou should be able to look in the role form and find out what 
applications that role belongs to...it doesn't NEED to be unique, but might be, 
if it's unique then you already have the mapping from role to group and you can 
check to see if they are in that group.  In the case of the role id not being 
unique, you then have a list of applications you can check to determine which 
app the form is a member ofbut further...if the role ID is not unique, you 
could check the role/group mapping and see if they are the same, if they are, 
it's irrelevant which app the form belongs to because both reference the same 
group, so you can check the users membership.does this make sense?


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
Sent: Friday, 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 a good 30 seconds or so.  That wouldn't be so 
bad, except that that's happening as the result of a user interaction in an 
application and is way too long to wait for this particular interaction to 
complete...

Perhaps I can just be smarter about it and only pull back applications until I 
find the one that contains the given form.  I could also start with the most 
likely applications and then go from there.  That way, most of the time, I'll 
get a quick hit.  If a person selects a form that doesn't belong to an 
application, however, I'm back to where I started, because then they'll have to 
wait for the full list to get loaded to find out that it doesn't belong to an 
application...

Or maybe there's a better way to do things.  This is what I'm really trying to 
accomplish:  I have an application that allows people to create records in 
Remedy.  For various reasons, I have the application running with an 
administrative account, but I need to still limit the ability of people to 
create records only in forms that they have permissions to.  For regular group 
permissions, it's easy - I just pull their list of permissions from the user 
form and compare them to the permissions on the form.  The snitch comes in when 
the form belongs to an application and has roles assigned for the permissions.  
In that case, I either needs to find an easy way to relate those roles back to 
permission groups or to find out which roles the user has so I can make an 
accurate check.  The problem I'm seeing so far though, is that I'm still stuck 
determine which application the form belongs to, because if I want to pull the 
role/group associations from the Roles form, I still need to know the 
application.  And if I want to use the API to find out what roles a person has, 
I also need the name of the application.

Any other ideas?

Thanks,
Lyle

From: Action Request System discussion list(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 ofnot independently at least.  The process 
of pulling the applications and doing something similar to a '.contains()' on 
the form list shouldn't be too time consuming.


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