This plugin may helps you (but I did not tested it yet) web2py full text search plugin http://web2pyslices.com/main/slices/take_slice/115 <http://web2pyslices.com/main/slices/take_slice/115> -- Bruno Rocha [ About me: http://zerp.ly/rochacbruno ]
On Tue, Apr 26, 2011 at 10:43 PM, mart <[email protected]> wrote: > hey Denes, > > yeah like this: > > the DB holds data describing infrastructure info (this is our "build & > releases" web site & DB) & build specific info as well. > > User go there to find build location, status, pull stats , etc.... and > also (and this is the problematic area) build detail. most of the > users could not be bothered with even attempting to eye ball a grid, > let alone remember where to go to get the info they need. > > The other problem, if the info is too hard to find for them, they > complain, which will trickle back down to me when it hits high > enough ;) > > So, i was hoping to be able to do something like this: > > here's a probable scenario: > > a build will log just about everything there is to log about the what, > where, when, who, etc... > > so, a QA manager may be interested to find out if a specific change > has made it into the build. The build will obviously log everything > that it synced (the data is pretty exhaustive - down to the user, date/ > time, diff, other files included in same changelist, the changelist, > revision, etc...). Also, there is other related info found in other > tables. > > back to our user: he may know a few things like a user's name (not > necessarily his account name) and maybe a Jira number (which, if > valid, may point to a specific changelist - maybe even the one he is > concerned with) > > so, i was hoping to have a search box where a user could input a > couple a words, then shortlist could be returned... > > makes sense? > > Admittedly, I am no DBA, and I'm sure the data / tables could be > organized a lot better... but until then, I was hoping for a idea for > a solution to make these things roll smoother... > > Any idea? > > Any help would be much appreciated :) > > Thanks, > Mart :) > > On Apr 26, 8:32 pm, DenesL <[email protected]> wrote: > > Hi Mart, > > > > not that I know of. > > > > Besides, searching all tables sounds strange. > > Can you provide a use case?. > > > > On Apr 26, 8:13 pm, mart <[email protected]> wrote: > > > > > > > > > > > > > > > > > Hi, > > > > > is there a built-in helper (function) to do searches of all tables > > > (which may or may not return many results) ? >
