How to use NOT IN sql query in django

Question

Im new to Django. Anyone help me to write "Not In" sql query in django. here i used raw() query set without raw() query set how to write this query in django.

query = 'SELECT basic_uom FROM uom_master WHERE id="'+ id +'" and basic_uom not in (SELECT next_uom from uom_master WHERE id="'+ id +'") and basic_uom not in(SELECT std_uom FROM std_uom_master WHERE id"'+ id +'")ORDER BY next_uom ASC'
data = uom_master.objects.raw(query)

what is the error you are getting..? – DarkRob Aug 27 '19 at 05:20 — DarkRob, Aug 27 '19 at 05:20
Its showing have error in sql query – Satvik Aug 27 '19 at 05:32 — Satvik, Aug 27 '19 at 05:32

Yugandhar Chaudhari · Accepted Answer · 2019-08-27T05:40:48.853

1

If [1,2,3] is your list then you can do something like this, you modify according to your table names

uom_master.objects.filter(id=some_id).exclude(id__in=[1,2,3]).order_by("next_uom")

To get list of ids you can do like

list_of_ids = std_uom_master.objects.filter().values_list("id",flat=True)

filter is your filtering criteria and exclude is records to be omitted.

See filters like id__in and guide about making queries

edited Aug 27 '19 at 05:40

answered Aug 27 '19 at 05:21

Yugandhar Chaudhari

3,831
3
24
40

2

You don't need to call `filter()` here – JPG Aug 27 '19 at 05:27
Yes you are right but OP has where clause and NOT IN here `WHERE id="'+ id +'") and basic_uom not in` @JPG – Yugandhar Chaudhari Aug 27 '19 at 05:35
@Yugandhar Chaudhari Thanks now i got it. – Satvik Aug 27 '19 at 05:38

How to use NOT IN sql query in django

1 Answers1