Sitecore 9.1
When I manually add an email address to a list, I am wondering where the list and xDB contact are associated. Looking at the code, it looks like it would be a contact facet. But when I pull the facets for my contact, nothing sticks out. Any idea where the list is assigned to the contact or the the contact is assigned to the list. I was the understanding it all happens on the xDB contact.
Update
It looks like the connection is in the contact facets as a facet named ListSubscriptions
. But I have not been able to tie one back to a known contact yet.
SELECT TOP (1000) [ContactId]
,[FacetKey]
,[LastModified]
,[ConcurrencyToken]
,[FacetData]
FROM [sitecore_Xdb.Collection.Shard0].[xdb_collection].[ContactFacets]
WHERE FacetKey = 'ListSubscriptions'