Table with WI count per document

Description
fbachmann
Posts: 38
Joined: Thu Apr 24, 2014 12:10 pm

Table with WI count per document

Postby fbachmann » Wed Jun 21, 2017 5:00 pm

I'd like to create a table containing a list of documents (their titles) and the number of workitems each of them contains, either for a given project or across the whole repository.

Any pointers? Widgets should be enough, but I'm clueless how to count on a query containing a variable (the document id)...

Thanks in advance for any guidance
François

AmayB
Posts: 3
Joined: Tue Jun 13, 2017 9:35 am

Re: Table with WI count per document

Postby AmayB » Thu Jun 29, 2017 7:52 am

Maybe with an Inline Count Widget per Document?
Do you want something like this?

Code: Select all

<span class="polarion-rp-inline-widget" data-widget="com.polarion.countOfObjects">
  <span class="polarion-rp-widget-parameters">
    <sub id="dataSet">
      <sub id="prototype">WorkItem</sub>
      <sub id="queryType">sql</sub>
      <sub id="sqlColumnsQuery"></sub>
      <sub id="sqlTablesQuery">inner join MODULE on MODULE.C_URI = WORKITEM.FK_URI_PROJECT
--specify additional joins between tables</sub>
      <sub id="sqlRestQuery">--define your search criteria, 'group by' statements, etc.
and MODULE.C_ID='DOCUMENTNAME'</sub>
    </sub>
    <sub id="before">Work Items in DOCUMENTNAME:</sub>
    <sub id="after"></sub>
  </span>
</span>


Just change DOCUMENTNAME with the name of each of your documents name. If you want an only widget, you can copy/paste this code as often as needed in a single Script.

Hope it helps

Amay


Return to “Polarion Application Lifecycle Management (ALM)”

Who is online

Users browsing this forum: No registered users and 1 guest