I have both SC and MC and I'm using Journey Builder (using Salesforce Data entry) to inject customers into a Journey.
My data model is as follows:
Person Account has many
Orders (master-detail), and an
Order has many
The journey is triggered whenever an update is made to
Order_Payments. What I'm trying to do is check to see if the parent object (Order) has
Order.Status == X. I planned to use Decision Splits to check
Order.Status but the nature of how this activity works is it will find the first matching Order instead of the one related to my injected record.
My idea to get round this would be to do a comparison and use Journey Data.Order_Payments.Order.Id = Contact Data.Order.Id in the filter logic, but the problem with this is that in Marketing Cloud the Order_Payments.Order field is nullable, which means I cannot use it as filter criteria. As this is a syncronised DE I cannot change it either.
Does anyone have any ideas how I can achieve this would recreating Data Extensions and copying data from my sync'd DE's into them? The issue is I need to inject these users relatively quickly and the 1 hour automation run time is not quick enough.