Exemplo n.º 1
0
 public void Apply(BizTransactionParameter param) => _query.Where($"EXISTS(SELECT id FROM epcis.business_transaction WHERE type = ANY({_parameters.Add(param.Values)}) AND event_id = event.id)");
Exemplo n.º 2
0
 public void Apply(BizTransactionParameter param) => _query.Where($"EXISTS(SELECT bt.event_id FROM epcis.business_transaction bt WHERE bt.transaction_type = {_parameters.Add(param.TransactionType)} AND bt.transaction_id = ANY({_parameters.Add(param.Values)}) AND bt.event_id = event.id)");