Django queryset: Exclude all row(s) if any one row with same id is excluded

Question

I am using Django query to filter out some transactions from table where one transaction might have multiple entries in the table.

E.g. Sample table

+---------------+---------+
| TransactionId | Status  |
+---------------+---------+
| Txn0          | Pending |
| Txn0          | Success |
| Txn1          | Fail    |
| Txn2          | Pending |
| Txn3          | Fail    |
| Txn4          | Pending |
| Txn4          | Fail    |
| Txn5          | Pending |
+---------------+---------+

Current query :

SampleTable.objects.exclude(status='Fail').exclude(status='Success')

My current query returns Txn0, Txn2,Txn4, Txn5( because these are marked pending).

I need a queryset which return only row Txn2, Txn5( because all other transaction has atleast one Fail or Success transaction).

Also, tried using .distinct() but that didn't help.

Can you add details about how you tried to use `distinct`? It seems like exactly what you need. — MrName, Apr 04 '18 at 17:20
[something on similar lines...](https://stackoverflow.com/questions/46842758/filter-dataset-not-having-a-value) — NoobEditor, Apr 04 '18 at 17:59

score 2 · Accepted Answer · answered Apr 15 '18 at 12:17

Well, not a straight one. But, first filter all the transactions(row) with Failed/success status.

success_fail_txns = SampleTable.objects.filter(status='Success') 
                       | SampleTable.objects.filter(status='Fail')
pending_txns = SampleTable.objects.exclude(txnid__in=success_fail_txns)

Robert · Answer 2 · 2018-04-04T17:12:59.333

1

you can use exclude with in condition

SampleTable.objects.exclude(status__in=['Fail','Success'])

edited Apr 04 '18 at 17:12

answered Apr 04 '18 at 17:02

Robert

3,373
1
18
34

you need ' around Success :) – Tobit Apr 04 '18 at 17:11
1

Although this is correct, it does not solve OP's problem. i.e. - it would give the same results as the code he posted above. – MrName Apr 04 '18 at 17:20
Agree @MrName. This solution posted is similar to the query I am using. – kartikmaji Apr 04 '18 at 17:31

Django queryset: Exclude all row(s) if any one row with same id is excluded

2 Answers2