Hello,
I have created one CDT and it's first column is auto generated primary key and the same CDT is used to store the column values of the editable grid.
I have used the below code:
Here "Slot Id" is primary key of CDT stored in the newGridRow local variable. I don't want to display this primary key column as editable grid column but want to store the value of this primary key along with the remaining editable grid columns in the database table.
I have Write to Datastore Entity smart service. It is adding the new row to the database table with auto incremented primary key but not adding the values of other columns of editable grid in the table.
Please help me.
Discussion posts and replies are publicly visible
Could you also share a screenshot of your process model configuration as well as the configuration of your WTDS node? Have you checked a running process instance to ensure that the data you intend to write is complete within the CDT PV? There are a lot of things you haven't included here so it's hard to guess where the shortcoming might be.
Please find the below snippet:
Here Slot ID is primary key and I want to store values of all 4 fields of monitoringDetails in the database table 'Monitoring Roster' but while I am executing this PM, only autogenerated primary key is storing in the database.
In your screenshot of the data held in your various PVs, the data in monitoringData and monitoringDetails are both blank. I'm not clear which of those you're trying to use in your WTDS node since you didn't show the configuration of the parent... but if you want data to populate in the database, you'll need to make sure the data is actually populated into the CDT you're passing into the WTDS...
Thank you Mike. It is working now.