django query to filter and distinct

Question

I have a table as follows:

table_name : example

values
1
1
2

2
3

3

the value list contains the values as above. When i write a distinct query on the able table, i get 1 2 3 and a empty '' value.

I want to get rid of the null value as it is posing some problems in my program. the query for that which i have written is:

example.objects.values_list('values',flat = True).distinct()

Is there a a way to filter out that empty value

Answer 1

Try this:

from django.db.models import Q
example.objects.exclude(
      Q(values__isnull=True)|Q(values='')
    ).values_list('values', flat=True).distinct()