Question on Remedy Macro

[dudeirock5]

Somewhat technical user here using Remedy 5.1.2 with Oracle 9i.

Trying to record a macro for from the advanced search bar for searching tickets created in a certain time period by certain groups for auditing and SLA reporting.

For example, 2 of the groups for SLA reporting are "Opns-Tier1" and "Opns-Tier2" . Here is my syntax

'Submitted by Group' = "Opns-Tier1" OR 'Submitted by Group' = "Opns-Tier2" AND ('Arrival Time' <= "$Start Date/Time$") AND ('Arrival Time' >= "$End Date/Time$")

When I perform this, and set the date and time period in the prompt, it will return tickets created by those 2 groups, but not for that time frame. It will return all tickets created by those groups, which is over 42,000 and takes about 3-4 min to populate. I dont really feel like look at all those.

any ideas?

 

[mcdonns]

I think you need brackets around your OR function:

('Submitted by Group' = "Opns-Tier1" OR 'Submitted by Group' = "Opns-Tier2") AND ('Arrival Time' <= "$Start Date/Time$") AND ('Arrival Time' >= "$End Date/Time$")

Also check if your using index fields. Note an index is only used if the returned number of records is > ~ 5% of the total number in the table other wise it does a full table scan. You should also consider how many records you have in the table.

You don't mention who's running the macro, is this going to be used to schedual a search from command line and create an output file or is it a user function. If so perhaps consider a diplay only form with a table on it with this search criteria.