How can I read a date value from the CCM database?
SELECT p.NAME, MAX(w.MODIFIED)
FROM CCM.MODEL.WORK_ITEM w, CCM.PROCESS.PROCESS_AREA p
Where w.CONTEXT_ID = p.CONTEXT_ID
Group by p.NAME
Returns max values such as
1393640590433
1425492026982
1338577294446
How is the number that is returned for MODIFIED, converted into a date? It doesn't appear to be a date from the database point of view (doesn't recognize it as a date). And even trying with MS-Excel, it doesn't convert to a date.
Help please!
Thank you much,
Donna
Accepted answer
Saturday, 1 March 2014 02:23:10 GMT
Wednesday, 4 March 2015 18:00:26 GMT
Friday, 1 June 2012 19:01:34 GMT
Comments
You can find the types in the API. Most are based on the Java Types Duration/long and Timestamp. I agree with Donald, use the reporting solutions or the API to access that data.
We'd love to - we opened a PMR for this type of information, and got nothing for a week, other than here-is-super-basic-info and pay-for-service-then-we'll-help. We have been completely UNIMPRESSED with IBM on reporting support. So due to time constraints to get the information out of the database, we are doing what we have to do to get it done.
Donna, I have access code and value to text/Text to value transformation code published here for pretty much all attribute types: https://rsjazz.wordpress.com/2015/02/27/a-rtc-workitem-command-line-version-2-2/ the code comes with source code. You might want to look into it, if you are not sure about the values. The code you look for is in the WorkItemHelper.
Good luck!
One other answer
Please be aware though that it's not normally a good idea to access the RTC database directly as the attempts could lead to resource contention which may impact performance of the RTC server.
As the schema of the database in not published as a programming interface there's also a real danger that anything you design to extract data from the database could easily be invalidated if those data are changed, moved, removed or deprecated during the development of the product and throughout it's maintenance cycle.
If you're trying to extract data from RTC you are far better served by accessing data from RTC via the published APIs