User Defined Properties in SQL Developer Data Modeler

thatjeffsmith SQL Developer 4 Comments

Tell Others About This Story:

There are tons of properties you can set in your design objects.

In fact, I discovered a ‘new’ one this week thanks to my friend David.

Display as…what’s he talking about?

Oh, this.

Looks perfect for doing APEX design work, yes?

Looks perfect for doing APEX design work, yes?

But what if the set of values we give you for a table or column property aren’t enough? What if you want to document something else?

Enter the User Defined Properties. Note: this is new for version 4.1

Right-click on your design and open your design properties.

Click the + button to get started.

Click the + button to get started.

And now we can define our custom properties for our design.

Note I have 'Column' selected below.

Note I have ‘Column’ selected below.

I went with a custom list here. But I could have also went with simpler inputs for the property, namely:

  • text
  • numbers
  • dates

Hit save.

Open your table properties, go to the Columns page.

Ta-da!

Ta-da!

So that’s for columns. But I can set custom properties for tables as well.

Displaying Custom Table Properties in your Diagrams

Just enable it.

Note I set the display name to 'Why' for the 'DEMO' property.

Note I set the display name to ‘Why’ for the ‘DEMO’ property.

So I just showed you this for tables and columns, but you have a lot more flexibility than just that.

If you assign a color, the property text in the diagram will display in that color.

If you assign a color, the property text in the diagram will display in that color.

Search too!

So once you set these, you can search on them as well.

Advanced Search, and add the property to your search parameters.

You can also hit the properties button and change the user defined property value right there in the search results dialog.

You can also hit the properties button and change the user defined property value right there in the search results dialog.

And of course, you’ll want this new user defined property in your reports. Just create a custom report template and add your property.

This is a search results report, but you can add these to your regular reports as well.

This is a search results report, but you can add these to your regular reports as well.

Related Posts Plugin for WordPress, Blogger...
Tell Others About This Story:

Comments 4

  1. Hi Jeff, thanks for this post. I am trying to generate a data dictionary with additional user defined properties and found this post very useful. However, the recipe here doesn’t seem to work on 17.2. Can you update the post with 17.2 version?

    1. thatjeffsmith Post
      Author
    1. thatjeffsmith Post
      Author

Leave a Reply

Your email address will not be published. Required fields are marked *