Hi Jayan, you can view the workflow items via the DSpace admin UI [YourDSpaceURL]/dspace-admin/workflow
Just to count the total number of workflow items would be: select count(*) from workflowitem; hope that helps Claudia Jayan Chirayath Kurian schrieb: > 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 ------------------------------------------------------------------------- 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
