BULK Update of native datatypes to defaultdomain.xml values

unficyp

Hi,

decided to start over with our existing design using Import -> Data Dictionary.

Works fine, but of course, all column datatypes changed back to logical (from domain).

is there a way to say:

"change all columns ending in _id to ID from the defaultdomains.xml file"

"change all columns containing email to EMAIL_SINGLE from the defaultdomains.xml file"

?

thanks in advance.

Philip Stoyanov-Oracle

Hi @unficyp ,

you need to get familiar with search functionality. Setting common properties is also there. And export to Excel file, change some properties and updating back the model - that also includes changing domains.

But you don't need to export to Excel for the problem you have.

1) use advanced search for "Column" and property "Name", use regular expression when needed.

2) in the result tab use properties button to get "Set common properties" dialog

3) find domain property and press the ellipsis button

4) select the domain and press Ok - I have domain ID - Number(10)

5) press Apply

6) don't forget to save

Philip

Philip Stoyanov-Oracle

Hi @unficyp ,

you need to get familiar with search functionality. Setting common properties is also there. And export to Excel file, change some properties and updating back the model - that also includes changing domains.

But you don't need to export to Excel for the problem you have.

1) use advanced search for "Column" and property "Name", use regular expression when needed.

2) in the result tab use properties button to get "Set common properties" dialog

3) find domain property and press the ellipsis button

4) select the domain and press Ok - I have domain ID - Number(10)

5) press Apply

6) don't forget to save

Philip

unficyp

Works, thanks