Just figured out an advanced text mode filter that is too intriguing to not share, where I learned:
See below for the gory details, if yee dare.
Regards,
Doug
OR:1:DE:Date Completed_Mod=isnull
OR:1:EXISTS:a:$$EXISTSMOD=EXISTS
OR:1:EXISTS:a:$$OBJCODE=TASK
OR:1:EXISTS:a:name=%Package%%ship%
OR:1:EXISTS:a:name_Mod=like
OR:1:EXISTS:a:projectID=FIELD:projectID
OR:1:EXISTS:a:status=CPL NAP
OR:1:EXISTS:a:status_Mod=in
OR:1:name=%F OP 860 %
OR:1:name_Mod=like
OR:1:status=CPL NAP
OR:2:DE:Date Completed_Mod=isnull
OR:2:EXISTS:a:$$EXISTSMOD=EXISTS
OR:2:EXISTS:a:$$OBJCODE=TASK
OR:2:EXISTS:a:name=%Package%%ship%
OR:2:EXISTS:a:name_Mod=like
OR:2:EXISTS:a:projectID=FIELD:projectID
OR:2:EXISTS:a:status=CPL NAP
OR:2:EXISTS:a:status_Mod=in
OR:2:name=%F OP 861 %
OR:2:name_Mod=like
OR:2:status=CPL NAP
Topics help categorize Community content and increase your ability to discover relevant content.
BUT WAIT! There’s more!
For each “needs investigation” Task row, this is the textmode that will then reach up from the Task to enumerate all of its Project’s Tasks and then bring back the checklist Task(s) into their own (single) column, revealing the source(s) of the OR EXISTS infraction.
Old dog. New tricks.
Regards,
Doug
column.4.displayname=F OP 861 vs F OP 860
column.4.listdelimiter=<div>
column.4.listmethod=nested(project.tasks).lists
column.4.sharecol=true
column.4.textmode=true
column.4.type=iterate
column.4.valueexpression=IF(CONTAINS("F OP 861 ",{name}),{name},"")
column.4.valueformat=HTML
column.5.displayname=F OP 860
column.5.listdelimiter=<div>
column.5.listmethod=nested(project.tasks).lists
column.5.textmode=true
column.5.type=iterate
column.5.valueexpression=IF(CONTAINS("F OP 860 ",{name}),{name},"")
column.5.valueformat=HTML