Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Huh! I didn't know you could do THAT with a textmode filter...

Avatar

Level 10

Just figured out an advanced text mode filter that is too intriguing to not share, where I learned:

  • you can use % wildcards (because it's Oracle, I suspect) for partial search strings...ok, I knew this one, but had forgotten it
  • you can use an EXISTS or NOTEXISTS on the same object (a Task in this case) to examine the state of custom data on a "peer" (in this case, a different "checklist" Task with a custom form on it that is supposed to have its DE:DATE COMPLETE filled in prior to the Task in question -- namely something similar to "%Package%%ship%" -- but fails to meet that criteria
  • you can combine OR statements with EXISTS and NOTEXISTS (in this case, to examine two such checklist Tasks, with slightly different names)

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

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Level 10

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