Skip to main content
MikeLockwood22-Sapphire I
22-Sapphire I
August 11, 2010
Question

Report on WF Variables

Anybody figure out how to get a query builder report to display the value of a workflow process global variable?

9 replies

AL_ANDERSON12-Amethyst
12-Amethyst
August 11, 2010
If you use some code in an application robot, conditional expression, or
task transition to copy the process level variable into a modeled
attribute on the WfProcess object that is not used anywhere else (i.e.
Process Description), then you can use query builder to get the WfProcess
attribute value. If you need more than one value, you can use name|value
pairs with a delimiter. Or you might use XML, or whatever. If you only
need one value, and if you don't use an attribute like process
description, and if you also only need that value in the report, then just
set the WfProcess variable (i.e. description) to the value you want, add
that as a column in your output, and give that column an alias name that
is whatever you want it to be.

Al Anderson
Solar Turbines Incorporated







Mike Lockwood <mike.lockwood@alconlabs.com>
08/11/2010 12:27 PM
Please respond to
Mike Lockwood <mike.lockwood@alconlabs.com>


To
-
cc

Subject
[solutions] - Report on WF Variables




Caterpillar: Confidential Green Retain Until: 09/10/2010



Anybody figure out how to get a query builder report to display the value
of a workflow process global variable?

Site Links: View post online View mailing list online Send new post
via email Unsubscribe from this mailling list Manage your subscription
Use of this email content is governed by the terms of service at:
Translate
MikeLockwood22-Sapphire IAuthor
22-Sapphire I
August 11, 2010
Thanks very much for the suggestion.

We do use IBA's on the PBO of the workflow routinely, setting the value in the workflow and passing it back to the PBO. For a few workflow variables we were hoping to not have to burden the PBO with another attribute. The one in particular that we're looking at now is used to optionally skip a review step - and we'd like to report on which processes are done with skip.

There must be some way to expose WF variables to query builder w/o involving an attribute on the PBO though. Still very interested in anyone has found out how to do so.

From: Al X. Anderson [
Translate
AL_ANDERSON12-Amethyst
12-Amethyst
August 12, 2010
I am pretty sure that WfProcess-level variables are stored as BLOBs in the
database. If that is true, then I am also pretty sure that you cannot get
BLOBs out of the database with Query Builder.

Can anyone definitively confirm or deny what I have stated, above?

Thanks.

Al





"Lockwood,Mike,IRVINE,R&D" <mike.lockwood@alconlabs.com>
08/11/2010 04:48 PM
Please respond to
"Lockwood,Mike,IRVINE,R&D" <mike.lockwood@alconlabs.com>


To
"Al X. Anderson" <->
cc
"-" <->
Subject
[solutions] - RE: Report on WF Variables



Translate
ddemay1-Visitor
1-Visitor
August 12, 2010

That was my impression also and they are stored as Blobs. ACL's on objects are blobs and you cannot see those easily either.

Query builder is cool but cannot do everything. This would need to be an enhancement request.

Most companies trying to do this resort to customization where they build their own report.

Since you mention skipping a step and wanting to know if it is skipped, you could redesign workflow to have routing have a skip vote and use query builder to capture skip votes from wfvotingeventaudit.

Dave


Sent from my Verizon Wireless BlackBerry
Translate
ssenthil1-Visitor
1-Visitor
August 12, 2010
At what stage of the PBO lifecycle history you would like to generate such
report. If you want to generate a report for all the existing processes it
would be a performance hit. If you have some qualifying criteria like "PBOs
created after" or "PBOs released after" then one can query for the PBOs,
retrieve the associated processes as well as the wfvariables. This would be
much easier to do by means of a light weight customization.



Thank you and have a great time.

Best Regards

Swamy Senthil

Principal Solutions Architect

973 216 0456(M); 973 324 2729(W); 866 908 6561(F)

Work Email: swamy.senthil@swasen.com

LinkedIn Profile:
Translate
MikeLockwood22-Sapphire IAuthor
22-Sapphire I
August 12, 2010
Good info and ideas here.
The user makes a decision at one in the process, and a conditional later on branches or not. The user making the decision also has radio button choices for another reason.

Looks like out two choice are:

- Map the WF variable to a PBO IBA

- Add another state which is only used in the branch that sometimes is skipped
Translate
abhishekarya14-Alexandrite
14-Alexandrite
September 14, 2016

You can use Java Method in Query Builder to retrieve the values of Workflow Variables, You can implement a Java file as follows:https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS114482&art_lang=en&posno=3&q=java%20in%20query%20builder&sour…

Also, You can create a method to have two arguments and pass them as parameter in query builder which will retrieve the values and display that in the Report.

Let me know if you need more details i can send some snippets.

Translate
    MarcoTosin
    MarcoTosin21-Topaz II
    21-Topaz II
    September 14, 2016

    Abhishek,

    in the community there is a group about Reporting I think you should join and where you can ask or wrote on query builder.

    I wrote a document Resource for reporting with lots of report ready to use, collected from many sources and Mike it's one of the biggest contributors.

    Translate
    Marco
    Terms & ConditionsAccessibility statement