count of workitems of particular workqueue

Options
mitesh
mitesh
edited January 29, 2009 in Documentum #1

Hello All,

I have the requirement in TaskSpace that , user should be able to see number of work-items are present in work queue.

for example : workqueue1 (10)

                    workqueue2 (11)

                    workqueue3 (20)

Comments

  • Whitik
    Whitik
    edited January 29, 2009 #2
    Options

    This will show you all the queues which have workitems and the number of workitems in each:

    SELECT a_wq_name, count(*) FROM dmi_workitem GROUP BY a_wq_name

  • mitesh
    mitesh
    edited January 29, 2009 #3
    Options

    Thanks Whitik, Is there any configuration changes in TaskSpace, Becoz for this query I must need to customize the component & I have to concat the count result with the Label of Workqueue name.

    Let me correct If I am wrong ?

Categories