Obtaining monthly data of review creation
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
Powered by Confluence and Scroll Viewport.