I suspect that the field you are checking is a column in the table which will only have a value if a row has been selected. A better way to do it would probably be to ignore the table field on the form and do a set fields actions from the underlying associations form to a temp field on your change form. If the set fields succeeds, the temp field will have a value which means a CI was related to the change. If no records were matched, then a CI wasn't related, and you can throw up your error. The key, then, is just to get the qualification on the set fields action correct so that you match only CI relationships and not things like relationships to other changes, problems, etc.
Does that make sense? I can go into more detail if you'd like. Lyle -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Martinez, Marcelo A Sent: Monday, November 09, 2009 3:26 PM To: arslist@ARSLIST.ORG Subject: Active link to check entry in table Hello All, I'm currently trying to put together an active link that will spit out a warning message to change mgmt users to remind them to add a configuration item. I'm currently running ARS7.1 and ITSM 7.0.03 (Inc, Chg, Pbm). I would like the active link to check the Relationships table under change mgmt and if there are no entries for CIs associations, then spit out the warning message. The message should display when the change has been submitted for approval. What I've done is: created an AL that fires on Submit/Modify with the RunIf: ( 'z2TH_Assoc_Association' = $NULL$ ) AND ( 'Change Request Status' >= "Request For Authorization" AND 'Change Request Status' < "Scheduled") Action 1: Message. Type=Warning. Text: don't forget to add a CI!!!! The problem is that the AL fires even if the CI has been associated. Can someone tell me where I can find documentation on creating an AL that checks a table entry? Thanks! Marcelo _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" 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 Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
