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___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
