How can I specify multiple 'Contact Filter' or create a custom one for 'Read Contacts from xConnect' pipeline step ?

  • Were you able to find a solution?
    – Sujana
    Commented May 21, 2019 at 11:53
  • Could you provide some example of multiple 'Contact Filter'? It would help to find some solution. Commented May 21, 2019 at 13:20

1 Answer 1


Notice that the Filter Expression template has these insert options:

filter expression insert options

This means that Filter Expressions can have sub Filter Expressions.

Then it's just a matter of setting the desired Logical Operator on each Filter Expression.

filter expression logical operator

I was able to run this without any errors and I got the result I was expecting. If you get errors, it's probably because something was misconfigured. If you don't any get errors, but don't get the results you expect, test a very simple case and also make sure to clear out the Requested At and Last Run Finished fields on the pipeline batch to get a fresh start.

reset pipeline batch timestamps

I'm also a fan of clearing out all of the contacts prior to doing this type of testing. Run these queries on both shards (source):

FROM [CLIENT_Xdb.Collection.Shard0].[xdb_collection].[ContactIdentifiers]
FROM [CLIENT_Xdb.Collection.Shard0].[xdb_collection].[ContactIdentifiersIndex]
FROM [CLIENT_Xdb.Collection.Shard0].[xdb_collection].[ContactFacets]
FROM [CLIENT_Xdb.Collection.Shard0].[xdb_collection].[InteractionFacets]
FROM [CLIENT_Xdb.Collection.Shard0].[xdb_collection].[Interactions]
FROM [CLIENT_Xdb.Collection.Shard0].[xdb_collection].[Contacts]

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.