Difference between revisions of "Test Activity Query"
From FollowTheScore
| Line 1: | Line 1: | ||
== base query == | == base query == | ||
| + | <pre> | ||
| + | {{#dpl: | ||
| + | |category=Test Activities | ||
| + | |linksfrom=Activity Page 1¦Activity Page 2 | ||
| + | |include={ActivitySummary}:phase,{Activity Description}:bmcrespons:custrespons:oscoeffort:archeffort:gpmeffort:pmeffort:sceffort:ceffort:oceffort:osceffort,{ActivitySummary}:priority | ||
| + | |includematch=/\{{!}}\s*phase\s*=\s*{{{includematch|}}}/s | ||
| + | |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¦%% | ||
| + | |resultsheader=''Showing '''%PAGES%''' Activities''\n | ||
| + | |oneresultheader=''Showing '''%PAGES%''' Activity''\n | ||
| + | |noresultsheader=''No activities have been defined for this phase.'' | ||
| + | }} | ||
| + | </pre> | ||
{{#dpl: | {{#dpl: | ||
|category=Test Activities | |category=Test Activities | ||
| Line 13: | Line 26: | ||
== distinct=strict == | == distinct=strict == | ||
| + | <pre> | ||
| + | {{#dpl: | ||
| + | |category=Test Activities | ||
| + | |linksfrom=Activity Page 1¦Activity Page 2 | ||
| + | |include={ActivitySummary}:phase,{Activity Description}:bmcrespons:custrespons:oscoeffort:archeffort:gpmeffort:pmeffort:sceffort:ceffort:oceffort:osceffort,{ActivitySummary}:priority | ||
| + | |includematch=/\{{!}}\s*phase\s*=\s*{{{includematch|}}}/s | ||
| + | |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¦%% | ||
| + | |resultsheader=''Showing '''%PAGES%''' Activities''\n | ||
| + | |oneresultheader=''Showing '''%PAGES%''' Activity''\n | ||
| + | |noresultsheader=''No activities have been defined for this phase.'' | ||
| + | |distinct=strict | ||
| + | }} | ||
| + | </pre> | ||
{{#dpl: | {{#dpl: | ||
|category=Test Activities | |category=Test Activities | ||
| Line 27: | Line 54: | ||
== distinct=strict+tablesortcol=12 == | == distinct=strict+tablesortcol=12 == | ||
| + | <pre> | ||
| + | {{#dpl: | ||
| + | |category=Test Activities | ||
| + | |linksfrom=Activity Page 1¦Activity Page 2 | ||
| + | |include={ActivitySummary}:phase,{Activity Description}:bmcrespons:custrespons:oscoeffort:archeffort:gpmeffort:pmeffort:sceffort:ceffort:oceffort:osceffort,{ActivitySummary}:priority | ||
| + | |includematch=/\{{!}}\s*phase\s*=\s*{{{includematch|}}}/s | ||
| + | |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¦%% | ||
| + | |resultsheader=''Showing '''%PAGES%''' Activities''\n | ||
| + | |oneresultheader=''Showing '''%PAGES%''' Activity''\n | ||
| + | |noresultsheader=''No activities have been defined for this phase.'' | ||
| + | |distinct=strict | ||
| + | |tablesortcol=12 | ||
| + | }} | ||
| + | </pre> | ||
{{#dpl: | {{#dpl: | ||
|category=Test Activities | |category=Test Activities | ||
Latest revision as of 18:16, 18 February 2010
base query
{{#dpl:
|category=Test Activities
|linksfrom=Activity Page 1¦Activity Page 2
|include={ActivitySummary}:phase,{Activity Description}:bmcrespons:custrespons:oscoeffort:archeffort:gpmeffort:pmeffort:sceffort:ceffort:oceffort:osceffort,{ActivitySummary}:priority
|includematch=/\{{!}}\s*phase\s*=\s*{{{includematch|}}}/s
|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¦%%
|resultsheader=''Showing '''%PAGES%''' Activities''\n
|oneresultheader=''Showing '''%PAGES%''' Activity''\n
|noresultsheader=''No activities have been defined for this phase.''
}}
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
{{#dpl:
|category=Test Activities
|linksfrom=Activity Page 1¦Activity Page 2
|include={ActivitySummary}:phase,{Activity Description}:bmcrespons:custrespons:oscoeffort:archeffort:gpmeffort:pmeffort:sceffort:ceffort:oceffort:osceffort,{ActivitySummary}:priority
|includematch=/\{{!}}\s*phase\s*=\s*{{{includematch|}}}/s
|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¦%%
|resultsheader=''Showing '''%PAGES%''' Activities''\n
|oneresultheader=''Showing '''%PAGES%''' Activity''\n
|noresultsheader=''No activities have been defined for this phase.''
|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
{{#dpl:
|category=Test Activities
|linksfrom=Activity Page 1¦Activity Page 2
|include={ActivitySummary}:phase,{Activity Description}:bmcrespons:custrespons:oscoeffort:archeffort:gpmeffort:pmeffort:sceffort:ceffort:oceffort:osceffort,{ActivitySummary}:priority
|includematch=/\{{!}}\s*phase\s*=\s*{{{includematch|}}}/s
|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¦%%
|resultsheader=''Showing '''%PAGES%''' Activities''\n
|oneresultheader=''Showing '''%PAGES%''' Activity''\n
|noresultsheader=''No activities have been defined for this phase.''
|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 |
