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 [email protected].
To post to this group, send email to [email protected].
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.
