Login

Filter users by fullname - postgresql

Author:
hamdiakoguz
Posted:
August 22, 2010
Language:
Python
Version:
Not specified
Score:
-1 (after 1 ratings)

Use this to filter users by their full_names by concatanating with postgesql style. mysql uses concat btw. 

1
User.objects.extra(where=["(first_name||' '||last_name) ilike %s"],params=["%%%s%%"%query])

More like this

  1. Add Toggle Switch Widget to Django Forms by OgliariNatan 1 month, 3 weeks ago
  2. get_object_or_none by azwdevops 5 months, 1 week ago
  3. Mask sensitive data from logger by agusmakmun 7 months, 1 week ago
  4. Template tag - list punctuation for a list of items by shapiromatron 1 year, 9 months ago
  5. JSONRequestMiddleware adds a .json() method to your HttpRequests by cdcarter 1 year, 9 months ago

Comments

Please login first before commenting.