Thanks Claudia and "count" looks perfect. Now we have 1106 items in the workflow. Oh...
Cheers! Jayan -----Original Message----- From: Claudia Jürgen [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2008 3:39 PM To: Jayan Chirayath Kurian Cc: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] No of Items in Workflow 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 > DSpace-tech@lists.sourceforge.net > 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 DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech