Forum Stats

  • 3,759,521 Users
  • 2,251,560 Discussions
  • 7,870,690 Comments

Discussions

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

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

Best Answers

  • Philip Stoyanov-Oracle
    Philip Stoyanov-Oracle Member Posts: 3,348 Employee
    Accepted 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

  • Philip Stoyanov-Oracle
    Philip Stoyanov-Oracle Member Posts: 3,348 Employee
    Accepted Answer

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


Answers

  • Philip Stoyanov-Oracle
    Philip Stoyanov-Oracle Member Posts: 3,348 Employee
    Accepted 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

  • 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).

    Regards

    Rohit Puranik

  • Philip Stoyanov-Oracle
    Philip Stoyanov-Oracle Member Posts: 3,348 Employee
    Accepted Answer

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


  • 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

  • User_DEH6N
    User_DEH6N Member Posts: 5 Green Ribbon

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