Forum Stats

  • 3,837,684 Users
  • 2,262,285 Discussions
  • 7,900,359 Comments

Discussions

Categories

What are the functions used for adding Column level and Table level UDP's

User_DEH6N
User_DEH6N Member Posts: 5 Green Ribbon
in SQL Developer Data Modeler Discussions

What are the functions used for adding Column level and Table level UDP's checked Index.html couldn't find anything.

· Share on TwitterShare on Facebook

Best Answers

  • Philip Stoyanov-Oracle
    Philip Stoyanov-Oracle Member Posts: 3,420 Employee
    Answer ✓

    There is support for dynamic properties - it's a pair <name,value> and you can use following methods on each object:

    void setProperty(String key, String value);

       String getProperty(String key);

       boolean hasProperty(String key);

       boolean hasProperty(String key, String value);

       void removeProperty(String key);

       void clearProperties();


    UDP has additional metadata - you need to define them at design level but at the core they are dynamic properties. Once defined UDP can be managed using methods above.

    Both UDP and dynamic properties can be used in reports, UDPs can appear on diagram.


    Philip

    · Share on TwitterShare on Facebook
  • Philip Stoyanov-Oracle
    Philip Stoyanov-Oracle Member Posts: 3,420 Employee
    Answer ✓

    For UDP you need to create them manually in UDP library in design properties dialog.

    udp_definitions.png


    · Share on TwitterShare on Facebook

Answers

  • Philip Stoyanov-Oracle
    Philip Stoyanov-Oracle Member Posts: 3,420 Employee
    Answer ✓

    There is support for dynamic properties - it's a pair <name,value> and you can use following methods on each object:

    void setProperty(String key, String value);

       String getProperty(String key);

       boolean hasProperty(String key);

       boolean hasProperty(String key, String value);

       void removeProperty(String key);

       void clearProperties();


    UDP has additional metadata - you need to define them at design level but at the core they are dynamic properties. Once defined UDP can be managed using methods above.

    Both UDP and dynamic properties can be used in reports, UDPs can appear on diagram.


    Philip

    · Share on TwitterShare on Facebook
  • User_DEH6N
    User_DEH6N Member Posts: 5 Green Ribbon

    Hi Philip,

    Thanks for response.

    Tried setProperty(String key, String value); function for table level and column level instead of User Defined Property(UDP) please refer the screen shots attached where in Dynamic property is getting set.

    Kindly help us with the function name to set User Defined Property(UDP).

    Also want to understand what is the difference between Dynamic property and User Defined Property(UDP).

    image.png

    Regards

    Rohit Puranik

    · Share on TwitterShare on Facebook
  • Philip Stoyanov-Oracle
    Philip Stoyanov-Oracle Member Posts: 3,420 Employee
    Answer ✓

    For UDP you need to create them manually in UDP library in design properties dialog.

    udp_definitions.png


    · Share on TwitterShare on Facebook
  • User_DEH6N
    User_DEH6N Member Posts: 5 Green Ribbon

    Thanks for your response Philip.

    We are having once requirement in which we want to achieve this using scripting rather then manually.

    Please suggest some function using that in our script we could create User defined propery automatically instead of manually.

    Regards

    Rohit

    · Share on TwitterShare on Facebook
  • User_DEH6N
    User_DEH6N Member Posts: 5 Green Ribbon

    Thanks a lot Philip that worked....!!

    · Share on TwitterShare on Facebook