Exemple #1
0
 public void Apply(BusinessTransactionFilter filter) => _query     = _query.Where($"EXISTS(SELECT bt.event_id FROM epcis.business_transaction bt WHERE bt.event_id = event.id AND bt.transaction_type = {_parameters.Add(filter.TransactionType)} AND bt.transaction_id = ANY({_parameters.Add(filter.Values)}))");
Exemple #2
0
 public void Apply(BusinessTransactionFilter filter) => _filters.AddCondition(QueryFilters.BusinessTransactions, $"transaction_type = {_parameters.Add(filter.TransactionType)} AND transaction_id = ANY({_parameters.Add(filter.Values)})");