Implement transaction searching


Add the ability to search transaction contents (product, version, comments, etc.). Search results should show a brief summary of the transaction, and when one is selected, it should scroll the grid view to display and automatically select the specified transaction.
Initially integrate ShuffleText's fuzzy search library (pending results).


robe070 wrote Jan 18, 2010 at 6:51 AM

The search should allow for multiple matches to be returned. We symbol serve various parts of our product in seperate pieces. We are currently up to 9 pieces per build. We have a stylised naming convention for our builds. It would be conceivable to search for a type of build (part of Version) and then purge all of those that are older than, say, 3 months. This might even be made into an automatic script that is run monthly. But, read-only builds would need to be skipped without question - no deleting and no requirement for a response from the user.

alerch wrote Jan 19, 2010 at 6:25 AM

This feature request (as I originally entered it) was to allow searching from the UI to find things easier.
You can do what you are asking for with what exists today, via the command line. I don't know your setup completely, but as an arbitrary example, you could do (in powershell):

Get-Transaction -symbolstore [path to your symbol server] -all -includedetails | where { / your criteria, such as / $_.Version -eq "foo" -and $_.TransactionDateTime -lt [System.DateTime]::Now.AddMonths(-3) } | Remove-Transaction -symbolserver [path to symbol server]

Kinks for me to work out include having to specify the symbol server path for every command. But that's just a convenience improvement.

Let me know if what I put above (which I didn't try yet) won't work for you.

robe070 wrote Jan 19, 2010 at 9:32 PM

I won't be in the office for a week so I'll test it then.
In principle, performing a regular purge would be fine by using the command line if we could reach a level of confidence in our scripting and the tools ability to only do what we think we've asked it to do. Our symbol server is critical to our business. I doubt if we could become sufficiently confident. We would need the searching in the UI so that we can see whats been selected and check it before locking or, more particularly, deleting the transactions.

alerch wrote Jan 19, 2010 at 10:43 PM

I understand. If it helps at all, the UI is actually built on top of the command line (they both execute the exact same code). But being able to visually check does give that level of comfort that is often desired when changing processes/tools.

wrote Feb 13, 2013 at 1:32 AM