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

[Prasad]

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> 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
>
>
>
>
>
>
>
> *发件人:* 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
> *主题:* 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> 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
>
>
>
>
> _______________________________________________
> 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/20081022/6a130224/attachment-0003.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 37655 bytes
Desc: not available
Url : http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20081022/6a130224/attachment-0005.png