In ITSM 7 there is a new Vendor form that seaches across Incident, Problem, Task and Change. The SHR:ConsolidatedList form was the previous way to do this however you would have a very large file since all entries will be listed. Maybe 2 view forms one for each table and then a join. -----Original Message----- From: [EMAIL PROTECTED] To: [email protected] Sent: Wed, 18 Apr 2007 9:47 AM Subject: Searching multiple forms
** Running ARS 5.1.2 The incident table in our application was becoming a bit cumbersome, so we created a stored procedure to archive records that have been closed with a last modified date greater than 180 days old. In extreme cases, our analysts sometimes reopen old tickets for various reasons. Currently, our advice to them is to search the incident form, and if the ticket isn’t found there, to open our archive_incident form and search there. My functional would like me to create workflow that will allow our analysts to search both forms simultaneously. I know of one way to do this, but I’m curious if any of you know of a better, or different way. My suggestion was to create 2 table fields, one that populates from the incident form, and one that populates from the archive_incident form and refresh them based on analyst input (namely, an incident number). This works, but I’m up against a space constraint on the form in question, as well as a general resistance to change of any kind. I don’t know of any other way to search two forms at the same time, but I figured if there was another way, this community would know about it. Thanks, Michael A. McManus, SrA, USAF Remedy Developer HQ 754 ELSG/DOOH DSN: 596-6478/Comm: 334-416-6478 __20060125_______________________This posting was submitted with HTML in it___ ________________________________________________________________________ AOL now offers free email to everyone. Find out more about what's free from AOL at AOL.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
