Hi,
I have below Record Type(s) structure.
Now when I try to load the column(s) data in the summary page from the RecordType "D", it is not loading. But, when I ran the "Data Sync" for the recordType "D" manually then I was able to see the data in the
summary page.
FYI: RecordType "B" is having a foreignkey relation ship with column data which is there in the RecordType "B".
Any tips please. Thanks in advanse.
Discussion posts and replies are publicly visible
You say "But, when I ran the "Data Sync" for the recordType "D" manually then I was able to see the data".
Does this mean you had no data before, then loaded data to DB and did not see that data in the record?
Can you please explain, in a timeline, what you are doing?
When the user entered the data using user Input screen/page, it got saved into the database.
Afterwords, user is try to see the data in the Summary page, but it is not reflected there. When I ran the "Data Sync" manually for the RecordType "D" then only it is stated showing up.
Again when the user submitted a new data, and if they go to Summary page, newly entered data is not reflecting.
Please let me know if you need any additional details. Thanks.
Sync status was showing green whenever I manually ran.
Also, I have updated my process model with "Enable Activity Chaining". But, still no luck.
If the issue is only happening with record type D, what happens if you simplify your process and just have a Write to Data Store Entity node that only updates record type D? Do you then see your record type updated? That can help us identify if this is an issue with the record type or with the configuration of your process model.
I don't have issues with any of the RecordTypes and the only variation with RecordType "D" compare to other RecordTypes is, the Entity which is storing the data to "B" itself is storing the data to "D". Because, One of the column in "B" is having a Foreign Key relation and an Array to "D".
Can you explain what you mean with "Entity which is storing the data to "B" itself is storing the data to "D". Because, One of the column in "B" is having a Foreign Key relation and an Array to "D"."
Peter Lewis Quick question: The update trigger to a record when writing to DB is based on the table name as defined in the XSD?
Hi Stefan,
Please find the below attached details. Let me know if you need more details for more clarity.
Thanks
I try to sum it up.
You created a CDT B with a nested CDT D. Now you directly write to the table D.
Correct?
Do you need that nesting? I think the idea is to create the CDTs separately and then define the relationships in the records.
Peter Lewis What do you think?
Please find the correct message:
Created a CDT B with a nested CDT D. I am directly writing to B.
So, you write an item to B that includes data stored to D. Now it seems like the record for D is not automatically synced.
I suggest to create a small test case to investigate this matter. If you can reproduce it, open a support case.
Stefan,
More detail can be found in the below link which I am talking about. Thanks.
Appian Community
I would expect that when you write data using nested CDTs (i.e. write to CDT B that contains CDT D) that all data would be written to both tables AND record types that refer to both tables would be synced. To Stefan's question - the update occurs when the table name matches in both the XSD of the CDT and the source of the record type.
The one question I still have - what if you write only to table D (and don't use a nested CDT)? Depending on the answer there, that can help us identify if the issue is that either table D just isn't triggering a sync for any operation or that it is only failing to sync when using a nested CDT.