Text Mode Filter adding OR condition for lastNoteEntryDate=Null

[Mrobi]

Hi,

I need some basic help with syntax…

I have a report which shows active tasks that are 30 days past the Planned Completion Date (i.e. Late Tasks) and do not have a recent update note (showing the PM is aware and on top of it). 

 numberOfChildren=1

 numberOfChildren_Mod=lt

 plannedCompletionDate=$$TODAY-30d

 plannedCompletionDate_Mod=lte

 lastNote:entryDate=$$TODAY-30 d

 lastNote:entryDate_Mod=lt

 status=INP        NEW

status_Mod=in

The problem is this text filter does not show me late tasks where the Last Note Entry Date is "Null".   Basically, it's hiding my late tasks if a Last Note was ever entered.
 

I need  to add an OR element to my Last Note Entry Date… here's the basic logic I need -

      … AND (lastNote:EntryDate <= $$TODAY-15 OR  lastNote:EntryDate IS NULL))

[skyehansen · Accepted solution]

maybe I'm missing something but I don't see why you don't just do it in the standard mode. There's nothing in your filter that needs to go to text mode. See screenshot below: