Django values_list() lowercase

Reventlow

I have query set that I am exporting to CSV.

models.One2OneInfoLog.objects.filter(one_2_one_info=pk).values_list('name', 'location', 'created').order_by('created')

I want the 'name' field to be in lowercase. Is their a way to do that?

afonso

You can use the Database Function 'Lower' to convert to lowercase:

from django.db.models.functions import Lower

models.One2OneInfoLog.objects.filter(one_2_one_info=pk).values_list(Lower('name'), 'location', 'created').order_by('created')

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-06-17

Comments

0 comments

Django retrieve get_foo_value within values_list and annotate query

Django values_list vs values

Does Django queryset values_list return a list object?

Django ORM values_list with '__in' filter performance

R Convert list to lowercase

How to use a list inside values_list() in django?

Django - How to add a value to each tuple in values_list

Lowercase a list of lists

Which is a more efficient method, using a list comprehension or django's 'values_list' function?

Django template: How to use values/values_list

Django: ValueError: Prefetch querysets cannot use raw(), values(), and values_list()

how to filter values_list in django

Change a list of strings to lowercase

Producing a list by summing results of 'values_list' in Django queryset

How does values_list django work?

Django Template: How to display the value of Foreign Key in a values_list

Getting localtime with values_list in django

Is it possible to combine multiple values_list() in Django?

Python list comprehension and lowercase

Does Django makes additional query on accessing prefetched M2M field through "values()" or "values_list()"?

Django values_list extremely slow on large dataset

Converting a list to lowercase in Python

Django ORM: How to use count method inside values_list method?

Django - Redirect uppercase urls to lowercase

if a lowercase element is in the list without changing the list to lowercase

Lowercase Field values django models queryset

Create a list using values_list() in django

django values_list() and image reverse foreign key

count all objects within a values_list Django

TOP Ranking

Article

Django values_list() lowercase

Django values_list() lowercase

Loopback Error: connect ECONNREFUSED 127.0.0.1:3306 (MAMP)

Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

pump.io port in URL

How to import an asset in swift using Bundle.main.path() in a react-native native module

Failed to listen on localhost:8000 (reason: Cannot assign requested address)

Spring Boot JPA PostgreSQL Web App - Internal Authentication Error

Emulator wrong screen resolution in Android Studio 1.3

3D Touch Peek Swipe Like Mail

Double spacing in rmarkdown pdf

Svchost high CPU from Microsoft.BingWeather app errors

How to how increase/decrease compared to adjacent cell

Using Response.Redirect with Friendly URLS in ASP.NET

java.lang.NullPointerException: Cannot read the array length because "<local3>" is null

BigQuery - concatenate ignoring NULL

How to fix "pickle_module.load(f, **pickle_load_args) _pickle.UnpicklingError: invalid load key, '<'" using YOLOv3?

ngClass error (Can't bind ngClass since it isn't a known property of div) in Angular 11.0.3

Can a 32-bit antivirus program protect you from 64-bit threats

Make a B+ Tree concurrent thread safe

Bootstrap 5 Static Modal Still Closes when I Click Outside

Vector input in shiny R and then use it

Assembly definition can't resolve namespaces from external packages