OR condition on report prompts? | Community
Skip to main content
N
NickVa7
Level 9
July 24, 2020
Question

OR condition on report prompts?

  • July 24, 2020
  • 4 replies
  • 1140 views

Hi WF Community,

Is it possible to apply an OR condition when you have more than 1 report prompt?

Thanks.

Nick

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    4 replies

    J
    JeremiahBo
    Level 2
    August 5, 2020

    I have the same question.

    SamanthaIsin
    SamanthaIsin
    Level 7
    August 5, 2020

    I also have this question.

      A
      AdamMi
      Level 3
      August 5, 2020

      Hello All,

      This is possible. Below is an example to pull in all tasks and issues that are in the status of NEW on an Assignment Report. I also created a video of how I create prompts easily. https://drop.workfront.com/o0u8kkqE

      opTask:status=NEW&opTask:status_Mod=in&OR:1:task:status=NEW&OR:1:task:status_Mod=in

      Hope this helps.

      J
      JeremiahBo
      Level 2
      August 6, 2020

      Adam, thanks this is helpful, but it is not exactly what I'm looking for or I'm still not setting it up correctly. . . . more specifically, I want a prompt to pull all tasks that have either an assigned name or a team name.

      Right now I can put in a prompt that allows for an input of team name and another prompt that allows for the input of an assignee, but when you put an entry into both prompts, the report only returns one of the prompts and not both. . .. So, I get a report full of tasks assigned to John Doe, but no tasks assigned to Team Doe.

      I'm looking for a way to put in any combination of Team name and Assigned name and get results for any tasks assigned to either.

      A
      AdamMi
      Level 3
      August 6, 2020

      Ok, now I understand better the scenario. There is not going to be a way to do an OR with the prompts so that the user will be able to enter the name of the team OR assigned user. This is only going to be possible through a custom prompt where the values for the fields are static, like my example above. I am not sure of the end goal of the report but if the report is being utilized for users to find work that apply to them it may be possible to utilize wildcards in the filter of the report to accomplish this. But it really depends on the end goal of the report and who will be viewing it.

      Terms & ConditionsAccessibility statement

      Loading footer...