Hello there!
I’m trying to build a custom event that triggers after a new object is created and it updates a field value of this new object.
However, when the system trigger the event it doesnt update the new object field, it does on the previous object.
![](https://uploads-eu-west-1.insided.com/ifs-en/attachment/3b5cdd1e-4299-4bed-b3e0-ddc58402f402.png)
This event has the following action
![](https://uploads-eu-west-1.insided.com/ifs-en/attachment/9bc2125f-328e-4afe-bd00-7dab53eb1a24.png)
SQL:
UPDATE FISCAL_NOTE_TEMP_TAB
SET OBSERVATION2 = 'seu texto aqui teste sem função'
WHERE FISCAL_NOTE_ID = (
SELECT MAX(FISCAL_NOTE_ID)
FROM FISCAL_NOTE_TEMP_TAB
)
Any ideas of how to build/ fix this?