Difference between revisions of "Test Activity Query"
From FollowTheScore
(New page: == base query == {{#dpl: |category=Test Activities |linksfrom=Activity Page 1¦Activity Page 2 |include={ActivitySummary}:phase,{Activity Description}:bmcrespons:custrespons:oscoeffort:arc...) |
|||
| Line 5: | Line 5: | ||
|include={ActivitySummary}:phase,{Activity Description}:bmcrespons:custrespons:oscoeffort:archeffort:gpmeffort:pmeffort:sceffort:ceffort:oceffort:osceffort,{ActivitySummary}:priority | |include={ActivitySummary}:phase,{Activity Description}:bmcrespons:custrespons:oscoeffort:archeffort:gpmeffort:pmeffort:sceffort:ceffort:oceffort:osceffort,{ActivitySummary}:priority | ||
|includematch=/\{{!}}\s*phase\s*=\s*{{{includematch|}}}/s | |includematch=/\{{!}}\s*phase\s*=\s*{{{includematch|}}}/s | ||
| − | |format=\n{¦class="wikitable" style="font-size:90%" \n! width="25%"¦Name \n! width="30%" class="unsortable" | + | |format=\n{¦class="wikitable" style="font-size:90%" \n! width="25%"¦Name \n! width="30%" class="unsortable"¦ \n! width="30%" class="unsortable"¦Customer Role \n!class="unsortable"¦PC \n!class="unsortable"¦ARC \n!class="unsortable"¦SPM \n!class="unsortable"¦PM \n!class="unsortable"¦SC \n!class="unsortable"¦C \n!class="unsortable"¦AC \n!class="unsortable"¦RE \n! width="4%"¦S#\n ¦-,\n¦-\n¦[[%PAGE%|%TITLE%]],,\n\n¦} |
|tablerow=\n¦,%%,%%,%%,%%,%%,%%,%%,%%,%%,%%,\n¦%% | |tablerow=\n¦,%%,%%,%%,%%,%%,%%,%%,%%,%%,%%,\n¦%% | ||
|resultsheader=''Showing '''%PAGES%''' Activities''\n | |resultsheader=''Showing '''%PAGES%''' Activities''\n | ||
| Line 18: | Line 18: | ||
|include={ActivitySummary}:phase,{Activity Description}:bmcrespons:custrespons:oscoeffort:archeffort:gpmeffort:pmeffort:sceffort:ceffort:oceffort:osceffort,{ActivitySummary}:priority | |include={ActivitySummary}:phase,{Activity Description}:bmcrespons:custrespons:oscoeffort:archeffort:gpmeffort:pmeffort:sceffort:ceffort:oceffort:osceffort,{ActivitySummary}:priority | ||
|includematch=/\{{!}}\s*phase\s*=\s*{{{includematch|}}}/s | |includematch=/\{{!}}\s*phase\s*=\s*{{{includematch|}}}/s | ||
| − | |format=\n{¦class="wikitable" style="font-size:90%" \n! width="25%"¦Name \n! width="30%" class="unsortable" | + | |format=\n{¦class="wikitable" style="font-size:90%" \n! width="25%"¦Name \n! width="30%" class="unsortable"¦ \n! width="30%" class="unsortable"¦ \n!class="unsortable"¦PC \n!class="unsortable"¦ARC \n!class="unsortable"¦SPM \n!class="unsortable"¦PM \n!class="unsortable"¦SC \n!class="unsortable"¦C \n!class="unsortable"¦AC \n!class="unsortable"¦RE \n! width="4%"¦S#\n ¦-,\n¦-\n¦[[%PAGE%|%TITLE%]],,\n\n¦} |
|tablerow=\n¦,%%,%%,%%,%%,%%,%%,%%,%%,%%,%%,\n¦%% | |tablerow=\n¦,%%,%%,%%,%%,%%,%%,%%,%%,%%,%%,\n¦%% | ||
|resultsheader=''Showing '''%PAGES%''' Activities''\n | |resultsheader=''Showing '''%PAGES%''' Activities''\n | ||
| Line 32: | Line 32: | ||
|include={ActivitySummary}:phase,{Activity Description}:bmcrespons:custrespons:oscoeffort:archeffort:gpmeffort:pmeffort:sceffort:ceffort:oceffort:osceffort,{ActivitySummary}:priority | |include={ActivitySummary}:phase,{Activity Description}:bmcrespons:custrespons:oscoeffort:archeffort:gpmeffort:pmeffort:sceffort:ceffort:oceffort:osceffort,{ActivitySummary}:priority | ||
|includematch=/\{{!}}\s*phase\s*=\s*{{{includematch|}}}/s | |includematch=/\{{!}}\s*phase\s*=\s*{{{includematch|}}}/s | ||
| − | |format=\n{¦class="wikitable" style="font-size:90%" \n! width="25%"¦Name \n! width="30%" class="unsortable" | + | |format=\n{¦class="wikitable" style="font-size:90%" \n! width="25%"¦Name \n! width="30%" class="unsortable"¦ \n! width="30%" class="unsortable"¦Customer Role \n!class="unsortable"¦PC \n!class="unsortable"¦ARC \n!class="unsortable"¦SPM \n!class="unsortable"¦PM \n!class="unsortable"¦SC \n!class="unsortable"¦C \n!class="unsortable"¦AC \n!class="unsortable"¦RE \n! width="4%"¦S#\n ¦-,\n¦-\n¦[[%PAGE%|%TITLE%]],,\n\n¦} |
|tablerow=\n¦,%%,%%,%%,%%,%%,%%,%%,%%,%%,%%,\n¦%% | |tablerow=\n¦,%%,%%,%%,%%,%%,%%,%%,%%,%%,%%,\n¦%% | ||
|resultsheader=''Showing '''%PAGES%''' Activities''\n | |resultsheader=''Showing '''%PAGES%''' Activities''\n | ||
Revision as of 17:14, 18 February 2010
base query
Showing 3 Activities
| Name | Customer Role | PC | ARC | SPM | PM | SC | C | AC | RE | S# | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Activity 1 | 2 | 4 | 0 | 3 | 0 | 0 | 0 | 0 | 2 | ||
| Activity 2 | 1 | 2 | 0 | 0 | 1 | 0 | 0 | 1 | 2 | ||
| Activity 3 | 3 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 |
distinct=strict
Showing 3 Activities
| Name | PC | ARC | SPM | PM | SC | C | AC | RE | S# | ||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Activity 1 | 2 | 4 | 0 | 3 | 0 | 0 | 0 | 0 | 2 | ||
| Activity 2 | 1 | 2 | 0 | 0 | 1 | 0 | 0 | 1 | 2 | ||
| Activity 3 | 3 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 |
distinct=strict+tablesortcol=12
Showing 3 Activities
| Name | Customer Role | PC | ARC | SPM | PM | SC | C | AC | RE | S# | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Activity 3 | 3 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | ||
| Activity 1 | 2 | 4 | 0 | 3 | 0 | 0 | 0 | 0 | 2 | ||
| Activity 2 | 1 | 2 | 0 | 0 | 1 | 0 | 0 | 1 | 2 |
