Copying dictionary attributes between tables???

David Casper
Tera Guru

I'm trying to apply some dictionary attributes to each task table/form. When I look at the sys_scheme_attribute_m2m and sys_schema_attribute tables list I don't see the 'on_table' field populated.

Is there a way to copy attributes across tables other than manually going into the specific field on each table and applying each attribute?

1 ACCEPTED SOLUTION

Xavier Cordero
Kilo Sage

Hello David,

For extended tables, the attributes if applied on the field would apply to the parent, as well as all the table extensions automatically (in other words, if you apply an attribute on a field within the task table it should automatically apply to all of the tables that are a child of task such as incident). This is because when you look at an extended table, the fields that it inherited from the parent are the actual fields from the parent, and not a copy of those fields. Having said that, if your tables are not all extensions of one parent table, I think you'd be left with creating these manually (unless you want to add them via script, which would not be best practice, but it's definitely doable).

View solution in original post

7 REPLIES 7

sethivarun
Kilo Guru

you can do it using 

find_real_file.png

this import function

this is on sys_schema_attribute_m2m table

I looked at that table, but I was not able to see a field showing which table the attribute was associated with which left me confused.

Xavier Cordero
Kilo Sage

Hello David,

For extended tables, the attributes if applied on the field would apply to the parent, as well as all the table extensions automatically (in other words, if you apply an attribute on a field within the task table it should automatically apply to all of the tables that are a child of task such as incident). This is because when you look at an extended table, the fields that it inherited from the parent are the actual fields from the parent, and not a copy of those fields. Having said that, if your tables are not all extensions of one parent table, I think you'd be left with creating these manually (unless you want to add them via script, which would not be best practice, but it's definitely doable).