Subversion Repositories DevTools

Rev

Blame | Last modification | View Log | RSS feed

<?xml version = "1.0"?>
<project-list>
<project>
<project-name>Vasttrafik 2005</project-name>
<project-logo>VTGraphic.gif</project-logo>
<template-list>
<template>
<ds-name>VT5DM</ds-name>
<template-name>VT Development Issues</template-name>
<template-sql>SELECT DISTINCT admin_software_issue.new_num AS DEVI, admin_software_issue.headline AS Title, cast(admin_software_issue.description as varchar(7000)) as description, admin_software_issue.priority, admin_software_issue.iteration_affected AS Iteration, admin_software_issue.submit_date AS submitted, admin_software_issue.product, admin_software_issue.package_ref AS Package, admin_software_issue.issue_type AS Type, admin_users.login_name AS Owner, admin_statedef.name AS State, admin_software_issue.estimated_time_inhours as Estimate, admin_software_issue.change_id, admin_software_issue.component  FROM ((admin.software_issue as admin_software_issue  with (nolock) INNER JOIN admin.users as admin_users with (nolock) ON admin_software_issue.owner = admin_users.dbid) INNER JOIN admin.statedef as admin_statedef with (nolock) ON admin_software_issue.state = admin_statedef.id) order by admin_software_issue.new_num</template-sql>
<style-sheet>pdt.css</style-sheet>
<highlight-list>
<highlight>
<style-class>openStateNotAssignedStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Open</field-value>
<field-operation>equal</field-operation>
</styleItem>
<styleItem>
<field-name>owner</field-name>
<field-value>apichan</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
<highlight>
<style-class>openStateAssignedStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Open</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
<highlight>
<style-class>implementedStateStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Implemented</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
<highlight>
<style-class>closedStateStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Closed</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
<highlight>
<style-class>reqclosedStateStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Request_Close</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
</highlight-list>
<column-list>
<column>
<field-name>devi</field-name>
<datatype>string</datatype>
<format/>
<label>Issue ID</label>
<sort-field>true</sort-field>
<filter>false</filter>
<column-width>10%</column-width>
<link>http://erg:8002/ManagerSuite/Release_Manager/_wform_issues_notes.asp?iss_db_name=VT5DM&amp;iss_id_num={devi}</link>
<hide-field>false</hide-field>
</column>
<column>
<field-name>product</field-name>
<datatype>string</datatype>
<format/>
<label>Product</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>title</field-name>
<datatype>string</datatype>
<format/>
<label>Title</label>
<sort-field>true</sort-field>
<filter>false</filter>
<column-width>25%</column-width>
<hide-field>false</hide-field>
<link/>
</column>
<column>
<field-name>component</field-name>
<datatype>string</datatype>
<format/>
<label>Component</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<hide-field>false</hide-field>
<link/>
</column>
<column>
<field-name>state</field-name>
<datatype>string</datatype>
<format/>
<label>State</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>priority</field-name>
<datatype>string</datatype>
<format/>
<label>Priority</label>
<sort-field>true</sort-field>
<filter>false</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>owner</field-name>
<datatype>string</datatype>
<format/>
<label>Owner</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>iteration</field-name>
<datatype>string</datatype>
<format/>
<label>Iteration</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>estimate</field-name>
<datatype>int</datatype>
<format/>
<label>Est</label>
<sort-field>true</sort-field>
<filter>false</filter>
<column-width>100%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>description</field-name>
<datatype>string</datatype>
<format/>
<label>Description</label>
<sort-field/>
<filter>false</filter>
<column-width/>
<link/>
<hide-field>true</hide-field>
</column>
</column-list>
</template>
</template-list>
</project>
<project>
<project-name>Vasttrafik</project-name>
<project-logo>VTGraphic.gif</project-logo>
<template-list>
<template>
<ds-name>DEVIM</ds-name>
<template-name>VT Weekly New DEVI Issues</template-name>
<template-sql>SELECT admin_software_issue.new_num AS DEVI, admin_software_issue.headline AS Title,cast(admin_software_issue.description as varchar(7000)) as description, admin_software_issue.priority,admin_software_issue.iteration_affected AS Iteration, isnull(admin_history.action_timestamp, admin_software_issue.submit_date) as date_created,admin_history.action_timestamp,admin_software_issue.product, admin_software_issue.package_ref AS Package, admin_software_issue.issue_type AS Type,admin_users.login_name AS Owner, admin_statedef.name AS State, admin_software_issue.estimated_time_inhours as Estimate FROM admin.software_issue as admin_software_issue  with (nolock)INNER JOIN admin.users as admin_users with (nolock) ON admin_software_issue.owner = admin_users.dbid INNER JOIN admin.statedef as admin_statedef with (nolock) ON admin_software_issue.state = admin_statedef.id LEFT OUTER JOIN admin.history as admin_history with (nolock) ON admin_history.old_state = 'no_value' AND (admin_software_issue.dbid = admin_history.entity_dbid) WHERE isnull(admin_history.action_timestamp, admin_software_issue.submit_date) &gt; getdate()-60 and (admin_software_issue.project='Vas Traffik 2/3') ORDER BY admin_software_issue.new_num DESC</template-sql>
<style-sheet>devi.css</style-sheet>
<highlight-list>
<highlight>
<style-class>openStateNotAssignedStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Open</field-value>
<field-operation>equal</field-operation>
</styleItem>
<styleItem>
<field-name>owner</field-name>
<field-value>apichan</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
<highlight>
<style-class>openStateAssignedStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Open</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
<highlight>
<style-class>implementedStateStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Implemented</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
<highlight>
<style-class>closedStateStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Closed</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
<highlight>
<style-class>reqclosedStateStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Request_Close</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
</highlight-list>
<column-list>
<column>
<field-name>devi</field-name>
<datatype>string</datatype>
<format/>
<label>Issue ID</label>
<sort-field>true</sort-field>
<filter>false</filter>
<column-width>10%</column-width>
<link>http://erg:8002/ManagerSuite/Release_Manager/_wform_issues_notes.asp?iss_db_name=DEVI&amp;iss_id_num={devi}</link>
<hide-field>false</hide-field>
</column>
<column>
<field-name>product</field-name>
<datatype>string</datatype>
<format/>
<label>Product</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>title</field-name>
<datatype>string</datatype>
<format/>
<label>Title</label>
<sort-field>true</sort-field>
<filter>false</filter>
<column-width>24%</column-width>
<hide-field>false</hide-field>
<link/>
</column>
<column>
<field-name>state</field-name>
<datatype>string</datatype>
<format/>
<label>State</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>priority</field-name>
<datatype>string</datatype>
<format/>
<label>Priority</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>owner</field-name>
<datatype>string</datatype>
<format/>
<label>Owner</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>iteration</field-name>
<datatype>string</datatype>
<format/>
<label>Iteration</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>estimate</field-name>
<datatype>int</datatype>
<format/>
<label>Est</label>
<sort-field>true</sort-field>
<filter>false</filter>
<column-width>5%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>date_created</field-name>
<datatype>datetime</datatype>
<format>d-MMM-yy HH:mm</format>
<label>Date Created</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>100%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>description</field-name>
<datatype>string</datatype>
<format/>
<label>Description</label>
<sort-field/>
<filter>false</filter>
<column-width/>
<link/>
<hide-field>true</hide-field>
</column>
</column-list>
</template>
<template>
<ds-name>DEVIM</ds-name>
<template-name>VT FAT Issues</template-name>
<template-sql>SELECT distinct admin_software_issue.new_num AS DEVI, upper(left(admin_software_issue.headline,20)) as sort_title, admin_software_issue.headline AS Title, cast(admin_software_issue.description as varchar(7000)) as description, admin_software_issue.priority, admin_software_issue.iteration_affected AS Iteration, admin_software_issue.submit_date AS submitted, admin_software_issue.product, admin_software_issue.package_ref AS Package, admin_software_issue.issue_type AS Type, admin_users.login_name AS Owner, admin_statedef.name AS State, admin_software_issue.estimated_time_inhours as Estimate FROM ((admin.software_issue as admin_software_issue  with (nolock) INNER JOIN admin.users as admin_users with (nolock) ON admin_software_issue.owner = admin_users.dbid) INNER JOIN admin.statedef as admin_statedef with (nolock) ON admin_software_issue.state = admin_statedef.id) INNER JOIN admin.history as admin_history with (nolock) ON (admin_statedef.name = admin_history.new_state) AND (admin_software_issue.dbid = admin_history.entity_dbid)  WHERE ((upper(left(admin_software_issue.headline,20)) like 'FAT %' or upper(left(admin_software_issue.headline,20)) like 'VT VARIA %') AND (UPPER(admin_software_issue.iteration_affected) like 'PDT2%') AND ((admin_software_issue.project)='Vas Traffik 2/3')) ORDER BY upper(left(admin_software_issue.headline,20)), admin_software_issue.new_num DESC</template-sql>
<style-sheet>devi.css</style-sheet>
<highlight-list>
<highlight>
<style-class>openStateNotAssignedStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Open</field-value>
<field-operation>equal</field-operation>
</styleItem>
<styleItem>
<field-name>owner</field-name>
<field-value>apichan</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
<highlight>
<style-class>openStateAssignedStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Open</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
<highlight>
<style-class>implementedStateStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Implemented</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
<highlight>
<style-class>closedStateStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Closed</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
<highlight>
<style-class>reqclosedStateStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Request_Close</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
</highlight-list>
<column-list>
<column>
<field-name>devi</field-name>
<datatype>string</datatype>
<format/>
<label>Issue ID</label>
<sort-field>true</sort-field>
<filter>false</filter>
<column-width>10%</column-width>
<link>http://erg:8002/ManagerSuite/Release_Manager/_wform_issues_notes.asp?iss_db_name=DEVI&amp;iss_id_num={devi}</link>
<hide-field>false</hide-field>
</column>
<column>
<field-name>product</field-name>
<datatype>string</datatype>
<format/>
<label>Product</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>title</field-name>
<datatype>string</datatype>
<format/>
<label>Title</label>
<sort-field>true</sort-field>
<filter>false</filter>
<column-width>30%</column-width>
<hide-field>false</hide-field>
<link/>
</column>
<column>
<field-name>state</field-name>
<datatype>string</datatype>
<format/>
<label>State</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>priority</field-name>
<datatype>string</datatype>
<format/>
<label>Priority</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>owner</field-name>
<datatype>string</datatype>
<format/>
<label>Owner</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>iteration</field-name>
<datatype>string</datatype>
<format/>
<label>Iteration</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>estimate</field-name>
<datatype>int</datatype>
<format/>
<label>Est</label>
<sort-field>true</sort-field>
<filter>false</filter>
<column-width>100%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>description</field-name>
<datatype>string</datatype>
<format/>
<label>Description</label>
<sort-field/>
<filter>false</filter>
<column-width/>
<link/>
<hide-field>true</hide-field>
</column>
</column-list>
</template>
<template>
<ds-name>DEVIM</ds-name>
<template-name>VT Weekly DEVI Issues</template-name>
<template-sql>SELECT distinct admin_software_issue.new_num AS DEVI, admin_software_issue.headline AS Title, cast(admin_software_issue.description as varchar(7000)) as description, admin_software_issue.priority, admin_software_issue.iteration_affected AS Iteration, admin_software_issue.submit_date AS submitted, admin_software_issue.product, admin_software_issue.package_ref AS Package, admin_software_issue.issue_type AS Type, admin_users.login_name AS Owner, admin_statedef.name AS State, admin_software_issue.estimated_time_inhours as Estimate FROM ((admin.software_issue as admin_software_issue  with (nolock) INNER JOIN admin.users as admin_users with (nolock) ON admin_software_issue.owner = admin_users.dbid) INNER JOIN admin.statedef as admin_statedef with (nolock) ON admin_software_issue.state = admin_statedef.id) INNER JOIN admin.history as admin_history with (nolock) ON (admin_statedef.name = admin_history.new_state) AND (admin_software_issue.dbid = admin_history.entity_dbid)  WHERE ((admin_history.action_timestamp&gt;getdate()-7) AND (admin_software_issue.project='Vas Traffik 2/3')) ORDER BY admin_software_issue.new_num DESC</template-sql>
<style-sheet>devi.css</style-sheet>
<highlight-list>
<highlight>
<style-class>openStateNotAssignedStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Open</field-value>
<field-operation>equal</field-operation>
</styleItem>
<styleItem>
<field-name>owner</field-name>
<field-value>apichan</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
<highlight>
<style-class>openStateAssignedStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Open</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
<highlight>
<style-class>implementedStateStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Implemented</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
<highlight>
<style-class>closedStateStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Closed</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
<highlight>
<style-class>reqclosedStateStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Request_Close</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
</highlight-list>
<column-list>
<column>
<field-name>devi</field-name>
<datatype>string</datatype>
<format/>
<label>Issue ID</label>
<sort-field>true</sort-field>
<filter>false</filter>
<column-width>10%</column-width>
<link>http://erg:8002/ManagerSuite/Release_Manager/_wform_issues_notes.asp?iss_db_name=DEVI&amp;iss_id_num={devi}</link>
<hide-field>false</hide-field>
</column>
<column>
<field-name>product</field-name>
<datatype>string</datatype>
<format/>
<label>Product</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>title</field-name>
<datatype>string</datatype>
<format/>
<label>Title</label>
<sort-field>true</sort-field>
<filter>false</filter>
<column-width>30%</column-width>
<hide-field>false</hide-field>
<link/>
</column>
<column>
<field-name>state</field-name>
<datatype>string</datatype>
<format/>
<label>State</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>priority</field-name>
<datatype>string</datatype>
<format/>
<label>Priority</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>owner</field-name>
<datatype>string</datatype>
<format/>
<label>Owner</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>iteration</field-name>
<datatype>string</datatype>
<format/>
<label>Iteration</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>estimate</field-name>
<datatype>int</datatype>
<format/>
<label>Est</label>
<sort-field>true</sort-field>
<filter>false</filter>
<column-width>100%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>description</field-name>
<datatype>string</datatype>
<format/>
<label>Description</label>
<sort-field/>
<filter>false</filter>
<column-width/>
<link/>
<hide-field>true</hide-field>
</column>
</column-list>
</template>
<template>
<ds-name>DEVIM</ds-name>
<template-name>VT Full Unclosed DEVI Issues</template-name>
<template-sql>SELECT distinct admin_software_issue.new_num AS DEVI, admin_software_issue.headline AS Title, cast(admin_software_issue.description as varchar(7000)) as description, admin_software_issue.priority, admin_software_issue.iteration_affected AS Iteration, admin_software_issue.submit_date AS submitted, admin_software_issue.product, admin_software_issue.package_ref AS Package, admin_software_issue.issue_type AS Type, admin_users.login_name AS Owner, admin_statedef.name AS State, admin_software_issue.estimated_time_inhours as Estimate FROM ((admin.software_issue as admin_software_issue  with (nolock) INNER JOIN admin.users as admin_users with (nolock) ON admin_software_issue.owner = admin_users.dbid) INNER JOIN admin.statedef as admin_statedef with (nolock) ON admin_software_issue.state = admin_statedef.id) INNER JOIN admin.history as admin_history with (nolock) ON (admin_statedef.name = admin_history.new_state) AND (admin_software_issue.dbid = admin_history.entity_dbid)  WHERE (((admin_statedef.name) &lt;&gt; 'Closed') AND ((admin_software_issue.project)='Vas Traffik 2/3')) ORDER BY admin_software_issue.new_num DESC</template-sql>
<style-sheet>devi.css</style-sheet>
<highlight-list>
<highlight>
<style-class>openStateNotAssignedStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Open</field-value>
<field-operation>equal</field-operation>
</styleItem>
<styleItem>
<field-name>owner</field-name>
<field-value>apichan</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
<highlight>
<style-class>openStateAssignedStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Open</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
<highlight>
<style-class>implementedStateStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Implemented</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
<highlight>
<style-class>closedStateStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Closed</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
<highlight>
<style-class>reqclosedStateStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Request_Close</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
</highlight-list>
<column-list>
<column>
<field-name>devi</field-name>
<datatype>string</datatype>
<format/>
<label>Issue ID</label>
<sort-field>true</sort-field>
<filter>false</filter>
<column-width>10%</column-width>
<link>http://erg:8002/ManagerSuite/Release_Manager/_wform_issues_notes.asp?iss_db_name=DEVI&amp;iss_id_num={devi}</link>
<hide-field>false</hide-field>
</column>
<column>
<field-name>product</field-name>
<datatype>string</datatype>
<format/>
<label>Product</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>title</field-name>
<datatype>string</datatype>
<format/>
<label>Title</label>
<sort-field>true</sort-field>
<filter>false</filter>
<column-width>30%</column-width>
<hide-field>false</hide-field>
<link/>
</column>
<column>
<field-name>state</field-name>
<datatype>string</datatype>
<format/>
<label>State</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>priority</field-name>
<datatype>string</datatype>
<format/>
<label>Priority</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>owner</field-name>
<datatype>string</datatype>
<format/>
<label>Owner</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>iteration</field-name>
<datatype>string</datatype>
<format/>
<label>Iteration</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>estimate</field-name>
<datatype>int</datatype>
<format/>
<label>Est</label>
<sort-field>true</sort-field>
<filter>false</filter>
<column-width>100%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>description</field-name>
<datatype>string</datatype>
<format/>
<label>Description</label>
<sort-field/>
<filter>false</filter>
<column-width/>
<link/>
<hide-field>true</hide-field>
</column>
</column-list>
</template>
<template>
<ds-name>DEVIM</ds-name>
<template-name>VT PDT and SAT Issues</template-name>
<template-sql>SELECT DISTINCT admin_software_issue.new_num AS DEVI, admin_software_issue.headline AS Title, cast(admin_software_issue.description as varchar(7000)) as description, admin_software_issue.priority, admin_software_issue.iteration_affected AS Iteration, admin_software_issue.submit_date AS submitted, admin_software_issue.product, admin_software_issue.package_ref AS Package, admin_software_issue.issue_type AS Type, admin_users.login_name AS Owner, admin_statedef.name AS State, admin_software_issue.estimated_time_inhours as Estimate FROM ((admin.software_issue as admin_software_issue  with (nolock) INNER JOIN admin.users as admin_users with (nolock) ON admin_software_issue.owner = admin_users.dbid) INNER JOIN admin.statedef as admin_statedef with (nolock) ON admin_software_issue.state = admin_statedef.id) INNER JOIN admin.history as admin_history with (nolock) ON (admin_statedef.name = admin_history.new_state) AND (admin_software_issue.dbid = admin_history.entity_dbid) WHERE (((admin_software_issue.iteration_affected) like 'PDT2%' or (admin_software_issue.iteration_affected) like 'SAT2%') AND ((admin_software_issue.project)='Vas Traffik 2/3')) ORDER BY admin_software_issue.new_num DESC</template-sql>
<style-sheet>pdt.css</style-sheet>
<highlight-list>
<highlight>
<style-class>openStateNotAssignedStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Open</field-value>
<field-operation>equal</field-operation>
</styleItem>
<styleItem>
<field-name>owner</field-name>
<field-value>apichan</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
<highlight>
<style-class>openStateAssignedStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Open</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
<highlight>
<style-class>implementedStateStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Implemented</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
<highlight>
<style-class>closedStateStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Closed</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
<highlight>
<style-class>reqclosedStateStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Request_Close</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
</highlight-list>
<column-list>
<column>
<field-name>devi</field-name>
<datatype>string</datatype>
<format/>
<label>Issue ID</label>
<sort-field>true</sort-field>
<filter>false</filter>
<column-width>10%</column-width>
<link>http://erg:8002/ManagerSuite/Release_Manager/_wform_issues_notes.asp?iss_db_name=DEVI&amp;iss_id_num={devi}</link>
<hide-field>false</hide-field>
</column>
<column>
<field-name>product</field-name>
<datatype>string</datatype>
<format/>
<label>Product</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>title</field-name>
<datatype>string</datatype>
<format/>
<label>Title</label>
<sort-field>true</sort-field>
<filter>false</filter>
<column-width>30%</column-width>
<hide-field>false</hide-field>
<link/>
</column>
<column>
<field-name>state</field-name>
<datatype>string</datatype>
<format/>
<label>State</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>priority</field-name>
<datatype>string</datatype>
<format/>
<label>Priority</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>owner</field-name>
<datatype>string</datatype>
<format/>
<label>Owner</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>iteration</field-name>
<datatype>string</datatype>
<format/>
<label>Iteration</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>estimate</field-name>
<datatype>int</datatype>
<format/>
<label>Est</label>
<sort-field>true</sort-field>
<filter>false</filter>
<column-width>100%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>description</field-name>
<datatype>string</datatype>
<format/>
<label>Description</label>
<sort-field/>
<filter>false</filter>
<column-width/>
<link/>
<hide-field>true</hide-field>
</column>
</column-list>
</template>
<template>
<ds-name>DEVIM</ds-name>
<template-name>VT NPS2005 Issues</template-name>
<template-sql>SELECT DISTINCT admin_software_issue.new_num AS DEVI, admin_software_issue.headline AS Title, cast(admin_software_issue.description as varchar(7000)) as description, admin_software_issue.priority, admin_software_issue.iteration_affected AS Iteration, admin_software_issue.submit_date AS submitted, admin_software_issue.product, admin_software_issue.package_ref AS Package, admin_software_issue.issue_type AS Type, admin_users.login_name AS Owner, admin_statedef.name AS State, admin_software_issue.estimated_time_inhours as Estimate FROM ((admin.software_issue as admin_software_issue  with (nolock) INNER JOIN admin.users as admin_users with (nolock) ON admin_software_issue.owner = admin_users.dbid) INNER JOIN admin.statedef as admin_statedef with (nolock) ON admin_software_issue.state = admin_statedef.id) INNER JOIN admin.history as admin_history with (nolock) ON (admin_statedef.name = admin_history.new_state) AND (admin_software_issue.dbid = admin_history.entity_dbid) WHERE (((admin_software_issue.iteration_affected) like 'NPS2005%') AND ((admin_software_issue.project)='Vas Traffik 2/3')) ORDER BY admin_software_issue.new_num DESC</template-sql>
<style-sheet>pdt.css</style-sheet>
<highlight-list>
<highlight>
<style-class>openStateNotAssignedStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Open</field-value>
<field-operation>equal</field-operation>
</styleItem>
<styleItem>
<field-name>owner</field-name>
<field-value>apichan</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
<highlight>
<style-class>openStateAssignedStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Open</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
<highlight>
<style-class>implementedStateStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Implemented</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
<highlight>
<style-class>closedStateStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Closed</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
<highlight>
<style-class>reqclosedStateStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Request_Close</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
</highlight-list>
<column-list>
<column>
<field-name>devi</field-name>
<datatype>string</datatype>
<format/>
<label>Issue ID</label>
<sort-field>true</sort-field>
<filter>false</filter>
<column-width>10%</column-width>
<link>http://erg:8002/ManagerSuite/Release_Manager/_wform_issues_notes.asp?iss_db_name=DEVI&amp;iss_id_num={devi}</link>
<hide-field>false</hide-field>
</column>
<column>
<field-name>product</field-name>
<datatype>string</datatype>
<format/>
<label>Product</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>title</field-name>
<datatype>string</datatype>
<format/>
<label>Title</label>
<sort-field>true</sort-field>
<filter>false</filter>
<column-width>30%</column-width>
<hide-field>false</hide-field>
<link/>
</column>
<column>
<field-name>state</field-name>
<datatype>string</datatype>
<format/>
<label>State</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>priority</field-name>
<datatype>string</datatype>
<format/>
<label>Priority</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>owner</field-name>
<datatype>string</datatype>
<format/>
<label>Owner</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>iteration</field-name>
<datatype>string</datatype>
<format/>
<label>Iteration</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>estimate</field-name>
<datatype>int</datatype>
<format/>
<label>Est</label>
<sort-field>true</sort-field>
<filter>false</filter>
<column-width>100%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>description</field-name>
<datatype>string</datatype>
<format/>
<label>Description</label>
<sort-field/>
<filter>false</filter>
<column-width/>
<link/>
<hide-field>true</hide-field>
</column>
</column-list>
</template>
<template>
<ds-name>DEVIM</ds-name>
<template-name>PDT2 Issues</template-name>
<template-sql>SELECT distinct admin_software_issue.new_num AS DEVI, upper(left(admin_software_issue.headline,20)) as sort_title, admin_software_issue.headline AS Title, cast(admin_software_issue.description as varchar(7000)) as description, admin_software_issue.priority, admin_software_issue.iteration_affected AS Iteration, admin_software_issue.submit_date AS submitted, admin_software_issue.product, admin_software_issue.package_ref AS Package, admin_software_issue.issue_type AS Type, admin_users.login_name AS Owner, admin_statedef.name AS State, admin_software_issue.estimated_time_inhours as Estimate FROM ((admin.software_issue as admin_software_issue  with (nolock)   INNER JOIN admin.users as admin_users with (nolock) ON admin_software_issue.owner = admin_users.dbid) INNER JOIN admin.statedef as admin_statedef with (nolock) ON admin_software_issue.state = admin_statedef.id) WHERE upper(left(admin_software_issue.headline,20)) like 'PDT2 %' AND ((admin_software_issue.project)='Vas Traffik 2/3') ORDER BY upper(left(admin_software_issue.headline,20)), admin_software_issue.new_num DESC</template-sql>
<style-sheet>devi.css</style-sheet>
<highlight-list>
<highlight>
<style-class>openStateNotAssignedStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Open</field-value>
<field-operation>equal</field-operation>
</styleItem>
<styleItem>
<field-name>owner</field-name>
<field-value>apichan</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
<highlight>
<style-class>openStateAssignedStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Open</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
<highlight>
<style-class>implementedStateStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Implemented</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
<highlight>
<style-class>closedStateStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Closed</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
<highlight>
<style-class>reqclosedStateStyle</style-class>
<styleItem-list>
<styleItem>
<field-name>state</field-name>
<field-value>Request_Close</field-value>
<field-operation>equal</field-operation>
</styleItem>
</styleItem-list>
</highlight>
</highlight-list>
<column-list>
<column>
<field-name>devi</field-name>
<datatype>string</datatype>
<format/>
<label>Issue ID</label>
<sort-field>true</sort-field>
<filter>false</filter>
<column-width>10%</column-width>
<link>http://erg:8002/ManagerSuite/Release_Manager/_wform_issues_notes.asp?iss_db_name=DEVI&amp;iss_id_num={devi}</link>
<hide-field>false</hide-field>
</column>
<column>
<field-name>product</field-name>
<datatype>string</datatype>
<format/>
<label>Product</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>title</field-name>
<datatype>string</datatype>
<format/>
<label>Title</label>
<sort-field>true</sort-field>
<filter>false</filter>
<column-width>30%</column-width>
<hide-field>false</hide-field>
<link/>
</column>
<column>
<field-name>state</field-name>
<datatype>string</datatype>
<format/>
<label>State</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>priority</field-name>
<datatype>string</datatype>
<format/>
<label>Priority</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>owner</field-name>
<datatype>string</datatype>
<format/>
<label>Owner</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>iteration</field-name>
<datatype>string</datatype>
<format/>
<label>Iteration</label>
<sort-field>true</sort-field>
<filter>true</filter>
<column-width>10%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>estimate</field-name>
<datatype>int</datatype>
<format/>
<label>Est</label>
<sort-field>true</sort-field>
<filter>false</filter>
<column-width>100%</column-width>
<link/>
<hide-field>false</hide-field>
</column>
<column>
<field-name>description</field-name>
<datatype>string</datatype>
<format/>
<label>Description</label>
<sort-field/>
<filter>false</filter>
<column-width/>
<link/>
<hide-field>true</hide-field>
</column>
</column-list>
</template>

</template-list>
</project>
</project-list>