<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Mistral;
panose-1:3 9 7 2 3 4 7 2 4 3;}
@font-face
{font-family:"Century Gothic";
panose-1:2 11 5 2 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:1072433242;
mso-list-type:hybrid;
mso-list-template-ids:1868094984 -3269038 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l0:level1
{mso-level-start-at:2;
mso-level-number-format:bullet;
mso-level-text:-;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:54.0pt;
text-indent:-18.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-font-family:Calibri;
mso-bidi-font-family:"Times New Roman";}
@list l1
{mso-list-id:1287158038;
mso-list-type:hybrid;
mso-list-template-ids:-2028069872 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l1:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l2
{mso-list-id:1719236272;
mso-list-type:hybrid;
mso-list-template-ids:-1414604116 -1034406168 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l2:level1
{mso-level-start-at:1029;
mso-level-number-format:bullet;
mso-level-text:-;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-font-family:Calibri;
mso-bidi-font-family:"Times New Roman";}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal>Hi All,<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I am having a bit of trouble creating & using queries
within our RTFM in order to monitor response times to tickets. <o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoListParagraph style='text-indent:-18.0pt;mso-list:l1 level1 lfo2'><![if !supportLists]><span
style='mso-list:Ignore'>1.<span style='font:7.0pt "Times New Roman"'>
</span></span><![endif]>I need to create the following queries & am not
sure how to? <o:p></o:p></p>
<p class=MsoListParagraph style='margin-left:54.0pt;text-indent:-18.0pt;
mso-list:l0 level1 lfo3'><![if !supportLists]><span style='mso-list:Ignore'>-<span
style='font:7.0pt "Times New Roman"'>
</span></span><![endif]>The time between a call initially coming in and being
assigned to a specific staff member<o:p></o:p></p>
<p class=MsoListParagraph style='margin-left:54.0pt;text-indent:-18.0pt;
mso-list:l0 level1 lfo3'><![if !supportLists]><span style='mso-list:Ignore'>-<span
style='font:7.0pt "Times New Roman"'>
</span></span><![endif]>The time between call coming in and being responded to
(via a comment/email reply the staff member adds). It’s important for our
job that clients get a personal response within 8 hours.<o:p></o:p></p>
<p class=MsoListParagraph style='text-indent:-18.0pt;mso-list:l1 level1 lfo2'><![if !supportLists]><span
style='mso-list:Ignore'>2.<span style='font:7.0pt "Times New Roman"'>
</span></span><![endif]>I would like a report to be created & emailed to me
each day outlining tickets that have been worked on or closed. Is this possible?<o:p></o:p></p>
<p class=MsoListParagraph style='text-indent:-18.0pt;mso-list:l1 level1 lfo2'><![if !supportLists]><span
style='mso-list:Ignore'>3.<span style='font:7.0pt "Times New Roman"'>
</span></span><![endif]>When I create other bespoke queries, even when I change
the fields I wish to view to custom fields we have created, when I export the
query to a csv file, the only fields I can view are the ‘default’
fields which are set within the RTFM. Why is this and how can I change it? <o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Any advice that you can give would be gratefully appreciated!
If you need further information on our exact setup, please feel free to email
me off list.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Janine<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal align=center style='text-align:center'><u><span lang=EN-GB
style='font-size:10.0pt;font-family:"Century Gothic","sans-serif"'> </span></u><span
lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";color:green'>
</span><span lang=EN-GB style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
<p class=MsoNormal align=center style='text-align:center'><span lang=EN-GB
style='font-size:10.0pt;font-family:"Arial","sans-serif";color:green'>Janine
Woodward, Head of IT, The </span><span lang=EN-GB style='font-size:13.5pt;
font-family:Mistral;color:green'>Ethical</span><span lang=EN-GB
style='font-size:10.0pt;font-family:"Arial","sans-serif";color:green'> PROPERTY
Company</span><span lang=EN-GB style='font-size:12.0pt;font-family:"Arial","sans-serif";
color:#C00000'><br>
</span><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:maroon'> Registered Office 2nd Floor - 9 Park End St - Oxford
- OX1 1HH - UK </span><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#C00000'>Registered No: 02961327</span><span lang=EN-GB style='font-size:
10.0pt;font-family:"Arial","sans-serif";color:maroon'><o:p></o:p></span></p>
<p class=MsoNormal align=center style='text-align:center'><span lang=EN-GB
style='font-size:10.0pt;font-family:"Arial","sans-serif";color:maroon'>Tel:
01865 207813 - Fax: 01856 201301</span><span lang=EN-GB style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
<p class=MsoNormal align=center style='text-align:center'><span lang=EN-GB
style='font-size:10.0pt;font-family:"Arial","sans-serif";color:maroon'><a
href="http://www.ethicalproperty.co.uk"><span style='color:blue'>www.ethicalproperty.co.uk</span></a>
</span><span lang=EN-GB style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</body>
</html>