Re: Checking $USER$
Is your database case insensitive? Doug From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa Sent: Thursday, August 06, 2009 8:48 AM To: arslist@ARSLIST.ORG Subject: FW: Checking $USER$ ** I need to know if the $USER$ is in upper or lower case, so in my Active Link I put in the Run If field: $USER$ LIKE [A-Z]% But my actions run no matter if the $USER$ is in lower case or upper case(I only want it to run if the User is in uppercase) Not sure why this is doing this... Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax lisa.ke...@tycoelectronics.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ DISCLAIMER Important! This message is intended for the above named person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient of this e-mail and have received it in error, please immediately notify the sender by return email and then delete it from your mailbox. This message may be protected by the attorney-client privilege and/or work product doctrine. Accessing, copying, disseminating or re-using any of the information contained in this e-mail by anyone other than the intended recipient is strictly prohibited. Finally, you should check this email and any attachments for the presence of viruses, as the sender accepts no liability for any damage caused by any virus transmitted by this email. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Checking $USER$
It is, which is why it's so weird that this is not working. I've decided to just do a check to see if the user has an AR account and this is working a lot better. (if it is uppercase, that means the user came in with a guest account) Lisa From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Tanner, Doug Sent: Friday, August 07, 2009 7:29 AM To: arslist@ARSLIST.ORG Subject: Re: Checking $USER$ ** Is your database case insensitive? Doug From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa Sent: Thursday, August 06, 2009 8:48 AM To: arslist@ARSLIST.ORG Subject: FW: Checking $USER$ ** I need to know if the $USER$ is in upper or lower case, so in my Active Link I put in the Run If field: $USER$ LIKE [A-Z]% But my actions run no matter if the $USER$ is in lower case or upper case(I only want it to run if the User is in uppercase) Not sure why this is doing this... Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax lisa.ke...@tycoelectronics.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ DISCLAIMER Important! This message is intended for the above named person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient of this e-mail and have received it in error, please immediately notify the sender by return email and then delete it from your mailbox. This message may be protected by the attorney-client privilege and/or work product doctrine. Accessing, copying, disseminating or re-using any of the information contained in this e-mail by anyone other than the intended recipient is strictly prohibited. Finally, you should check this email and any attachments for the presence of viruses, as the sender accepts no liability for any damage caused by any virus transmitted by this email. Thank you. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Checking $USER$
If they do not have an account and you allow guest loggins then the $GROUP$ will be NULL for that user. On Fri, Aug 7, 2009 at 4:56 PM, Kemes, Lisalisa.ke...@tycoelectronics.com wrote: ** It is, which is why it's so weird that this is not working. I've decided to just do a check to see if the user has an AR account and this is working a lot better. (if it is uppercase, that means the user came in with a guest account) Lisa From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Tanner, Doug Sent: Friday, August 07, 2009 7:29 AM To: arslist@ARSLIST.ORG Subject: Re: Checking $USER$ ** Is your database case insensitive? Doug From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa Sent: Thursday, August 06, 2009 8:48 AM To: arslist@ARSLIST.ORG Subject: FW: Checking $USER$ ** I need to know if the $USER$ is in upper or lower case, so in my Active Link I put in the Run If field: $USER$ LIKE [A-Z]% But my actions run no matter if the $USER$ is in lower case or upper case….(I only want it to run if the User is in uppercase) Not sure why this is doing this... Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax lisa.ke...@tycoelectronics.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ DISCLAIMER Important! This message is intended for the above named person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient of this e-mail and have received it in error, please immediately notify the sender by return email and then delete it from your mailbox. This message may be protected by the attorney-client privilege and/or work product doctrine. Accessing, copying, disseminating or re-using any of the information contained in this e-mail by anyone other than the intended recipient is strictly prohibited. Finally, you should check this email and any attachments for the presence of viruses, as the sender accepts no liability for any damage caused by any virus transmitted by this email. Thank you. _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 Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Checking $USER$
Lisa, The list seems to be terribly slow these days so I took the liberty to CC you my response.. Did you check the permissions on the Active Link? Are you trying this on the thick or the thin client? Did you flush the Mid-Tier cache if you are trying the thin client? I am assuming your user names are not mixed case with no exceptions??? You either have all upper or all lower? Try this if you still haven't managed to get the approach you tried to work.. Set a temporary field say ztmpLoginName to UPPER($USER$) and then compare it in another Active Link to the actual value of $USER$.. if the value is equal, then your login name is all Upper.. if it is not equal then its all lower.. This however will fail if you have Mixed case login names.. Cheers Joe From: Frank Caruso caruso.fr...@gmail.com To: arslist@ARSLIST.ORG Sent: Friday, August 7, 2009 9:58:16 AM Subject: Re: Checking $USER$ If they do not have an account and you allow guest loggins then the $GROUP$ will be NULL for that user. On Fri, Aug 7, 2009 at 4:56 PM, Kemes, Lisalisa.ke...@tycoelectronics.com wrote: ** It is, which is why it's so weird that this is not working. I've decided to just do a check to see if the user has an AR account and this is working a lot better. (if it is uppercase, that means the user came in with a guest account) Lisa From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Tanner, Doug Sent: Friday, August 07, 2009 7:29 AM To: arslist@ARSLIST.ORG Subject: Re: Checking $USER$ ** Is your database case insensitive? Doug From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa Sent: Thursday, August 06, 2009 8:48 AM To: arslist@ARSLIST.ORG Subject: FW: Checking $USER$ ** I need to know if the $USER$ is in upper or lower case, so in my Active Link I put in the Run If field: $USER$ LIKE [A-Z]% But my actions run no matter if the $USER$ is in lower case or upper case….(I only want it to run if the User is in uppercase) Not sure why this is doing this... Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax lisa.ke...@tycoelectronics.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
FW: Checking $USER$
I need to know if the $USER$ is in upper or lower case, so in my Active Link I put in the Run If field: $USER$ LIKE [A-Z]% But my actions run no matter if the $USER$ is in lower case or upper case(I only want it to run if the User is in uppercase) Not sure why this is doing this... Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax lisa.ke...@tycoelectronics.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Checking $USER$
I need to know if the $USER$ is in upper or lower case, so in my Active Link I put in the Run If field: $USER$ LIKE [A-Z]% But my actions run no matter if the $USER$ is in lower case or upper case Not sure why this is doing this... Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax lisa.ke...@tycoelectronics.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
