How to report checkin item from comment

danielchung · Post by **danielchung** » Thu Jan 12, 2006 10:54 am

Our developers will put in working order number in comment when they check in code. But I wonder how can I retrieve the check item(s) from comment field using sql against vault database. A sample sql will be great. Also is there a table schema diagram I can look at? Thanks.

lbauer · Post by **lbauer** » Thu Jan 12, 2006 6:00 pm

You can probably do this from a History query. Show History on the folder or file, then in the Comments tab, select "Include by search string." The query results will return everything with that string in the comment. You can save the query as a text or html file by with the menu item Query->Save Results as . . .