Django foo_display with values()

Question

Lets say I have a django Model shown below

 Class Student(models.Model):
     name=models.CharField(max_length=100);
     status=models.IntegerField()

status field will only have values 1,2. Is there some way I can replace 1,2 with their corresponding display values say (pass,fail) every time i use them in values() method without iterating further over the queryset. eg:

something like this

Student.objects.values(staus_display_value)

so that this returns a value queryset with display values instead of db values

[{"name":"jane","status":"pass"},
{"name":"john","status":"fail"}]

I know that Model.get_FOO_display() can be used to get display values for individual objects.

you can use this approach stackoverflow.com/a/2224964/3033586 and abstract from using numbers in your queryset ... if doesn't help - edit your question, because it's unclear what you want, maybe add queryset where you have problems — madzohan
– madzohan, Commented Jul 10, 2015 at 6:34
Seems as duplicate of stackoverflow.com/questions/9674860/… — kmmbvnr
– kmmbvnr, Commented Jul 10, 2015 at 7:36

itzMEonTV · Accepted Answer · 2015-07-10 06:38:38Z

2

Try this

class Student(models.Model):
    X_CHOICES = (
            (1, 'Pass'),
            (2, 'Fail'),
        )
    name=models.CharField(max_length=100);
    status = models.IntegerField(default=1,choices=X_CHOICES)

>>>Student.objects.create(name="myname")
>>>s = Student.objects.get(name="myname")
>>>s.get_status_display()
'Pass'

answered Jul 10, 2015 at 6:38

itzMEonTV

20.4k4 gold badges44 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

jithin Over a year ago

this works well single object.Please look @ my question edit

Navneet · Accepted Answer · 2015-07-10 05:37:30Z

0

Yes, you can do the following in your model:

Class Student(models.Model):
    X_CHOICES = (
            (u'1', u'Pass'),
            (u'2', u'Fail'),
        )
    name=models.CharField(max_length=100);
    status = models.IntegerField(default=1,choices=X_CHOICES)

Hope this helps.

answered Jul 10, 2015 at 5:37

Navneet

4,9431 gold badge21 silver badges29 bronze badges

4 Comments

jithin Over a year ago

how can I include these labels in values() method?

Navneet Over a year ago

You don not need to call the values, as the default display value will be "pass"/"fail".

Navneet Over a year ago

The display values will be either "pass"/"fail" but the values saved in the db will be "1"/"2" i.e depending upon the choices

jithin Over a year ago

Sorry I didn't get you.I was saying about obtaining display values in values query set.

Collectives™ on Stack Overflow

Django foo_display with values()

2 Answers 2

1 Comment

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related