Forum Stats

  • 3,780,926 Users
  • 2,254,456 Discussions
  • 7,879,496 Comments

Discussions

BULK Update of native datatypes to defaultdomain.xml values

unficyp
unficyp Member Posts: 185 Blue Ribbon

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.

unficyp

Best Answer

  • Philip Stoyanov-Oracle
    Philip Stoyanov-Oracle Member Posts: 3,367 Employee
    edited Jul 2, 2020 1:03AM Accepted Answer

    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.

    advanced_search_column_name.png

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

    3) find domain property and press the ellipsis button

    set_domain_as_common_property.png

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

    5) press Apply

    after_set_domain_on_columns.png

    6) don't forget to save

    Philip

    unficyp

Answers

  • Philip Stoyanov-Oracle
    Philip Stoyanov-Oracle Member Posts: 3,367 Employee
    edited Jul 2, 2020 1:03AM Accepted Answer

    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.

    advanced_search_column_name.png

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

    3) find domain property and press the ellipsis button

    set_domain_as_common_property.png

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

    5) press Apply

    after_set_domain_on_columns.png

    6) don't forget to save

    Philip

    unficyp
  • unficyp
    unficyp Member Posts: 185 Blue Ribbon
    edited Jul 5, 2020 7:36AM