How can I query a CharField with Choices based on Choice text?

Question

Let's suppose I have this:

class Contrato(models.Model):
    cliente = models.ForeignKey(Cliente)
    STATUS = (
        ('A', 'Aguardando material'),
        ('B', 'Em produção'),
        ('C', 'Concluído'),
    )
    status = models.CharField(max_length=2, choices=STATUS, default='B')
    codigo = models.CharField(max_length=255, unique=True, verbose_name='código', error_messages={'unique': 'Já existe um cliente com este'})

On the dashboard, there's a bar to search for Contratos, and this query:

contratos = Contrato.objects.filter(Q(codigo__icontains=query) | Q(cliente__nome__icontains=query) | Q(status__icontains=query))

However, i can only search for status actual value('A', 'B', 'C'), is there any possible way to search for the actual text('Concluído', 'Produção', etc)?

check this: http://stackoverflow.com/questions/4727327/django-filter-for-get-foo-display-in-a-queryset — Lukasz Koziara, Jan 23 '14 at 12:34
There is [a way](https://stackoverflow.com/a/47399716/2996101) to achieve such a result using a loop. — raratiru, Nov 20 '17 at 19:37

score 0 · Answer 1 · answered Jan 23 '14 at 15:15

0

You can't do this. The values actually saved to the DB are 'A', 'B', 'C' in order to save storage space. Since your query is converted to a DB query (usually SQL), and runs on the DB itself, you can only query for the short values.

answered Jan 23 '14 at 15:15

Tzach

12,889
11
68
115

How can I query a CharField with Choices based on Choice text?

1 Answers1