Hey,
I am trying to come up with a way to tickets touched a day by each
user. The closest I can come up with is this macro.
('Status-History.Work In Progress.TIME' >= "$Start Date$" AND
'Status-History.Work In Progress.TIME' <= "$End Date$" AND
'Status-History.Work In Progress.USER' = "$Username$") OR
('Status-History.Assign.TIME' >= "$Start Date$" AND
'Status-History.Assign.TIME' <= "$End Date$" AND
'Status-History.Assign.USER' = "$Username$") OR ('Status-History.Follow
Up.TIME' >= "$Start Date$" AND 'Status-History.Follow Up.TIME' <= "$End
Date$" AND 'Status-History.Follow Up.USER' = "$Username$") OR
('Status-History.Closed.TIME' >= "$Start Date$" AND
'Status-History.Closed.TIME' <= "$End Date$" AND
'Status-History.Closed.USER' = "$Username$")
This works pretty well, because it excludes multiple touches, and only
pulls up for the day specified. The only problem is that I have 20
users I need to pull this up on. Is there a way to pull a list of
usernames from a file?
Such as this line:
('Status-History.Work In Progress.TIME' >= "$Start Date$" AND
'Status-History.Work In Progress.TIME' <= "$End Date$" AND
'Status-History.Work In Progress.USER' = "$Username$
c:\home\usernames.txt")
I am using Remedy User 6.03.
Thank You,
Myst3k
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
