Scripting

Hi everyone,

I have been struggling with a custom rule to run only once per ticket.  The rule is meant to copy values from two fields on the parent ticket, and add this text to the title of the child ticket (separate queues).  I can get this to work correctly but each time the ticket is saved, the rule runs again and adds the text again.  I tried to set it so the rule checks for another custom field and only runs if the designated text is missing from it but I keep getting errors executing it.  

SELECT
PARENT.CUSTOM_FIELD_VALUE2,
PARENT.CUSTOM_FIELD_VALUE1,
HD_TICKET.TITLE,
HD_TICKET.ID
FROM
HD_TICKET PARENT, HD_TICKET
WHERE
PARENT.ID = HD_TICKET.PARENT_ID
AND HD_TICKET.CUSTOM_FIELD_VALUE5 not like '%Title set by rule%'

UPDATE
HD_TICKET PARENT,
HD_TICKET
SET
HD_TICKET.TITLE = CONCAT(HD_TICKET.TITLE,' - ',PARENT.CUSTOM_FIELD_VALUE1,' ',PARENT.CUSTOM_FIELD_VALUE2)
HD_TICKET.CUSTOM_FIELD_VALUE5 = 'Title set by rule'
WHERE
((PARENT.ID = HD_TICKET.PARENT_ID) AND HD_TICKET.ID = <TICKET_IDS>)

Custom 1 and 2 are First Name, Last Name and it works correctly without the dependency of Custom 5 which is an Owners Only field.  I would love to have the Custom 5 set as a checkbox but at this point anything that will work is great.

Thank you for taking the time to look at this.

Executing Select Query... 09/28/2021 08:23:43> selected 1 rows 09/28/2021 08:23:43> Executing Update Query... 09/28/2021 08:23:43> mysqli error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'HD_TICKET.CUSTOM_FIELD_VALUE5 = 'Title set by rule' WHERE ((PARENT.ID = HD_TICKE' at line 6] in EXECUTE("UPDATE HD_TICKET PARENT, HD_TICKET SET HD_TICKET.TITLE = CONCAT(HD_TICKET.TITLE,' - ',PARENT.CUSTOM_FIELD_VALUE1,' ',PARENT.CUSTOM_FIELD_VALUE2) HD_TICKET.CUSTOM_FIELD_VALUE5 = 'Title set by rule' WHERE ((PARENT.ID = HD_TICKET.PARENT_ID) AND HD_TICKET.ID = 1493)")