Obtaining monthly data of review creation

Still need help?

The Atlassian Community is here for you.

Ask the community

To obtain the number of reviews created monthly using a SQL query with field "cru_create_date" of the table "cru_review".

Run the following SQL query example(remember to change "xxxxxxx" to own date) against Fisheye/Crucible database:

SELECT cru_default_source FROM cru_review 
WHERE ( 
( cru_create_date < xxxxxxx ) and ( cru_create_date > xxxxxxx )
and
( cru_state != 'Dead' ) 
);

Field "cru_create_date" uses unix time type which means that date format is in milliseconds and you'll need a convertor.

Last modified on Jul 31, 2018

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.