<div dir="ltr">Hi Christian Castelli,<br><br>There are multiple queries involved for each module to delete an item from the database as the information for each item is spread across multiple tables. Simple thing would be to delete only from vtiger_crmentity table. But this will not be clean.<br>
<br><div class="gmail_quote">On Wed, Aug 27, 2008 at 2:48 PM, Christian Castelli <span dir="ltr"><<a href="mailto:christian.castelli@trackset.com">christian.castelli@trackset.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi there,<br>
I'm new to vTiger and I've discovered that when I delete an item from<br>
the system (via browser), vTiger set to 1 the field vtiger_crmentity in<br>
the database.<br>
I can see all deleted items by a simpel query (and if I'm not wrong, in<br>
future releases it will be possibile to restore these items by the GUI,<br>
won't it?).<br>
My question is: how can I really delete those items in MySQL (in order<br>
to make it cleaner) that I've deleted from vTiger? What queries are<br>
involved?<br>
Thanks.<br>
--<br>
Christian Castelli<br>
Software Developer<br>
<a href="mailto:christian.castelli@trackset.com">christian.castelli@trackset.com</a><br>
<br>
<br>
Italian Office<br>
Via Sant'Ilario Sud,109<br>
56021 Cascina (PI) - Italia<br>
TEL +39 050 70 03 79<br>
FAX +39 050 80 70 136<br>
<a href="http://www.trackset.com" target="_blank">www.trackset.com</a> <<a href="http://www.trackset.com" target="_blank">http://www.trackset.com</a>><br>
<br>
Questo messaggio è destinato alle sole persone indicate e può contenere<br>
informazioni riservate.<br>
Se ricevuto per errore, si prega di avvisare immediatamente il mittente<br>
e cancellare l'originale. Ogni altro uso del messaggio è vietato.<br>
_______________________________________________<br>
Reach hundreds of potential candidates - <a href="http://jobs.vtiger.com" target="_blank">http://jobs.vtiger.com</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>Regards,<br>Asha<br>vtiger Team<br>
</div>