Search found 12 matches

by dbosman
Tue Nov 26, 2019 8:37 am
Forum: Polarion Application Lifecycle Management (ALM)
Topic: Get Count from Dataset SQL query
Replies: 5
Views: 3067

Re: Get Count from Dataset SQL query

You mean you do not know the exact values for the different states? Those are most probably the same values as you are using in the lucene query "approvalState:approved". If that doesn't work then you could do a simple query on the approval table and get the distinct status values. Exactl...
by dbosman
Sun Nov 24, 2019 7:23 pm
Forum: Polarion Application Lifecycle Management (ALM)
Topic: Get Count from Dataset SQL query
Replies: 5
Views: 3067

Re: Get Count from Dataset SQL query

Hi, I modified the post and fixed the syntax error. Still no idea however to retrieve the count from an SQL query. I am now trying to use a widget to get the count: <span class="polarion-rp-inline-widget" data-widget="com.polarion.countOfObjects"> <span class="polarion-rp-wi...
by dbosman
Thu Nov 21, 2019 2:32 pm
Forum: Polarion Application Lifecycle Management (ALM)
Topic: Get Count from Dataset SQL query
Replies: 5
Views: 3067

Get Count from Dataset SQL query

I am busy building a SQL query using aggregates (GROUP BY). I want to count the number of results. I want to use the Dataset instance to execute the query. How do I retrieve the 'cnt' column from the result? #set($sql="SELECT COUNT(m.c_uri) as cnt FROM polarion.module m JOIN polarion.project p ...
by dbosman
Thu Aug 23, 2018 7:50 am
Forum: Polarion Application Lifecycle Management (ALM)
Topic: Branch whole project
Replies: 1
Views: 1655

Branch whole project

Hello, We have a project in Polarion of which we need to maintain 2 versions: Scenario1 and Scenario2 Scenario1 is leading, Scenario2 will have some changes w.r.t. Scenario1. A first idea is to create an SVN branch. Scenario1 would be trunk and Scenario2 a branch. Next we work on both projects and a...
by dbosman
Fri Feb 09, 2018 12:23 pm
Forum: Polarion Application Lifecycle Management (ALM)
Topic: Get Last Revision of a WorkItem using the SOAP WEB api
Replies: 4
Views: 4269

Re: Get Last Revision of a WorkItem using the SOAP WEB api

Thanks for the suggestion!. This already shows quite a speed up.
by dbosman
Thu Feb 01, 2018 1:42 pm
Forum: Polarion Application Lifecycle Management (ALM)
Topic: Get Last Revision of a WorkItem using the SOAP WEB api
Replies: 4
Views: 4269

Re: Get Last Revision of a WorkItem using the SOAP WEB api

I'm using this code to obtain the last revision Change[] changes = trackerService.generateHistory(wi.getUri(),null,null); List<Change> changes_l = Arrays.asList(changes); Collections.reverse(changes_l);. String revision = changes_l.get(0).getRevision(); But as said this traverses the complete histor...
by dbosman
Wed Oct 11, 2017 2:27 pm
Forum: Polarion Application Lifecycle Management (ALM)
Topic: Get Last Revision of a WorkItem using the SOAP WEB api
Replies: 4
Views: 4269

Get Last Revision of a WorkItem using the SOAP WEB api

How can I retrieve the last revision id of a work item using the SOAP WEB api? It is possible via the trackerService generateHistory method, but this retrieves all revisions and change information which is very slow. May be its possible using one of the TrackerSevice methods, unfortunately the API j...
by dbosman
Mon Feb 27, 2017 9:19 am
Forum: Polarion Application Lifecycle Management (ALM)
Topic: Hashmap and Arraylist in Velocity
Replies: 2
Views: 4215

Hashmap and Arraylist in Velocity

On http://velocity.apache.org/engine/1.7/user-guide.html an example is showed how to use maps and lists in Velocity: #set( $monkey.Say = ["Not", $my, "fault"] ) ## ArrayList #set( $monkey.Map = {"banana" : "good", "roast beef" : "bad"}) ## ...
by dbosman
Mon Feb 20, 2017 11:17 am
Forum: Polarion Application Lifecycle Management (ALM)
Topic: Permissions
Replies: 2
Views: 2819

Re: Permissions

Thanks,

On the work item - read only fields page it is stated:

"Note that read-only fields should not be considered as a security feature. Administrators should be sure to properly configure user permissions, among other things."

Why?
by dbosman
Mon Feb 20, 2017 11:11 am
Forum: Polarion Application Lifecycle Management (ALM)
Topic: programmatic PDF export
Replies: 0
Views: 1995

programmatic PDF export

I would like to automatically export a number of Polarion live documents (and possibly reports, wiki pages) as PDF documents. 1. Would it be possible to use the Java Web Services API for this? 2. Can the Velocity scripts be used? 3. Would this be possible via a REST api (by adding some URL parameter...
by dbosman
Wed Feb 08, 2017 11:37 am
Forum: Polarion Application Lifecycle Management (ALM)
Topic: automated PDF export
Replies: 1
Views: 2294

automated PDF export

I would like to programmatically (without user interaction) export PDF's of Polarion live documents.

1. Can this be done via a REST api (eg. by adding url parameters)?
2. Is this possible using Java Web Services?
3. Is this possible using Velocity scripts?
by dbosman
Wed Feb 08, 2017 10:26 am
Forum: Polarion Application Lifecycle Management (ALM)
Topic: Permissions
Replies: 2
Views: 2819

Permissions

We have the following workitem workflow: draft -> in review -> reviewed in review -> draft In draft workitems may be edited but not approved During review workitems may be approved but not modified When reviewed workitems may not be modified or approved/disapproved At a first glance you would set th...

Go to advanced search