Hello,
I need to show my WebReport as Smart UI Widget. The current NodeID (depends on user's choice) will use as parameter's for the report by default .
Is it possible to use some "smart" parameter?
How I can achieve such requirement?
Thanks ,
Olga
**** Olga,
Yes it is possible! This really is the strength of the HTML WR Tile is that you make dynamic views, based on location. I have worked with several clients that wants a dynamic/aggregate view based on a BWS Metadata.
For Example, you browse a BWS and want a view that is based on a custom query to make a List/Aggregate of Documents (from elsewhere in the system) based on the Metadata of the BWS.
Pre v21.4/"Upgrade" to Perspectives, you could make a rule if your Perspective applied, like based on Folder Name.
"[LL_REPTAG_SOURCEID WorkspaceTypeId /]" == "1" AND "[LL_REPTAG_SOURCENAME /]" == "Special Folder"
Sadly after 21.3 rules are out so now just lots
of tabs.
You can get the ID of current node in Smart UI using &csuiContainerID
Attached is an example.
Regards,
-MC
Hi Olga,
If I understand you correctly then what you want is not possible, but you can create a functional request for it.
My understanding:
With the WR Widget you can configure if the user is asked for parameters. When you enable that then the parameters are listed and the user has to enter them before the report results are shown. The user is then also given the option to change the parameters.
You can also configure that the reports results are shown immediately, but then the user is not able to change the parameters afterwards.
What you want is that the report shows it results with some default value and the user is able to change the parameters. This is not possible.
Please confirm my interpretation and if correct, please create a FR.
Hans
Hans,
Did you not see my response above with &csuiContainerID
You can call this WR and pull out &csuiContainerID from the internal query string of the Smart UI and then call a Sub WR with this info.
In the above example, I render all Documents in the current BWS and all Related BWS "Flat" aka No Folders. I do it with my Customer View All Documents (based on JS package tablesorter) and then again using the Smart UI Node List, Nodes Table, and finally Table Report.
The Query/LiveReport that drives the lookup gets its required param from the "top" WR.
Hi ,
Thanks a lot for the advice, I'll try with the &csuiContainerID and update you.
I saw before some discussions that mentioned the tag &csuiContainerID , but didn't find anything about it in OT help documentation.
Olgh,
csuiContainerID is the solution to your Smart UI problem.
Having read many times, all the Offical OT WR, ActiveView, Smart UI, Smart UI SDK Documentation that is leaves A LOT to be desired. The best information comes from this forum and the generous posts of ECM Professionals.
This forum has helped me a lot so I'm trying to give back some.
If you have any other questions, please let me know. I will try to help.
Hi MC,
Running Webreport based on category with the LL_REPTAG_&csuiContainerID was successful.
The next challenge is to pass the LL_REPTAG_&csuiContainerID as parameter to the query of the live report , that configured as Webreport source
is it possible?
BR,
It is better to use [LL_REPTAG_WIDGETCONTAINERID /].
That is a documented and supported method to get the ID.
Hey Olga and Hans,
[LL_REPTAG_WIDGETCONTAINERID /] seems better than [LL_REPTAG_&csuiContainerID /]
Now that I know what to look for, I can find it :)
To pass in the current node to a HTML WebReport Tile as a parameter, you first get parms in the "top" WR and then pass it to a child/Sub WR using RUNSWR (Run SubWebReport).
RUNSWR is very, very powerful in WRs.
Please see csuiContainerID.png (my first post). You can see in my "top" WR (which is what the HTML Content Intelligence Tile points to) I get the current node's BWS ID and the 'Reference ID'/Cat & Att metadata and pass these to the sub-webreport.
The SubWebReport takes 2 params, Reference ID and bwsID
So using RUNSWR I can invoke a WR that takes params and pass them in from "above" The SWR tab will be populated by whatever the SubWR outputs.
In my example I use the BWS ID and the Reference ID to lookup all the Documents/144s in the current BWS and all Related BWS in a LiveReport.
Hope that helps, please let us know how you make out.
Hi MC
Thanks a lot for your advice and explanation!!
It very helpful!
When passing nodeID as a parameter to the WR, how we can use this parameter to pass it to the query of the LiveReport that it's chained to and retrieve a data?
If you have as parameter to your sub webreport the parameter "NodeID", then in your LR you also need to define a parameter for that. In the third field of the LR parameter you need to also write "NodeID". The default value is something line InputLabel1.
Hi @Hans Stoop This might be a stupid question but i am starting very new to smart view webreport, I have a HTML report view which is calling a subwebreport (SmartStyle table report) with two parameters for users input, It works fine and then once it displays, the widget does not expand and also clicking on the pencil icon is also not working, but if i make the subwebreport as a shortcut group, then everything is working as expected
First Report
but post running, whether i click pencil icon or i click expand on both i get the following one line banner