[Vtigercrm-developers] Attaching troubletickets to an account - sql

[Richard Hills - TechnologyWise]

Thanks vikas,

I didn't think it would be so easy as using the parent_id column as in 
our database we seem to have a row for each helpdesk item in 
vtiger_crmentity_rel which looks like the following:

IDOFTICKET, HelpDesk, IDOFTICKET, HelpDesk

Which is also what I was referring to with the related to themselves 
statement, it may be that someone who worked on this CRM prior to me 
coming along had done something funny here, is this not a normal entry 
in the database for each ticket?

On 17/09/11 01:31, Vikas Jain wrote:
> Richard,
>
>     Also, can anyone tell me why helpdesk items are connected to
>     themselves
>     in the aforementioned table and more importantly, if I must also
>     do this
>     with my new tickets?
>
> Im not sure about this, why do you say that tickets are related to 
> themselves?
>
>      how the connection is made between a ticket and an account
>
> As far as the relation is concerned, its stored in the 
> vtiger_troubletickets parent_id column.
>
> On 16 September 2011 07:59, Richard Hills - TechnologyWise 
> <richard at tw.co.nz <mailto:richard at tw.co.nz>> wrote:
>
>     I am wanting to create tickets using a custom script which will import
>     data out of a similar item.
>
>     Currently I am confused as to how the connection is made between a
>     ticket and an account, I have looked in the table vtiger_crmentityrel
>     and noticed that helpdesk items are always related only to
>     themselves here.
>
>     Can anyone give me the right location to make this coupling?
>
>     Also, can anyone tell me why helpdesk items are connected to
>     themselves
>     in the aforementioned table and more importantly, if I must also
>     do this
>     with my new tickets?
>
>     Thank you.
>
>     --
>     Richard Hills
>     TechnologyWise Ltd, Tauranga, NZ
>     richard at tw.co.nz <mailto:richard at tw.co.nz>
>     www.technologywise.co.nz <http://www.technologywise.co.nz>
>     ph: +64 (0)7 571 1060
>     fax: +64 (0)7 571 1061
>
>     _______________________________________________
>     http://www.vtiger.com/
>
>
>
>
> -- 
> Regards
> Vikas
> Vtiger Team
>
>
> _______________________________________________
> http://www.vtiger.com/


-- 
Richard Hills
TechnologyWise Ltd, Tauranga, NZ
richard at tw.co.nz
www.technologywise.co.nz
ph: +64 (0)7 571 1060
fax: +64 (0)7 571 1061

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20110919/1ac54abd/attachment-0002.html