Filter Data Service Entity

[DimitriLYR]

Hi there,

I need a helping hand.

I have an entity in the Data Service that contains contact emails. I would like to group all the information of the email “a@gmail.com” to send all the data by email, do the same for “b@gmail.com” and so on. Can anyone tell me how I can go about it?

Thanks a lot

[Marta (Marta Miąsko - Office Samurai)]

Hi @DimitriLYR

You may use Query Entity Records Acrtivity:

It will let you get all records that have “a@gmail.com” and then perform other steps for them. The same could be done for “b@gmail.com”.

[DimitriLYR]

Hello, thank you for the response. The problem is that the emails can change. So in advance I don’t have the values.

[Marta (Marta Miąsko - Office Samurai)]

Hi @DimitriLYR

You can use Query Entity Records activity firstly with no filter (or some other specific filter that defines which rows you want to process, eg. column processed = ‘no’ - it all depends on your business scenario) in order to get all rows from data service.

When you have all rows from the entity, by referring to the email field you can get list of unique emails that exist in you entity. Having list of all unique emails, you can query the data service again (Query Entity Records activity) with filter to email field applied.

[DimitriLYR]

Hello Marta, thank you for your advice. Can you tell me how to get the unique email list?

[Marta (Marta Miąsko - Office Samurai)]

Hi @DimitriLYR

You can create variable of type list where you would store list of unique email addresses.

Create variable of list type and iterate through the output from Query Entity Records activity. For each item check email address - if it does not belong to the list with emails, append it. Else - omit.

[DimitriLYR]

Hi marta. thank you ! It’s running