On Fri, 2007-03-23 at 05:05 +0000, Andrew M. wrote: > While I've seen very similar issues posted, I have yet to find > something that works for me... > > Also, I'm definitely a Django/Python newb, so I apologize if my > terminology/vocab doesn't make sense... I laid things out as simply as > I could. > > Basically, I want to have a single list combining recent blog posts, > with descriptions, and links I've submitted in a single column > (similar to <a href="http://www.jacobian.org";>Jacob's "jellyroll"</a>, > minus the google searches, etc.), sorted/displayed by date. I've got > two models, in one app; one for posts, one for links. I've got the > basics down, and can display both in my template and order them > properly, but can't combine the two sources together in one list. > > I've used a simple custom view to combine the two queries(?)/their > objects as a list, but then, it seems to take all my posts, and then > all my links, in that order. Hence, if I slice the resulting list at > 10, it will grab the first ten, usually being ten posts, and not get > to the links.... I also couldn't get any kind of union to work any > better.
There's no built-in way to do this -- taking the union of two completely unrelated QuerySets -- but it's fairly easy to do in a couple of lines of Python. Each of the QuerySets you get back are Python iterators. So you need to write another iterator that returns the next item from your possibilities based on a function that works out which is "next" in the sense of working out which element is newer (or whatever your sorting criterion might be). Alternatively, turn the two result sets into lists, concatenate them and sort them using a function that works out when one item is less than other (where the two items could be of the same or different types). This is the same function. This is the same as the first method, except it sucks all the results into memory first. Regards, Malcolm --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
