hello all,
I am trying t write to a table using write records smart service.
The data is being written in DB table but I do not have the records updated captured in my output variables of node.
I am doing a single entry at a time and record has no relationship defined.
One thing to note here that we have configured triggers on this table which updates some columns for the same table.
We are using Postgres DB.
has anyone else experienced the same situation.
Node Configurations:
Discussion posts and replies are publicly visible
With 23.3 "Records Updated" only returns the primary keys. To get the full record, you need a separate query.
I covered that in my blog post: appian.rocks/.../
Hi Stefan,
We are not getting primary key back after writing after to DB, we are facing this in 23.2 and 23.3 release also.
Then we need more details. This is pretty low level, so please be generous.
Here records updated are null, PV records updated is the output variable and pv!cmsworkflow is the input variable which we are populating.
There are no source and default filters in record, trigger is present on table.
Database entry is happening but in O/P variables it is not reflecting.
Attaching the table values for that transaction.
I would try to reduce the number of variables in that game and remove that trigger for a test.