Polarion widget table with sql query

Question

What is the syntax for the sql query in the table block. I want to have this native sql query:

    Select CC.*from WORKITEM P, WORKITEM C, WORKITEM CC, STRUCT_WORKITEM_LINKEDWORKITEMS Link, STRUCT_WORKITEM_LINKEDWORKITEMS Link2, PROJECT Proj WHERE P.C_PK=Link.FK_WORKITEM AND Link.FK_P_WORKITEM = C.C_PK AND C.C_PK= Link2.FK_WORKITEM AND Link2.FK_P_WORKITEM= CC.C_PK AND P.FK_Project=Proj.C_PK AND P.C_type ='release' AND CC.C_type='task' AND Proj.C_ID ='$pageParameters.ProjectID.value()' AND P.C_ID='$pageParameters.ReleaseID.value()'

I tried it like this:

but there is an error: Failed to parse SQL query: ERROR: syntax error at or near "select" Position: 23

I am not sure you can use these pageparameters directly in the query.. Did you check it with constants? — Peter Parker, Nov 26 '20 at 09:58
yes I checked it. It should be possible to use the pageParameters because I choosed sql+velocity — Der Altmann, Nov 26 '20 at 10:38

Paweł Jamroziak · Accepted Answer · 2021-01-29T08:23:10.163

2

You can't use SQL Query like that. Gray lines are static lines, you can't skip / ignore it.

If you want use your SQL Query, choose Script - Block and use Velocity Syntax (+ HTML, CSS) with Polarion Shared API:

sdk/doc/javadoc-rendering/com/polarion/alm/shared/api/model/ModelObjects.html

@Edit

For full custom widget documentation: https://almdemo.polarion.com/polarion/sdk/doc/widget-sdk.pdf

edited Jan 29 '21 at 08:23

answered Jan 29 '21 at 08:02

Paweł Jamroziak

60
1
10

Polarion widget table with sql query

1 Answers1