Filter entity rows based on two conditions

[private_matter (Karl)]

Hello. I’m trying to filter data from entity based on two conditions, first based on the user’s runtime email address and second if the template name contains this character “|”. See below screenshot. Result is displaying all rows of the user’s email.

Note: Column binded is Template Name

[Arvind_Kumar1 (Arvind Kumar)]

@private_matter ,

Please remove the If condition from Template Name and just add two filter condition.

This will return matching result. of User and Template name and if Template name is blank then will return all the data.

Make sure you pass the template name and user name to get filtered value else all value will show.

Thanks,
Arvind

[private_matter (Karl)]

tried this

shows all rows including blank template names

[Arvind_Kumar1 (Arvind Kumar)]

@private_matter ,

What are you trying to achive using Is bank?

[private_matter (Karl)]

I’m trying to see if the value of the template name is blank, then it should not show the row.

[Anil_G (Anil Gorthi)]

@private_matter

Then i guess it shpuld be not blank right…you are using isblank so it gets blank values

Cheers

[Arvind_Kumar1 (Arvind Kumar)]

Hello @private_matter ,

you need to implement as below.

[Templates.TemplateName,“!=”,null]

Thanks,
AK

[private_matter (Karl)]

bro you’re a genius. it’s working 100%!!! Thank a lot!