El domingo, 22 de julio de 2012 17:39:29 UTC-3, Cliff Kachinske escribió: > > I have a need to provide an index of both people and organizations on the > same view. > > In raw sql it would be something like this > > SELECT name FROM organizations WHERE something > UNION > SELECT CONCAT(first_name, last_name) AS name FROM people WHERE something > ORDER BY name; > > DAL doesn't support CONCAT, and I don't want to mess with raw sql if I can > avoid it. > > You can use virtualfield [0] >
Jose [0] http://www.web2py.com/books/default/chapter/29/6 --
