Hello Everyone,
There is an issue in Write Records Smart Service
Its not giving as output with/of primary keys in the Output section
It works for a record which takes single value as input but not working for array pv!
Please ping if anyone has faced this issue before, We,ve tried everything but nothing is working
Thanks in advance.
Discussion posts and replies are publicly visible
I support Juraj Buc in when the documentation says "omit OR set to NULL", that setting it to NULL will work as expected.
Thanks for the heads-up, Peter Lewis, but this looks like a different issue.
1. it occurred on MariaDB (Appian Cloud Database)
2. Write Records node is actually successfully executed and it writes new row into the database, it just doesn't return new generated PK in the Outputs
This was a bug actually and it was corrected in 24.2. Meanwhile you can avoid the issue by leaving the PK field off your variable instead of including it with a NULL value. Write Records will still create the PK of course and include it in the output. Sorry for any inconvenience caused by the issue!
Perfect, good to know that the issue was already addressed. I will check our upgrade schedule.
Thanks for the update, Laura.
Mystery solved! Thanks to everybody who joined the discussion.
I'm facing some kind of similar issue on 24.2 version of Appian cloud. I'm trying to generate a unique code for submitted application with primary key and a string literal using concat function. I'm first writing the application data using Write record and save the output in the pv. Then, I've another Write record node after it where I'm using update function to just update the same pv's data with concatenated string and then writing that data. But, I'm not able to fetch the primary key. It just appends "-id" rather than the actual primary key which was already generated in previous Write record. Any help appreciated.
Configuration for Write Scholarship Details
Configuration for Update Scholarship Code
Process History
Here is the mistake.
Please use concat("SCH-",pv!scholarship[your field index])
you need to mention the data holder from which you want to index the value.
Sure. In your "Update Scholarship Code" you only reference the record field, but do not fetch the values for that field from the PV.
https://docs.appian.com/suite/help/24.3/reference-records.html#reference-record-fields
Oops! that minor mistake. Thanks Stefan Helzle .