Interactive Liverepot Page - Table-Block Widget

Description
fml
Posts: 7
Joined: Tue Jul 31, 2018 1:03 pm

Interactive Liverepot Page - Table-Block Widget

Postby fml » Wed Aug 01, 2018 12:04 pm

Dear all,

I would like to generate an interactive Livereport Page without scripting (as I am not a programmer :( ).

Is it possible to affect the query in a Table-Block Widget? The User should for example select a creation date or another value of a custom enumeration (Page Parameter) and the query of the Table-Block Widget should be connected to the selected data?
At the moment I use Polarion ALM 2016.

Best regards and thanks in advance
Markus

Salmolin
Posts: 14
Joined: Mon Sep 21, 2015 5:54 am

Re: Interactive Liverepot Page - Table-Block Widget

Postby Salmolin » Tue Mar 05, 2019 6:13 am

I would also be intressted in this...

fml
Posts: 7
Joined: Tue Jul 31, 2018 1:03 pm

Re: Interactive Liverepot Page - Table-Block Widget

Postby fml » Tue Mar 05, 2019 7:17 am

Dear all,

by the help of a colleague I fould a solution for my request:

1. Set-up a Livereport page
2. define Page Parameters you would like to affect in your Querry (e.g. Timepoint, Release-Enum, Assignee)
3. input a Page Parameter Block to select the defined Page Paremeters
4. insert for example a Table Block to show for example a table of Requirements which are filtered by the selected parameters
5. select Querry-Type "Lucene+Velocity" in the Table Block
6. insert the following Querry-Code:

type:requirement
#if($pageParameters.AND_Time_Point.singleValue())
AND timePoint.id:( #foreach ($param in $pageParameters.AND_Time_Point.values())
$param.id()
#end)
#end
#if($pageParameters.Release.singleValue())
AND release:( #foreach ($param in $pageParameters.Release.values())
$param.id()
#end)
#end
#if($pageParameters.assignee.singleValue())
AND assignee.id:( #foreach ($param in $pageParameters.assignee.values())
$param.id()
#end)
#end

7. Now the content of your Table Block is interactive :D .

In some cases it is a bit tricky to find the right Querry in combination with the set Page Paremeter.
Additionally we found, that it is good to set the type of the WorkItem (in this example "type:requirement") to secure, that it works. Dont know why.
We use this for an interactive Releasepage and it works very well.

Best regards
fml

micdal
Posts: 22
Joined: Thu Feb 09, 2012 6:22 am

Re: Interactive Liverepot Page - Table-Block Widget

Postby micdal » Tue Mar 05, 2019 1:57 pm

Hi fml,

thanks a lot for your example. It works great for me :D

Regards,
Michael

Frenette
Posts: 1
Joined: Tue Mar 05, 2019 12:41 pm

Re: Interactive Liverepot Page - Table-Block Widget

Postby Frenette » Wed Mar 06, 2019 1:55 pm

Seems like a great example, fml. How do you go about finding the right Querry by the way?

fml
Posts: 7
Joined: Tue Jul 31, 2018 1:03 pm

Re: Interactive Liverepot Page - Table-Block Widget

Postby fml » Wed Mar 06, 2019 4:24 pm

Frenette wrote:Seems like a great example, fml. How do you go about finding the right Querry by the way?


Hi Frenette,

not sure if I got you point. So what is you question about the querries?

Best regards


Return to “Polarion Application Lifecycle Management (ALM)”

Who is online

Users browsing this forum: No registered users and 5 guests