The DataMiner help indicates it is possible to generate a report via a URL.
We aim to get a trend graph of a table column with a filter.
We failed to get this to work by using report-element as it is described in the help, and from the URL example we saw we need to use report-parameter to get it to work:
http://localhost/Reports/Report.asp?report-template=trending&report-element= 157/2& report-parameter=107(SL*|1)&report-parameter=350&report-title= Trending& report-message=This is a trending report&report-format=html
But there is no explanation on the report-parameter.
What does the |1 mean in the filter?
We also need to call this URL from an external system (an automation workflow engine), can we pass the dataminer credential within this report URL? If it's not possible to do it, what is the best practice for this kind of integration?
The report-parameter values can be any of the following:
- 123 => a single parameter
- 123(1) => a single parameter with options defined
- 123(idx|1) => a column parameter with a row index or filter (can have * and ? wildcards)
The options indicate which trend types to include and are a combination of these:
- 0 = no options
- 1 = average
- 2 = min
- 4 = max
- 8 = show real time next to avg
As an example, 107(SL*|7) would include the avg/min/max of all SL* cells from column 107 ( 7 = 1 (avg) + 2 (min) + 4 (max))
Whether the options are supported depends on the components being used in the mail report.
For accessing the report URL remotely, there's no URL options available to include username/password. If the library through which the URL is being requested supports Windows Authentication, I believe you should probably be able to make the request work by passing in authentication details to that library (such as here), but it's not something I've seen used before.
In Reporter it's possible to make all the element-, parameter-, etc. selections for a given report template, and then you can easily copy the url by right clicking on the permalink icon:
The copied url will contain all the selections.
The |1 in the filter comes from the trend options that can be selected here:
Hello,
it's clear, thank you for the information.
Simone