Runtime retrieve database connection name

Andy Cody

Solved

Question

Hi community,

I would like to provide the name of the current database connection name to the user so they know which database they are connected to.

In our scenario we have multiple copies of the same code attached to different databases for regression testing purpose.

I would like to display the database to the user

For example this database extension connects to "oms.bau.local"

is there are server action of database system table I can interrogate to retrieve this in runtime?

Running O11 on premises.

thanks,

Andy

06 Aug 2024

Andy Cody

Solution

Thanks Mohd for the response. For those searching on this we used the following query to get the information:

Filtering on Application name

seems to work ok.

Regards,

Andy

19 Aug 2024

Mohd Shuaib

You can use advanced query to serve the purpose.

The query will be written according to your database type (MySQL or SQL server or maybe any other database).

Hope this helps!

06 Aug 2024

Andy Cody

Solution

Thanks Mohd for the response. For those searching on this we used the following query to get the information:

Filtering on Application name

seems to work ok.

Regards,

Andy

19 Aug 2024

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.