I want to show record when task status not equal to
1,Completed
2.Rejected
3.Cancelled
should I used or () , or not() conditions.
I think or() should apply because at a time only on status come in task status not all status come
Discussion posts and replies are publicly visible
What "record" are you trying to show & where are you getting "task status" from? What have you gotten to work so far and what code are you using?
Not a big fan of using not() for these types of conditions since new values added after the fact might accidentally be included.
Why not show the record if the status is contained in a list instead? (I prefer to use contains() instead of or() in most cases).