[sqlalchemy] Recipe for text search across multiple fields

2013-05-31 Thread Paul Johnston
Hi, Often you want to offer the user a text box which will search through multiple fields. If the user is looking at the list of orders, they want a search box that will search: order id, customer name, product names, etc. I'm trying to put together a recipe for this, although it's becoming

Re: [sqlalchemy] Recipe for text search across multiple fields

2013-05-31 Thread Michael Bayer
On May 31, 2013, at 5:06 AM, Paul Johnston paul@gmail.com wrote: Hi, Often you want to offer the user a text box which will search through multiple fields. If the user is looking at the list of orders, they want a search box that will search: order id, customer name, product names,

Re: [sqlalchemy] Recipe for text search across multiple fields

2013-05-31 Thread Paul Johnston
Hi, That's fixed it! I was so close :-) I was using mapper.order_by, which I'd hoped order_by(None) would cancel. No worries - it works now. This is in tw2.sqla DbListPage now, and I'll be putting updates in as I get round to it. Paul what's the purpose of cls.query.order_by(None) ?