DF_WFqcs

DF_WFqcs
Prev	2.3. Alphabetical Listing, Legacy Reports	Next

DF_WFqcs — Summary of daily journal transactions for queries

Synopsis

DF_WFqcs {study} [ [-t yy/mm/dd-yy/mm/dd] | [-t ] ] [-u users] [ [-q all] | [-q ext] | [-q int] ] [-P #, #-#] [-S #, #-#] [-v #, #-#] [-test]

Description

This report shows the number of queries validated on each day during the specified time period for each of the requested users. Separate counts are provided for queries that are created, modified, resolved, and deleted each day. The report headings are as follows:

                     EXTERNAL QUERIES(1)            INTERNAL QUERIES(2)
DATE(3)  FROM(4) TO(5)   NEW(6) MOD(7) RES(8) DEL(9) TOT(10)  NEW   MOD   RES   DEL   TOT

(1)	Separate counts are provided for external and internal queries. This set of counts is for external queries.
(2)	This set of counts is for internal queries.
(3)	The date of the changes in `yy/mm/dd` format. Only those dates for which changes occurred are reported.
(4)	The time of the first change on the specific day. Times are reported in `hh:mm` 24-hour notation.
(5)	The time of the last change on the specific day.
(6)	The number of new queries added.
(7)	The number of previously existing queries that were modified. This may include queries that were previously created on the same day.
(8)	The number of queries resolved.
(9)	The number of queries deleted.
(10)	The total number of query changes on the day. Note that the total number of individual queries involved will be less than this total if some queries had more than one change on the day.

Options

-t yy/mm/dd-yy/mm/dd, -t

Include only queries journaled during the specified date range, inclusive

-u users

Include only queries journaled by specified users

-q all, -q ext, -q int

Select only queries having a usage from the list:

all=both internal and external (default)

ext=external

int=internal

-P #, #-#

Include only the specified plate(s)

-S #, #-#

Include only the specified sequence/visit(s)

-v #, #-#

Include only queries validated to the specified level(s)

-test

Test mode. Show options selected and exit without performing report

Examples

Example 2.125. Show all queries journaled by user1 from Jan 6 to Jan 9/18

-u user1 -t 180106~180109

DF_WFqcs WORK FLOW FOR ALL QUERIES

                     EXTERNAL QUERIES             INTERNAL QUERIES
DATE   FROM  TO      NEW   MOD   RES   DEL   TOT   NEW   MOD   RES   DEL   TOT

180106 10:22 16:13    12     2    23    26    63                 2           2
180107 09:10 17:26   112     1     3         116     5          30          35
180108 08:49 09:12     5           7     3    15     1                       1
180109 12:00 14:17    23     2     6     9    40     2     1     3           6

TOTAL                152     5    39    38   234     8     1    35          44

This example shows that on Jan 6, 2018 user1 made a total of 63 journal entries for external queries and a total of 2 journal entries for internal queries. The first query journal entry of the day occurred at 10:22 in the morning and the last one occurred at 4:13 in the afternoon. Of the 63 journal entries for external queries, 12 represented new queries added by user1, 2 were modifications, 23 were query resolutions and 26 were query deletions. Both of the internal queries were resolved.

Note that each journal entry is counted. Thus if a query is added, modified and resolved by user1 on the same day, it is counted as 3 entries in this report.

Prev	Up	Next
DF_WFfaxes	Home	DF_XXkeys