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) ?
