Hi!
In our live DSpace server, 2 level workflow (i.e. metadata editing and
approving) has been setup. Although for each submission to the workflow,
an email is generated indicating that an item has been submitted for
approval, is there any quick way (Postgresql sql query) to find out at a
given instance how many items are submitted and pending in the workflow
for approval?
I was hovering around the following tables and just got this statistics
form our live system where online submission and simultaneous approval
is progressing well and has reached around 849 student submissions.
Any comments are welcome.
Thanks, Jayan
At 11:45am, today
select * from tasklistitem; gives 1095 records
select * from workflowitem; gives 1119 records
select * from workspaceitem; gives 1437 records
Approved items in the repository gives 831
At 3:10pm today
select * from tasklistitem; gives 1087 records
select * from workflowitem; gives 1110 records
select * from workspaceitem; gives 1457 records
Approved items in the repository gives 849
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
