SQL Active Link Question
Hi All I have an active link that fires on Return that does a SQL search based on the information in the field. The list will display the information like this: XYZ Company Y Y N Is there a way to put a column heading on the Selection List so the end user knows what the values are about? Something like CompanyActive Current Special Procedure XYZ Company Y Y N ARS 6.3 patch 20 Oracle 9.2 Thanks Mark Mark Brittain Remedy Developer NaviSite mbritt...@navisite.commailto:mbritt...@navisite.com (315) 453-2912 x5335 (Phone) (315) 317.2897 (Cell) This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: SQL Active Link Question
** 1. Use a union. 2. Add a 0/1 on the end of your select so you can put your header at the top via an order by clause Something like: Select 'Company','Active','Current','Special','Procedure',0 UNION select your selection list to match the above, 1 any other bit of SQL order by 6,any other sort criteria you need Thad Esser Remedy Developer From: Brittain, Mark mbritt...@navisite.com To: arslist@ARSLIST.ORG Date: 05/20/2010 12:48 PM Subject: SQL Active Link Question Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG ** Hi All I have an active link that fires on Return that does a SQL search based on the information in the field. The list will display the information like this: XYZ Company Y Y N Is there a way to put a column heading on the Selection List so the end user knows what the values are about? Something like Company Active Current Special Procedure XYZ Company Y Y N ARS 6.3 patch 20 Oracle 9.2 Thanks Mark Mark Brittain Remedy Developer NaviSite mbritt...@navisite.com (315) 453-2912 x5335 (Phone) (315) 317.2897 (Cell) This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ *IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature. * _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_
Re: SQL Active Link Question
** Oops... forgot the from dual part. Select 'Company','Active','Current','Special','Procedure',0 from dual UNION ... Thad Esser Remedy Developer From: Thad K Esser tkes...@regence.com To: arslist@ARSLIST.ORG Date: 05/20/2010 12:55 PM Subject: Re: SQL Active Link Question Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG ** 1. Use a union. 2. Add a 0/1 on the end of your select so you can put your header at the top via an order by clause Something like: Select 'Company','Active','Current','Special','Procedure',0 UNION select your selection list to match the above, 1 any other bit of SQL order by 6,any other sort criteria you need Thad Esser Remedy Developer From: Brittain, Mark mbritt...@navisite.com To: arslist@ARSLIST.ORG Date: 05/20/2010 12:48 PM Subject: SQL Active Link Question Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG ** Hi All I have an active link that fires on Return that does a SQL search based on the information in the field. The list will display the information like this: XYZ Company Y Y N Is there a way to put a column heading on the Selection List so the end user knows what the values are about? Something like Company Active Current Special Procedure XYZ Company Y Y N ARS 6.3 patch 20 Oracle 9.2 Thanks Mark Mark Brittain Remedy Developer NaviSite mbritt...@navisite.com (315) 453-2912 x5335 (Phone) (315) 317.2897 (Cell) This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ *IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature. * _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ *IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature. * _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_
Re: SQL Active Link Question
** using the dual function eg:SELECT "Company Active Current Special Procedure" FROM DUAL;SELECT C8, C536870913, C7 from T### WHERE C536870913 = "$MY_VALUE$"YVMWPK-Original Message-From: mbritt...@navisite.comSent: Thu, 20 May 2010 15:48:06 -0400To: arslist@arslist.orgSubject: SQL Active Link Question Hi All I have an active link that fires on Return that does a SQL search based on the information in the field. The list will display the information like this: XYZ Company Y Y N Is there a way to put a column heading on the Selection List so the end user knows what the values are about? Something like Company Active Current Special Procedure XYZ Company Y Y N ARS 6.3 patch 20 Oracle 9.2 Thanks Mark Mark Brittain Remedy Developer NaviSite mbritt...@navisite.com (315) 453-2912 x5335 (Phone) (315) 317.2897 (Cell) This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. Try FREE IM ToolPack at www.imtoolpack.com Capture screenshots, upload images, edit and send them to your friends through IMs, post on Twitter, Facebook, MySpace, LinkedIn – FAST! _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_
Active Link Question
When performing a Set Field action from an AL, I have it set to if multiple requests match - Display a List. Is there a way to dictate the order in which this list is displayed? I can't figure out how it's determining the order. Thanks, Andy L. Mayfield Sr. Protection Control Technician Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
AW: Active Link Question
Form - Form Properties - Sort Kind Regards Conny -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Mayfield, Andy L. Gesendet: Montag, 8. März 2010 17:00 An: arslist@ARSLIST.ORG Betreff: Active Link Question When performing a Set Field action from an AL, I have it set to if multiple requests match - Display a List. Is there a way to dictate the order in which this list is displayed? I can't figure out how it's determining the order. Thanks, Andy L. Mayfield Sr. Protection Control Technician Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com 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: Active Link Question
It should be using the default sort order of the form you are reading the data from -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mayfield, Andy L. Sent: Monday, March 08, 2010 10:00 AM To: arslist@ARSLIST.ORG Subject: Active Link Question When performing a Set Field action from an AL, I have it set to if multiple requests match - Display a List. Is there a way to dictate the order in which this list is displayed? I can't figure out how it's determining the order. Thanks, Andy L. Mayfield Sr. Protection Control Technician Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Active Link Question
It comes out in the sort order defined for the form. Regards, Chuck Baldi On Mon, Mar 8, 2010 at 10:59 AM, Mayfield, Andy L. almay...@southernco.com wrote: When performing a Set Field action from an AL, I have it set to if multiple requests match - Display a List. Is there a way to dictate the order in which this list is displayed? I can't figure out how it's determining the order. Thanks, Andy L. Mayfield Sr. Protection Control Technician Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com 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: Active Link Question
If you are sure you need a list you need to do additional workflow that will open the form and mosify what you need. It is unusual to need to set an AL to display a list. -Original Message- From: Mayfield, Andy L. almay...@southernco.com To: arslist@ARSLIST.ORG Sent: Mon, Mar 8, 2010 10:59 am Subject: Active Link Question When performing a Set Field action from an AL, I have it set to if multiple requests match - Display a List. Is there a way to dictate the order in which this list is displayed? I can't figure out how it's determining the order. Thanks, Andy L. Mayfield Sr. Protection Control Technician Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 _ __ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com 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: Active Link Question
Andy, If memory serves, it uses the default sort order of the target form. Good luck, Matt R. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mayfield, Andy L. Sent: Monday, March 08, 2010 10:00 AM To: arslist@ARSLIST.ORG Subject: Active Link Question When performing a Set Field action from an AL, I have it set to if multiple requests match - Display a List. Is there a way to dictate the order in which this list is displayed? I can't figure out how it's determining the order. Thanks, Andy L. Mayfield Sr. Protection Control Technician Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com 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: Active Link Question
Thanks for all the quick responses. Given the number and speed at which I received them, I feel like I should have known that already (-: Andy L. Mayfield Sr. Protection Control Technician Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Matt Reinfeldt Sent: Monday, March 08, 2010 10:15 AM To: arslist@ARSLIST.ORG Subject: Re: Active Link Question Andy, If memory serves, it uses the default sort order of the target form. Good luck, Matt R. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mayfield, Andy L. Sent: Monday, March 08, 2010 10:00 AM To: arslist@ARSLIST.ORG Subject: Active Link Question When performing a Set Field action from an AL, I have it set to if multiple requests match - Display a List. Is there a way to dictate the order in which this list is displayed? I can't figure out how it's determining the order. Thanks, Andy L. Mayfield Sr. Protection Control Technician Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com 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: Active Link Question
We use it to assign Groups and Technicians. We have a Work Action field with options like, Assign to Group, Assign to Tech Same Group, Assign to Tech New Group, etc. Based on what you select, a list of groups, techs or groups/techs appear. This is the only place that I can think of where we display a list. Andy L. Mayfield Sr. Protection Control Technician Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Roger Justice Sent: Monday, March 08, 2010 10:12 AM To: arslist@ARSLIST.ORG Subject: Re: Active Link Question If you are sure you need a list you need to do additional workflow that will open the form and mosify what you need. It is unusual to need to set an AL to display a list. -Original Message- From: Mayfield, Andy L. almay...@southernco.com To: arslist@ARSLIST.ORG Sent: Mon, Mar 8, 2010 10:59 am Subject: Active Link Question When performing a Set Field action from an AL, I have it set to if multiple requests match - Display a List. Is there a way to dictate the order in which this list is displayed? I can't figure out how it's determining the order. Thanks, Andy L. Mayfield Sr. Protection Control Technician Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 _ __ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com 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: Active Link Question
If your CSV is just writing a couple of things you could do the same thing with a Process command to write the data out to the .csv file when you press the button. Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Monday, November 17, 2008 5:31 PM To: arslist@ARSLIST.ORG Subject: Re: Active Link Question It's a pretty painful process, but I will attempt to explain. When creating a new record on this form, I have to take GPS coordinates (provided by user), plug them into a mapping program to see where the site is located (predefined territories on the map), then assign it the appropriate number for that territory (1-9). I wanted to create workflow that would create a .CSV file and save it to a specified location, then open the map (which I have linked to the .CSV file) and update. I have it all working except that I have to save the form first; then press the button that fires the workflow. Once it opens I can see what territory it's in and go back and update the ticket. I was hoping to be able to do it before actually saving the form the first time, but it sounds like that might not be feasible. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Monday, November 17, 2008 5:18 PM To: arslist@ARSLIST.ORG Subject: Re: Active Link Question A report is generally pulled from the database and not from the current transaction that has not yet been committed to the database. Why do you want to pull a report before the transaction is committed anyways? Just curious? You could perhaps 'work around' this by committing the transaction to a temporary table using Direct SQL prior to saving the request and pulling the report off that temporary table. Joe From: Mayfield, Andy L. [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, November 17, 2008 5:29:13 PM Subject: Active Link Question I know this is probably simple, but my brain is having more problems than usual this afternoon. I want the active link to create a report from information on the current screen. The thing that has me stumped is that I need to do this prior to the record being saved. I'm able to get it to work after the record is submitted using the qualification of 'Request ID' = $Request ID$, but of course that will only work after the record has been saved and I need to be able to do it before saving. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Active Link Question
I know this is probably simple, but my brain is having more problems than usual this afternoon. I want the active link to create a report from information on the current screen. The thing that has me stumped is that I need to do this prior to the record being saved. I'm able to get it to work after the record is submitted using the qualification of 'Request ID' = $Request ID$, but of course that will only work after the record has been saved and I need to be able to do it before saving. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Active Link Question
It's a pretty painful process, but I will attempt to explain. When creating a new record on this form, I have to take GPS coordinates (provided by user), plug them into a mapping program to see where the site is located (predefined territories on the map), then assign it the appropriate number for that territory (1-9). I wanted to create workflow that would create a .CSV file and save it to a specified location, then open the map (which I have linked to the .CSV file) and update. I have it all working except that I have to save the form first; then press the button that fires the workflow. Once it opens I can see what territory it's in and go back and update the ticket. I was hoping to be able to do it before actually saving the form the first time, but it sounds like that might not be feasible. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Monday, November 17, 2008 5:18 PM To: arslist@ARSLIST.ORG Subject: Re: Active Link Question A report is generally pulled from the database and not from the current transaction that has not yet been committed to the database. Why do you want to pull a report before the transaction is committed anyways? Just curious? You could perhaps 'work around' this by committing the transaction to a temporary table using Direct SQL prior to saving the request and pulling the report off that temporary table. Joe From: Mayfield, Andy L. [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, November 17, 2008 5:29:13 PM Subject: Active Link Question I know this is probably simple, but my brain is having more problems than usual this afternoon. I want the active link to create a report from information on the current screen. The thing that has me stumped is that I need to do this prior to the record being saved. I'm able to get it to work after the record is submitted using the qualification of 'Request ID' = $Request ID$, but of course that will only work after the record has been saved and I need to be able to do it before saving. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Remedy Active Link Question
Is there a way to make an Active Link fire when I change the selection of a Radio Button to show/hide fields, based on the value of this button (And have it fire as I select the value, not based on losing focus, etc)? Thanks! M ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Another Rookie Active Link Question--RESOLVED
In the immortal words of Homer Simpson.Doh!! I hate asking a question only to find the answer is so remarkably simple and somewhat obvious. The list once again saves the day. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Wednesday, October 31, 2007 4:24 PM To: arslist@ARSLIST.ORG Subject: Re: Another Rookie Active Link Question Did you try using the keyword $DEFAULT$ for the fields you want to have their default values on? From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Wednesday, October 31, 2007 4:18 PM To: arslist@ARSLIST.ORG Subject: Another Rookie Active Link Question ** I created an Active Link that's triggered by a button push on a form. The Active Link opens a different form in Submit mode (Open Window action) and I have field mapping setup for several fields from the original form over the newly opened one. So far, so good. My problem is that the form opened from the Active Link is not loading its default values for the fields that are not having values mapped to them. I have some hidden fields that drive some menu options and since their values are not being loaded, the menus are not working. The fields in question are mostly radio buttons and I tried having the active link map those values by simply typing the default value in the mapping setup, but that does not appear to work. I could set up some temp fields on the originating form and have those values mapped to the hidden fields, but I would have thought there was a way to have the default values populated on the form opened by the Open Window action. I see there is a check box for Load Default Values on the active link, but then it will not let me map any of the fields. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are