(this is 6.03) Hi,
I created a macro to query for tickets for a submitter that are open and not currently assigned to the submitter. I'm just starting down this path (macros), and have come up against a problem that I can't figure out. The macro is: ---START--- Escalated HD Tickets Set-schema: HPD:HelpDesk seasvremedy201 Query: 1005='Submitted by' = "$Login$" AND '4' != "$Login$" AND 'Status*' < "Resolved" '260100001' = "$Login$" AND '4' != "$Login$" AND '7' < "Resolved" Form-open: Form-entry-list: 0 Form-final: modify @ end Escalated Help Desk Tickets by Submitter ---END--- This prompts for "Login", and it finds tickets that are open when the ticket is not assigned to that user. The problem is that there are some tickets that are not assigned to any individual, and this search is failing to return those tickets. '4' is "Assignee Login Name" and is blank in these cases. This is a bit confusing for me, since I'd think it would match my condition, because (a blank field) != (a login name). Does anyone have any thoughts or suggestions? I'm not sure if I've described this enough or not, and since this is my first post, be gentle. :-) _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
