Hi Bruno, Thanks for the info! I will certainly give that try and post results!
You may have saved me from a high dose of nasty headaches! :) Thanks Mart :) On Apr 26, 11:23 pm, Bruno Rocha <[email protected]> wrote: > 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) ?
