In that case you might need to split up the message into several parts and use the $Field$ part as an actual field selection preceded and succeeded by the 2 different parts of the message coming from the matrix form.. so something like $Part 1 coming from the matrix$ + $Ticket ID$ + $Part 2 of the matrix$ + $Another field if any$ + $Part 3 of the matrix$
Store the different parts in different columns part 1, part 2, part 3 etc in that matrix. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Francois - BTT Sent: Wednesday, May 16, 2007 1:23 PM To: [email protected] Subject: Re: Dynamic Value Qualifications Using the column as the value in my set fields action in a filter will just take the column value as it is and will not replace the $TT Number$ parameter with the relevant ticket number. This is exactly what I wanted to know is how to do a set-fields and use the pre-configured string value from another table instead of building it manually using the Fields menu on the right side of the Value. Francois -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: 16 May 2007 06:47 PM To: [email protected] Subject: Re: Dynamic Value Qualifications It looks like you do not need the external keyword.. All you need to do is use the column name that contains this message in your notification matrix form, to send that sms message.. Have some sort of a primary key in the notification message form that would be used to identify which message you need to send at what time. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Francois - BTT Sent: Wednesday, May 16, 2007 12:38 PM To: [email protected] Subject: Re: Dynamic Value Qualifications Say I have a Notification Matrix form called form A. In this form I store records i.e 000000000000001 $USER$ has submitted ticket $TT Number$ 000000000000002 Trouble Ticket Number $TT Number$ has been assigned to user $Assigned To$ Then I want to create sms message instances on another form based on these message strings. Remedy must then parse the values from the trouble ticket to the string variables. Make sense? Francois -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: 16 May 2007 06:29 PM To: [email protected] Subject: Re: Dynamic Value Qualifications What do you mean? Give me an example.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Francois - BTT Sent: Wednesday, May 16, 2007 12:26 PM To: [email protected] Subject: Re: Dynamic Value Qualifications Joe Is there a way to use the XTRENAL function as the value of setting a field? Francois -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: 16 May 2007 06:15 PM To: [email protected] Subject: Re: Dynamic Value Qualifications Use the keyword EXTERNAL() and insert that field containing that qualification in this keyword.. eg EXTERNAL($QualificationField$) Note that the values of KEYWORDS such as $NULL$ in a Qualification field should be entered as $\NULL$ to escape the $ sign. Else the Keyword would get directly translated before being passed to the qualification resulting in a unexpected result. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Francois - BTT Sent: Wednesday, May 16, 2007 12:09 PM To: [email protected] Subject: Re: Dynamic Value Qualifications Hi Neha, That is great and will work from the client side but how will this work on filter level. How will I pass the qualification string in a set-fields of a filter? Francois -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Vyom Labs - ITSM Support Sent: 16 May 2007 05:10 PM To: [email protected] Subject: Re: Dynamic Value Qualifications <http://www.vyomlabs.com> As per your requirement, what I understand is that: - 1)I have created a Qualification field on form A and created the Active link on it having the Set Field Action Value as $USER$ + " has logged ticket " + $TT$ + " with CTI " + $Category$ + "," + $Type$ "," $Item$ and commit the changes. 2)On form B I have taken the Table Field that takes data i.e. Request Id and Qualification from form A 3)Then, I have created the active link that executes on Menu/Row/Level Choice on form B using the Set Field Action and setting a field by the Value $Column2$. Thereby I am dynamically passing the parameters instead of a hard coding it in the Value part of the Set field action. Hope, it helps you. Regards, Neha www.*vyomlabs*.com <http://www.vyomlabs.com> Consulting | Oursourcing | Training || BMC Remedy BSM | ITIL | IT Governance Francois - BTT wrote: > ** > > Hi All, > > I would like to find out what methods are out there to accomplish the > configuration of *dynamic qualifications* for example; > > Have a table with the following columns and values. > > *Request ID | Qualification* > > 000000000000001 | $USER$ + " has logged ticket " + $TT$ + " with CTI " > + $Category$ + "," + $Type$ "," $Item$ > > I would then like to use the qualification as the Value in a Set > Fields for Active Links or Filters instead of hard coding the string > for setting a field. > > Hope it make sence. > > Regards > > Francois// > > __20060125_______________________This posting was submitted with HTML > in it___ ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.467 / Virus Database: 269.7.1/805 - Release Date: 5/15/2007 10:47 AM No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.467 / Virus Database: 269.7.1/805 - Release Date: 5/15/2007 10:47 AM ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.467 / Virus Database: 269.7.1/805 - Release Date: 5/15/2007 10:47 AM No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.467 / Virus Database: 269.7.1/805 - Release Date: 5/15/2007 10:47 AM ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.467 / Virus Database: 269.7.1/805 - Release Date: 5/15/2007 10:47 AM No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.467 / Virus Database: 269.7.1/805 - Release Date: 5/15/2007 10:47 AM ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.467 / Virus Database: 269.7.1/805 - Release Date: 5/15/2007 10:47 AM No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.467 / Virus Database: 269.7.1/805 - Release Date: 5/15/2007 10:47 AM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
