Andy, If memory serves me correctly, Priority would need to be included on the table field for it to show up in the list to color the rows. If you don't want it to show in the table you can make it hidden.
Dave -------------------------- [EMAIL PROTECTED] (Wireless) ----- Original Message ----- From: Action Request System discussion list(ARSList) <arslist@ARSLIST.ORG> To: arslist@ARSLIST.ORG <arslist@ARSLIST.ORG> Sent: Wed Mar 14 18:58:21 2007 Subject: Another Table Field Question ** 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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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=X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTEwOARfcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnbGluZQRzbGsDbWFpbF90YWcx?link=ask&sid=396546091> for great tips from Yahoo! Answers <http://answers.yahoo.com/dir/index;_ylc=X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTEwOARfcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnbGluZQRzbGsDbWFpbF90YWcx?link=ask&sid=396546091> users. __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___