Fetch Using Both AND as well as OR Logic

Unknown

Fetch Using Both AND as well as OR Logic

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

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]