Is 'firstVisit.referralCode' and 'lastVisit.referralCode' on the 'Order' object query-able in any way?
We only want to fetch orders which have 'referralCode' set to specific value. Currently, fetching all the orders and then filtering through them takes a long time.
Is there way to fetch this data efficiently? I looked at the Webhook topic ("Orders/Create") as an alternative, but this would send a message for every order created too, not just the ones with 'referralCode = specificValue'.