Fetch Using Both AND as well as OR Logic

Unknown
Unknown
in Flows
Fetch Using Both AND as well as OR Logic

Comments

  • Unknown
    Unknown

    Im trying to filter the results of a fetch entities step.
    I need the filter to check if the results both

    [color=red][[/color]Contains(Title, “pqdr”) [color=red]OR[/color] Contains(Title, “crqe”)[b][color=red]][/color][/b] [color=red]AND[/color] ReportedDate>=”Start of Year”

    If I select the checkbox to combine filters using AND, I get [i]no results[/i] since none of the title fields would ever have pqdr AND crqe.

  • Unknown
    Unknown

    Hello,

    What I would suggest that you use the fetch entities step to check for the AND logic, [font=Roboto]ReportedDate>=”Start of Year”, then use a rule collection filter to further filter the results of the fetch by the OR logic, [/font][font=Roboto]Contains(Title, “pqdr”) [/font][font=Roboto][color=red]OR[/color][/font][font=Roboto] Contains(Title, “crqe”). The rule collection filter allows you to create a rule to filter a list of data by. Ive included a link to documentation on how to configure the Rule Collection Filter Step.[/font]
    [font=Roboto]
    [/font]
    [font=Roboto] [/font][url=https://documentation.decisions.com/docs/rule-collection-filter-step]https://documentation.decisions.com/docs/rule-collection-filter-step[/url]

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Register

Categories