silreporting_transposeTable

Syntax

silreporting_transposeTable(silTable[, transposedHeaders])

Description

Transpose the specified table.

Parameters

Parameter name

Type

Required

Description

Parameter name

Type

Required

Description

silTabel

SILReportingTable

Yes

The table to be transposed.

transposedHeaders

SILReportingHeader []

No

List of headers that should be displayed for the transposed table.

Return type

SILReportingTable

The transposed table.

Example

In the fallowing example you can see a transposed table which contains the number of opened and resolved issues for a list of projects.

string [] projects = "TEST|FIBR|STEI|GRBI|HGES|RGIS"; string [] resolvedIssues; string [] openedIssues; for(string p in projects) { resolvedIssues[p] += countIssues("project = " + p + " AND status in (Done, Closed, Resolved)"); openedIssues[p] += countIssues("project = " + p + " AND status not in (Done, Closed, Resolved)"); } SILReportingHeader [] headers; SILReportingHeader h1; h1.name = "Opened Issues"; h1.sortable = "sortable"; headers += h1; SILReportingHeader h2; h2.name = "Resolved Issues"; h2.sortable = "sortable"; headers += h2; string [][] rows; for(string p in projects){ rows += {openedIssues[p], resolvedIssues[p]}; } SILReportingTable table; table.headers = headers; table.rows = rows; SILReportingHeader [] transposedHeaders; for(string p in projects){ SILReportingHeader h; h.name = p; h.sortable = "sortable"; transposedHeaders += h; } return silreporting_transposeTable(table, transposedHeaders);