[Vtigercrm-developers] anyone got a query for deleting comments?

[Rubén A. Estrada Orozco]

Hi Alan,

This is a query for deleting "orphan" comments (i.e. comments whose parent
record has been deleted):

            DELETE vtiger_modcomments, vtiger_modcommentscf
            FROM vtiger_modcomments
            LEFT JOIN vtiger_modcommentscf USING(modcommentsid)
            LEFT JOIN vtiger_crmentity ON related_to = crmid
            WHERE crmid IS NULL

I hope it helps

Saludos

Rubén


On Thu, Mar 23, 2023 at 7:47 AM Alan Lord <alanslists at gmail.com> wrote:

> Customer wants a few erroneous comments deleted. Not edited, but deleted.
>
> Can't use Server API or Record model - delete is not supported.
>
> Anyone else needed to do this before?
>
> TIA
>
> Al
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20230324/dabc7c90/attachment.html>