Example: Add a column to a view
You can insert a SELECT clause to the RT_MD_VIEWDICTIONARY table to add an additional column. To add the column TEST_COL, which gets data from the RT_ACTIVATED_FORMS table, to the RD_MEDHIST view:
insert into RT_MD_VIEWDICTIONARY
(VIEWNAME, COLUMNNAME, VIEWTYPE,LANGUAGEID, CLAUSE,
COLUMNTYPE,SECTIONORDER, ITEMORDER,CHILDITEMORDER,
COLUMNORDER,EXPRESSION)
values ('RD_MEDHIST',
'TEST_COL', -- a unique column name
'RD', -- has to be RD view type
2,
'SELECT', -- has to be a SELECT clause
3, -- string type
999,
25, -- increase the max count by 1
25, -- increase the max count by 1
160, -- increase the max count by 1
'AF.REASON' -- get the REASON column from the base table
);
commit;