Filter on Collection ViewI have a project report with a column that lists all the tasks under it (using the reference collection). Is it possible to display only incomplete tasks? Can I filter on collections? | Community
Skip to main content
S
SunilDe
Level 3
October 16, 2020
Solved

Filter on Collection ViewI have a project report with a column that lists all the tasks under it (using the reference collection). Is it possible to display only incomplete tasks? Can I filter on collections?

  • October 16, 2020
  • 2 replies
  • 1252 views
No text available
    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by NRYNR
    Hi Sunil, I’m assuming your custom field is a drop down or checkbox with a value of “Y” as a value. Give this a try: valueexpression=IF(!ISBLANK(actualCompletionDate),IF({DE:PRC Milestone}="Y",CONCAT({name},":Date:",{plannedStartDate}," - ",{plannedCompletionDate})))

    2 replies

    N
    NRYNR
    Level 10
    October 16, 2020
    Hi Sunil, You can use valueexpressions in the collection to exclude/include tasks, such as those seen here in the WFPro Text Mode Views in Collections documentation. Obviously, your functions will be different. https://wf-pro.com/textmode/text-mode-views-collections/#current-task Thanks, Narayan
      S
      SunilDeAuthor
      Level 3
      October 16, 2020

      Thanks, Narayan

      It is partially working. What do you think is wrong with the valueexpression below. I can't seem to get a custom filter working. Others work just fine.

      displayname=Milestones

      listdelimiter=<p>

      listmethod=nested(tasks).lists

      textmode=true

      type=iterate

      valueexpression=IF({percentComplete}<100,IF({DE:PRC Milestone}=Y,CONCAT({name},":Date:",{plannedStartDate}," - ",{plannedCompletionDate})))

      valueformat=HTML

      I even tried using (tasks}.{DE:PRC Milestone}

      S
      SunilDeAuthor
      Level 3
      October 16, 2020

      That worked

      R
      RonaldEa
      Level 3
      August 27, 2021

      Try this.

      valueexpression=IF({entryDate}>$$TODAY-2e,{message},)

        Terms & ConditionsAccessibility statement

        Loading footer...