I have searched through the documentation, but have not been able to find the answer to this one.
On a Table List field, on the Results Color tab, why are all the fields on the form (or at least all selected for the results list) not listed in the Selection Field drop-down menu? I wanted to color them based on Priority, but Priority is not one of the fields in the list )-: Andy L. Mayfield System Operation Specialist Alabama Power Company Office: 8-226-1805 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Wednesday, March 14, 2007 4:05 PM To: [email protected] Subject: Re: Table Field Qualification I was finally able to get it to work on our production server. For some reason the 'Resolve Date' field on our Dev server was acting really strange and giving me varying results. It appears to be working on the production server with no problems. I used: ('Assigned Group' = "XXX" AND 'Status' = "Resolved") AND ('Resolve Date' <= ( $TIMESTAMP$ - ( 60 * ( 60* ( 24 * 5 ) ) ) ) Thanks for suggestions. Its sounds I had it right to start with, but was getting weird results on the DEV server. Andy L. Mayfield System Operation Specialist Alabama Power Company Office: 8-226-1805 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Wednesday, March 14, 2007 3:47 PM To: [email protected] Subject: Re: Table Field Qualification Have you tried using that to build an external qualification and using it in the table field? I can't say it will work as you want but considering that field values get expanded after hitting the db, you may stand a chance of success.. Joe ----- Original Message ---- From: "Mayfield, Andy L." <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, March 14, 2007 3:50:40 PM 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 ________________________________ Need Mail bonding? Go to the Yahoo! Mail Q&A <http://answers.yahoo.com/dir/index;_ylc=X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTE wOARfcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnbGluZQRzbGsDbWFpbF90YWcx?link=ask&s id=396546091> for great tips from Yahoo! Answers <http://answers.yahoo.com/dir/index;_ylc=X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTE wOARfcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnbGluZQRzbGsDbWFpbF90YWcx?link=ask&s id=396546091> users. __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
