<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=gb2312">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:宋体;
panose-1:2 1 6 0 3 1 1 1 1 1;}
@font-face
{font-family:宋体;
panose-1:2 1 6 0 3 1 1 1 1 1;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"\@宋体";
panose-1:2 1 6 0 3 1 1 1 1 1;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:宋体;}
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
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:宋体;}
span.gmailquote
{mso-style-name:gmail_quote;}
span.e
{mso-style-name:e;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</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=ZH-CN link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span lang=EN-US style='font-size:10.5pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Hi,<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.5pt;font-family:"Calibri","sans-serif";
color:#1F497D'> Thank you very
much for your point,it’t is very usefull to me,I will try to this way today .<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.5pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.5pt;font-family:"Calibri","sans-serif";
color:#1F497D'> Best regards!<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.5pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span style='font-size:10.0pt'>发件人<span lang=EN-US>:</span></span></b><span
lang=EN-US style='font-size:10.0pt'>
vtigercrm-developers-bounces@lists.vtigercrm.com
[mailto:vtigercrm-developers-bounces@lists.vtigercrm.com] </span><b><span
style='font-size:10.0pt'>代表 </span></b><span lang=EN-US style='font-size:10.0pt'>Prasad<br>
</span><b><span style='font-size:10.0pt'>发送时间<span lang=EN-US>:</span></span></b><span
lang=EN-US style='font-size:10.0pt'> 2008</span><span style='font-size:10.0pt'>年<span
lang=EN-US>10</span>月<span lang=EN-US>22</span>日<span lang=EN-US> 17:56<br>
</span><b>收件人<span lang=EN-US>:</span></b><span lang=EN-US> vtigercrm-developers@lists.vtigercrm.com<br>
</span><b>主题<span lang=EN-US>:</span></b><span lang=EN-US> Re: </span>答复<span
lang=EN-US>: [Vtigercrm-developers] one problem about trouble tickets<o:p></o:p></span></span></p>
</div>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><span lang=EN-US>Hi,<br>
<br>
To create similar to Status field you will need to add Picklist type custom
field.<br>
<br>
When a custom field 'SN' is added, it appears under Custom Information Block.
If you want to move it into Trouble Ticket Information block,<br>
you will have to update vtiger_field as described below.<br>
<br>
1. In table get the blockid of LBL_TICKET_INFORMATION<br>
SELECT blockid FROM vtiger_blocks WHERE blocklabel='LBL_TICKET_INFORMATION'<br>
<br>
2. Get the fieldid of the new custom field that was added with label 'SN'<br>
SELECT * FROM vtiger_field WHERE generatedtype=2 AND fieldlabel='Cost'<br>
<br>
Note: Save the result record given by previous record. It might be useful to
revert back.<br>
<br>
3. Now change the field and block association<br>
UPDATE vtiger_field set block=BLOCKID where fieldid=FIELDID<br>
<br>
Here BLOCKID is the value obtained from Step1 and fieldid is the value obtained
from Step2<br>
<br>
Regards,<br>
Prasad<br>
vtiger Team<o:p></o:p></span></p>
<div>
<p class=MsoNormal><span class=gmailquote><span lang=EN-US>On 10/22/08, <b>WenZhi
Yi(</b></span><b>易文志<span lang=EN-US>)</span></b><span lang=EN-US> <<a
href="mailto:wzhyi@hillstonenet.com">wzhyi@hillstonenet.com</a>> wrote:</span></span><span
lang=EN-US><o:p></o:p></span></p>
<div>
<div>
<p><span lang=EN-US style='font-size:10.5pt;color:#1F497D'>Hi ,Asha</span><span
lang=EN-US><o:p></o:p></span></p>
<p><span lang=EN-US style='font-size:10.5pt;color:#1F497D'>
Thank you for your help,my mean: I want to add a field named
"sn" , pls look follows picture, but not add in Custom
Fields ,I want my add '" sn" is look like
"status",how to do ? I know I will change code if that .but I hope
you help me.</span><span lang=EN-US><o:p></o:p></span></p>
<p><span lang=EN-US style='font-size:10.5pt;color:#1F497D'> </span><span
lang=EN-US><o:p></o:p></span></p>
<p><span lang=EN-US style='font-size:10.5pt;color:#1F497D'>Regards</span><span
lang=EN-US><o:p></o:p></span></p>
<p><span lang=EN-US style='font-size:10.5pt;color:#1F497D'> </span><span
lang=EN-US><o:p></o:p></span></p>
<p><span lang=EN-US style='font-size:10.5pt;color:#1F497D'><img border=0
width=1251 height=273 id="_x0000_i1025" src="cid:image001.png@01C934F7.DDC4D2C0"></span><span
lang=EN-US><o:p></o:p></span></p>
<p><span lang=EN-US style='font-size:10.5pt;color:#1F497D'> </span><span
lang=EN-US><o:p></o:p></span></p>
<p><span lang=EN-US style='font-size:10.5pt;color:#1F497D'> </span><span
lang=EN-US><o:p></o:p></span></p>
<div style='border:none;border-top:solid windowtext 1.0pt;padding:3.0pt 0cm 0cm 0cm;
border-color:-moz-use-text-color -moz-use-text-color'>
<p><b><span style='font-size:10.0pt'>发件人<span lang=EN-US>:</span></span></b><span
lang=EN-US style='font-size:10.0pt'> <a
href="mailto:vtigercrm-developers-bounces@lists.vtigercrm.com" target="_blank">vtigercrm-developers-bounces@lists.vtigercrm.com</a>
[mailto:<a href="mailto:vtigercrm-developers-bounces@lists.vtigercrm.com"
target="_blank">vtigercrm-developers-bounces@lists.vtigercrm.com</a>] </span><b><span
style='font-size:10.0pt'>代表 </span></b><span lang=EN-US style='font-size:10.0pt'>Asha<br>
</span><b><span style='font-size:10.0pt'>发送时间<span lang=EN-US>:</span></span></b><span
lang=EN-US style='font-size:10.0pt'> 2008</span><span style='font-size:10.0pt'>年<span
lang=EN-US>10</span>月<span lang=EN-US>22</span>日<span lang=EN-US> 15:31<br>
</span><b>收件人<span lang=EN-US>:</span></b><span lang=EN-US> <a
href="mailto:vtigercrm-developers@lists.vtigercrm.com" target="_blank">vtigercrm-developers@lists.vtigercrm.com</a><br>
</span><b>主题<span lang=EN-US>:</span></b><span lang=EN-US> Re:
[Vtigercrm-developers] one problem about trouble tickets</span></span><span
lang=EN-US><o:p></o:p></span></p>
</div>
<div>
<p><span lang=EN-US> <o:p></o:p></span></p>
<p style='margin-bottom:12.0pt'><span lang=EN-US>Hi Wenzh Yi,<br>
<br>
Most easiest thing is to add a custom field for module Trouble tickets through
Settings->Custom Fields<br>
<br>
Let me know if you are looking for something different.<o:p></o:p></span></p>
<div>
<p><span lang=EN-US>On 10/22/08, <b>WenZhi Yi(</b></span><b>易文志<span
lang=EN-US>)</span></b><span lang=EN-US> <<a
href="mailto:wzhyi@hillstonenet.com" target="_blank">wzhyi@hillstonenet.com</a>>
wrote:<o:p></o:p></span></p>
<div>
<div>
<p><span lang=EN-US>Hi,<o:p></o:p></span></p>
<p><span lang=EN-US> I wan't
know how to add a field in table name trouble tickets ,pls tell me .<o:p></o:p></span></p>
<p><span lang=EN-US> <o:p></o:p></span></p>
<p><span lang=EN-US> <o:p></o:p></span></p>
<p><span lang=EN-US>Thanks!<o:p></o:p></span></p>
<p><span lang=EN-US style='font-size:10.0pt'> </span><span lang=EN-US><o:p></o:p></span></p>
<p><span lang=EN-US style='font-size:10.0pt'>Wenzh Yi<br>
</span><span lang=EN-US style='font-size:13.0pt'>Hillstone Networks</span><span
lang=EN-US style='font-size:11.0pt'><br>
</span><span lang=EN-US style='font-size:10.0pt'>Tel: (010)82897229-8026<br>
<a href="http://www.hillstonenet.com" target="_blank">www.hillstonenet.com</a></span><span
lang=EN-US><o:p></o:p></span></p>
<p><span lang=EN-US> <o:p></o:p></span></p>
</div>
</div>
<p><span lang=EN-US><br>
_______________________________________________<br>
Reach hundreds of potential candidates - <a href="http://jobs.vtiger.com"
target="_blank">http://jobs.vtiger.com</a> <o:p></o:p></span></p>
</div>
<p><span lang=EN-US><br>
<br clear=all>
<br>
-- <br>
Regards,<br>
Asha<br>
vtiger Team <o:p></o:p></span></p>
</div>
</div>
</div>
<p class=MsoNormal><span lang=EN-US><br>
_______________________________________________<br>
Reach hundreds of potential candidates - <a href="http://jobs.vtiger.com"
target="_blank">http://jobs.vtiger.com</a> <o:p></o:p></span></p>
</div>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
</div>
</body>
</html>