Menu

Workflow on new attachment

Kevin
2024-01-18
2024-01-19
  • Kevin

    Kevin - 2024-01-18

    Hello to all,

    I try to create a trigger when an attachment is created.
    I want to notify agents when an attachment is added to an incident.

    Attached, a screenshot of the trigger (object creation)
    But the trigger is never activated...

    Could you help me?

    Kind regards,

     
  • Jeffrey Bostoen

    Jeffrey Bostoen - 2024-01-18

    What about the triggered action?

     
  • Kevin

    Kevin - 2024-01-18

    Triggered action in attachment :)
    For tests I send email to the user that upload the attachment

     
  • Kevin

    Kevin - 2024-01-18

    OK, with the screenshot I see my error :(
    The WHERE configuration was not good, it has to be "U.id =" ! My bad :)

    Other question, from the item_id column, it is possible to get the ticket ref with placeholder ?

    Kind regards,

     
  • Kevin

    Kevin - 2024-01-19

    Hello there :)

    Waiting for this, I try to sent the notification to the agent in charge of the ticket, to I put this in the To OQL :

    SELECT Person AS P
    JOIN Ticket AS T ON T.agent_id = P.id
    WHERE T.id = :this->item_id
    

    In test it works but when I try in live, the item_id always equals '0' but in database I have the correct id. Is it a bug?

    Kind regards,

     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.