Hello Friends,
I want to use the group by based on "*Itinerary ID*". I hope that *"Values"
keywords is using for the "Group By" but when I'm using the **"Values"
keywords for group by. then i'm getting the error for fields name.** Like:-
fields name:--- **user_id, **primary_image, etc*
*'user_id','primary_image','country__url_alias','country__title','itinerarycity__city__url_alias','itinerarycity__city__image','itinerarycity__city__title'*
*My Query Below:-*
*itinerarydata = Itinerary.objects.filter(Q(title__iexact=searchstr,
publish=1) | Q(country__title__iexact=searchstr) |
Q(itinerarycity__city__title__iexact=searchstr))*
*itinerarylistdata =
itinerarydata.select_related('country').select_related('itinerarycity').values('id','title','user_id','primary_image','country__url_alias','country__title','itinerarycity__city__url_alias','itinerarycity__city__image','itinerarycity__city__title').order_by('-id')*
*Print Query:-*
*SELECT `itinerary_itinerary`.`id`, `itinerary_itinerary`.`title`,
`itinerary_itinerary`.`user_id`, `itinerary_itinerary`.`primary_image`,
`continents_country`.`url_alias`, `continents_country`.`title`,
`continents_city`.`url_alias`, `continents_city`.`image`,
`continents_city`.`title` FROM `itinerary_itinerary` LEFT OUTER JOIN
`itinerary_itinerary_country` ON (`itinerary_itinerary`.`id` =
`itinerary_itinerary_country`.`itinerary_id`) LEFT OUTER JOIN
`continents_country` ON (`itinerary_itinerary_country`.`country_id` =
`continents_country`.`id`) LEFT OUTER JOIN `itinerary_itinerarycity` ON
(`itinerary_itinerary`.`id` = `itinerary_itinerarycity`.`itinerary_id`)
LEFT OUTER JOIN `continents_city` ON (`itinerary_itinerarycity`.`city_id` =
`continents_city`.`id`) WHERE ((`itinerary_itinerary`.`publish` = 1 AND
`itinerary_itinerary`.`title` LIKE south africa) OR
`continents_country`.`title` LIKE south africa OR `continents_city`.`title`
LIKE south africa) ORDER BY `itinerary_itinerary`.`id` DESC*
*but I want to make the group by like:*
*WHERE ((`itinerary_itinerary`.`publish` = 1 AND
`itinerary_itinerary`.`title` LIKE south africa) OR
`continents_country`.`title` LIKE south africa OR `continents_city`.`title`
LIKE south africa) Group By ** `itinerary_itinerary`.`id` **ORDER BY
`itinerary_itinerary`.`id` DESC*
*kindly solve my issues.*
*Thanks*
*Pravin Yadav*
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/CAEr6%3DdyZRuRPCn6LYuLvg2oBVG8YJ0oxW%3DhhT3nxoKhSCeX65A%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
