[robbinma]

Hello,

I am trying to display the URL of the database that the report is running against.
I would like to be able to display the URL in a label so the developers can tell which DB the report is being run against.

I think it is available via a property and have tried various combinations but everything I have tried returns null.

These are the things I have tried:

logToDebugWindow(this.getDataSource().getName());
logToDebugWindow("url with prefix: "+this.getDataSource().getExtensionProperty("maximoDataSource.url"));
logToDebugWindow("url: "+this.getDataSource().getExtensionProperty("url"));
logToDebugWindow("URL: "+this.getDataSource().getExtensionProperty("URL"));
logToDebugWindow("odaUrl: "+this.getDataSource().getExtensionProperty("odaURL"));

Any help would be appreciated.

Thanks in advance,

Mark

[mblock]

The issue is that Maximo hides the database URL via classes. So unless you ask IBM how to get the data source from their custom classes your only option is to read the mxreportdatasources.properties file.

[robbinma]

mblock, on 22 May 2012 - 12:10 AM, said:

The issue is that Maximo hides the database URL via classes. So unless you ask IBM how to get the data source from their custom classes your only option is to read the mxreportdatasources.properties file.

Thanks.
I'll talk to the relevant people here and see if I can raise a PMR to ask that.

There would be a lot of benefit in terms of ensuring reports are being run against the right data source.