Andy, I've have added a couple of table fields to our Home page. I set the qualification on the table to use a field on the form and then use EXTERNAL($Log Call Query$) to execute the query. It provides a lot more control. I then use an Active Link to set the Log Call Query field. In our case I'm looking for Open tickets assigned to a particular Support Group using the following:
"'Status' <= ""RESPONDED"" AND 'Support-Region' = $Support-Region$ AND 'Support-Desk' = $Support-Desk$ AND 'Support-Group'=$Support-Group$" The active link then refreshes the table. This gives me the flexibility to test the query using the client and with a little substitution execute it for the table field. Dave -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Wednesday, March 14, 2007 3:51 PM To: arslist@ARSLIST.ORG Subject: Table Field Qualification I am attempting to add a table field to our Home Page and I having difficulty with the qualification statement. What I am trying to do is this: Show all tickets that have been assigned to 'Assigned Group' "XXX" with the 'Status' of "Resolved" for 5 or more days. I am able to perform this search in the user tool using the '*Status-History.Resolved.TIME' field. The problem is this not an option in the admin tool on the qualification statement. If I try to type that into the Qualification statement, after I save automatically changes it to '*Status-History.New.TIME'. If anyone has an idea I will try anything at this point. Thanks, Andy L. Mayfield System Operation Specialist Alabama Power Company Office: 8-226-1805 ________________________________________________________________________ _______ 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"
