User:Qubit/Sql musings

Notes on SQL, Bugzilla, etc.

Whiteboard Tag Usage
1) Find unique set of bugs we care about

2) Find all whiteboard tags

=> What if we want to select all current whiteboard tags for open bugs?

Let's try working more in general:

( this also restricts to Whiteboards w/ a comma in them, which is not proper syntax )

Grab the output for further processing: (for some reason this format of the query needs to be written as a single line...)

NOTE: The TAB char in the delimiter won't copy-over in a bash terminal, so either scp that command over to the server, or (easier) copy the query over, then dellete the space that the tab is turned into, and create the right char with Ctrl-v TAB.''