Jasper Ideas

Get database remarks / description in domain description column automatically

When we create a domain, we get all tables from datasource, with their columns, types, etc.

It's all good.


But in our database, we have a "description" metadata column in all our fields.

For exemple a table "USER" :


USER :

_________________________________________________________
name type description
_________________________________________________________

id bigint "the id of user"

name varchar "the name of user"

birthdate date "the birthdate of the user"

etc...


In domain, we get the fields name, and the field type, but we don't get the field "description".


There is a "description" column in domain for each field but is empty.


Can we make jasper get automatically the column description from database and fill the description in the domain with this ?


It's possible with jdbc to get this database metadata information easily. I did it with a java project and a jdbc driver and it works.


A website that explain how to get the description.

The functionnality i need is jasper get this description and fill the description in the domain.

https://www.baeldung.com/jdbc-database-metadata


  • Guest
  • Jan 13 2022
  • To be Reviewed
Components Domains
  • Attach files
  • Guest commented
    13 Jan 09:29am

    Here database screen of description column and domain screen of description column