kpcollier Posted November 1, 2019 Report Share Posted November 1, 2019 Does anyone have a workaround for getting the value of a List DataType to insert into a new table via trigger? Quote Link to comment Share on other sites More sharing options...
0 Hastur Posted December 4, 2019 Report Share Posted December 4, 2019 @kpcollier Hello! As I know, there is no any workaround on this case. However, you can use additional table to create many to many relationship and use the values from this additional table as the set to be copied by trigger. Example: Each table from example contains 2 fields. You have some users: 1 - Andy 2- Mark You have some categories: a - cat_1 b - cat_2 c - cat_3 Connection table with id's from previous tables should look like: 1 -a 1- b 1- c 2 - a 2 - b 2 - c You can create the trigger to copy entire categories set and insert in in the connection table with id of newly inserted user. Quote Link to comment Share on other sites More sharing options...
Question
kpcollier
Does anyone have a workaround for getting the value of a List DataType to insert into a new table via trigger?
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.