AnsweredAssumed Answered

how to omit records in a find script?

Question asked by weedonpaul on Dec 8, 2015
Latest reply on Dec 8, 2015 by siplus

I feel like I should know how to do this.

 

I want to find all the actions for the next 7 days but omit any that are marked as finished. my script looks like this but without the omit part:

 

enter find mode []

set field [actions::action_deadline; Get(CurrentDate) & "..." & Get(CurrentDate)+7]

Perform find [restore]

 

I want to further omit records where Action::status=finished, there isn't a "not equal" to operator that I can put in the status field. so I can't put set field [actions::status; ≠finished]

 

how should I do it?

Outcomes