nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

count of workitems of particular workqueue

mitesh

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)

Find more posts tagged with

Comments

Kris Whiting

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

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 ?