AnsweredAssumed Answered

how to omit records in a find script?

Question asked by weedonpaul on Dec 8, 2015
Latest reply on Nov 8, 2018 by PeterCortiel

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?