Remedy - BMC - Excluding Users with Last Modified By

Question

I am trying to build a search string in Remedy,

I am looking for all open Orders submitted more than 5 days ago, and in which the last updater is not one of the 8 members of our team.

I have the below (and yes, I know it's clumsy, I am a beginner)

(('Status*' = "Assigned") OR ('Status*' = "Pending") OR ('Status*' = "Waiting Approval") OR ('Status*' = "Planning") OR ('Status*' = "In Progress")) AND ('Submit Date' <= ($\TIMESTAMP$ - (112 * (60 * 60)))) AND ('Last Modified By' != "User 1") AND ('Last Modified By' != "User 2") AND ('Last Modified By' != "User 3") AND ('Last Modified By' != "User 4") AND ('Last Modified By' != "User 5") AND ('Last Modified By' != "User 6") AND ('Last Modified By' != "User 7") AND ('Last Modified By' != "User 8")

I would appreciate if someone could take the time to give me a hand.

Matt Laurenceau · Answer 1 · 2017-02-09T21:58:44.737

0

the qualification for the date is in seconds, so you need to tell "current time minus 5 days".

('last submit date' < ( $TIMESTAMP$ - 5 * 24 * 24 * 60)) AND ('Status' < "Closed") AND ('last updated by' <> "team1" ) AND ('last updated by' <> "team2" ) AND ... till team8

edited Feb 09 '17 at 21:58

answered Nov 28 '16 at 23:49

Matt Laurenceau

141
6

pinging @daniel-pereira (such qualification string used to work fine for me) – Matt Laurenceau Nov 30 '16 at 14:00
My apologies for the late reply, I couldn't remember my account. Your string did not solve it as apparently my system works in seconds. I am not able to use the – Daniel Pereira Feb 09 '17 at 12:18
Great! Indeed, I forgot a "* 60" on my qualification, that's what happens when "coding" on a text editor ;-) – Matt Laurenceau Feb 09 '17 at 12:22

Remedy - BMC - Excluding Users with Last Modified By

1 Answers1