Displaying the Maximo Dataset URL

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: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>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"));
</pre>
 
Any help would be appreciated. 
 
Thanks in advance, 
 
Mark

Find more posts tagged with

Comments

micajblock

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

<blockquote class='ipsBlockquote' data-author="'mblock'" data-cid="101137" data-time="1337641857" data-date="21 May 2012 - 04:10 PM">
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. </blockquote>
 
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.