答复: 答复: [Vtigercrm-developers] one problem about trouble tickets

[WenZhi Yi(易文志)]

Hi,
         Thank you very much for your point,it’t is very usefull to me,I will try to this way today .

         Best regards!

发件人: vtigercrm-developers-bounces at lists.vtigercrm.com [mailto:vtigercrm-developers-bounces at lists.vtigercrm.com] 代表 Prasad
发送时间: 2008年10月22日 17:56
收件人: vtigercrm-developers at lists.vtigercrm.com
主题: Re: 答复: [Vtigercrm-developers] one problem about trouble tickets

Hi,

To create similar to Status field you will need to add Picklist type custom field.

When a custom field 'SN' is added, it appears under Custom Information Block. If you want to move it into Trouble Ticket Information block,
you will have to update vtiger_field as described below.

1. In table get the blockid of LBL_TICKET_INFORMATION
SELECT blockid FROM vtiger_blocks WHERE blocklabel='LBL_TICKET_INFORMATION'

2. Get the fieldid of the new custom field that was added with label 'SN'
SELECT * FROM vtiger_field WHERE generatedtype=2 AND fieldlabel='Cost'

Note: Save the result record given by previous record. It might be useful to revert back.

3. Now change the field and block association
UPDATE vtiger_field set block=BLOCKID where fieldid=FIELDID

Here BLOCKID is the value obtained from Step1 and fieldid is the value obtained from Step2

Regards,
Prasad
vtiger Team
On 10/22/08, WenZhi Yi(易文志) <wzhyi at hillstonenet.com<mailto:wzhyi at hillstonenet.com>> wrote:

Hi ,Asha

         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.



Regards



[cid:image001.png at 01C934F7.DDC4D2C0]





发件人: vtigercrm-developers-bounces at lists.vtigercrm.com<mailto:vtigercrm-developers-bounces at lists.vtigercrm.com> [mailto:vtigercrm-developers-bounces at lists.vtigercrm.com<mailto:vtigercrm-developers-bounces at lists.vtigercrm.com>] 代表 Asha
发送时间: 2008年10月22日 15:31
收件人: vtigercrm-developers at lists.vtigercrm.com<mailto:vtigercrm-developers at lists.vtigercrm.com>
主题: Re: [Vtigercrm-developers] one problem about trouble tickets



Hi Wenzh Yi,

Most easiest thing is to add a custom field for module Trouble tickets through Settings->Custom Fields

Let me know if you are looking for something different.

On 10/22/08, WenZhi Yi(易文志) <wzhyi at hillstonenet.com<mailto:wzhyi at hillstonenet.com>> wrote:

Hi,

         I wan't know how to add a field in table name trouble tickets ,pls tell me .





Thanks!



Wenzh Yi
Hillstone Networks
Tel: (010)82897229-8026
www.hillstonenet.com<http://www.hillstonenet.com>



_______________________________________________
Reach hundreds of potential candidates - http://jobs.vtiger.com



--
Regards,
Asha
vtiger Team

_______________________________________________
Reach hundreds of potential candidates - http://jobs.vtiger.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20081023/3b9072e2/attachment-0003.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 37655 bytes
Desc: image001.png
Url : http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20081023/3b9072e2/attachment-0003.png