I am attempting to run a script where I am looking for [ServicMGMT::Status >= (Get (CurrentTimestamp) -7*24*3600)].
I have this script that is ran on the server side that queries the database. My problem is that it only acts on the first record of the found set. I will need it to evaluate all the records in the found set which is rouglhly 15 to 20 records.
go to layout
enter find mode
set field [ServicMGMT::Status; "Pending"]
sort records [Ascending; ServiceMGMT::ModifiedTime]
Go to Record/Request/Page [First]
If [ServiceMGMT::ModifiedTime >= (Get (CurrentTimestamp -7 * 24 * 3600)]
Send Mail to AccountName
show all records