×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Question on Remedy Macro

Question on Remedy Macro

Question on Remedy Macro

(OP)
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?

RE: Question on Remedy Macro

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close