Test Activity Query

From FollowTheScore
Revision as of 17:16, 18 February 2010 by Gkullberg (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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