Okay, so here's how you do it. Put a View Form on top of the H Table.
Point the table field to that if you only need request id. If you need more data, slap a join form on top of the H table and the remedy schema, then point your table field to that. This should work. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Wednesday, March 14, 2007 2:51 PM To: [email protected] 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"
