Extend schema property on department

Question

I have a problem with the extension of a schema "department". When I'm trying to extend and choose a new column I only get this option:

Column Name CCC_ "blank"
Base Column "Drop down, which is empty"

And this is it. So from here I cant choose or create a new column in department in the database. Is there something wrong with this item from the database? All other tables works fine doing this.

Markus Weiss-Ehlers · Accepted Answer

Department is a view based on the table Basetree. As mentioned here "https://support.oneidentity.com/de-de/technical-documents/identity-manager/9.1.1/configuration-guide/98#TOPIC-1990658" you may need to expand the basetable first. 
 Creating new columns for database views with type view 
 
 If the table to be expanded is a database view with the View table type, the selection of new columns is restricted to custom columns of the underlying base table. You can only select custom columns from the base table that are not yet used in the view.

First extend the base table by a new column (simple column or foreign key column).

Then you extend the database view with the new columns.

Extend schema property on department

Top Replies

Creating new columns for database views with type view