Plastic SCM Query System allows you to easily find data from your repositories:
- Plastic SCM query system allows users to create advanced reports to highlight system usage, project statistics, detect usage pattern or just monitor changes.
- The system has its own query language, with a SQL-like syntax to make it as simple as possible.
- It creates customized statistic so you can always see what is going on in your development.
- It provides a comprehensive set of features designed to give you a better understanding of the current state of your repository content and how it has changed over time
- It provides a starting point to implement a wide variety of development statistics.
- You can perform structured queries and get results as XML or you can choose the format on which you want to view the information so your spreadsheet can export it.
With this system, queries can be done on one object type at a time, although it is possible to search on different repositories at the same time. The available object types are: attributes, attribute types, branches, changesets, links, link types, markers, merges, revisions, users, repositorioes and workspaces. You can get useful information such as the number of revisions a user has created, which would help you see your developers´ productivity or compare two baselines and find the new revisions created on the last one.
Let´s see an example of a query search:
$ cm find revs where date ">" '2007/09/1' --xml --file=statsSep.xml
The result XML file will be:
We have obtained information regarding revisions created from a given date. Once we have the XML file we can export it, for instance into Excel 2007:
Now with this information we can get different statistics, showing for example, revisions by user:
You could also obtain graphic statistics of the weekly revisions (or daily, etc):
Usage examples:
- Revisions created by a given user on a certain period of time and on the main branch:
cm find "revision where owner = "user" and date between "01/01/2007" and "02/02/2007" and branch = "br:/main""
- History of an item on a given branch.
cm find "revision where item = `item:.` and branch = `br:/main/task003´"
- Checked out revisions on different branches.
cm find "revision where revno = `CO´ and (branch = `br/main´ or branch = `br:/main/task002´)" The information you need just a few clicks away through a fast and easy-to-use search on all your Plastic SCM repositories!
