This must be related to the null logic, suppose that you want to search for all values not equal to X in a field and you also want to capture the null values, if you just search for field != "X" you will get all values except null values, to get those too you have to search for them, field != "X" OR field = $NULL$ /L ars
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of David Sebba Sent: Wednesday, May 03, 2006 11:18 PM To: [email protected] Subject: Macro searches problem. (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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
