Report on WF Variables

[MikeLockwood]

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

[AL_ANDERSON]

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:

[MikeLockwood]

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 [

[AL_ANDERSON]

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

[ddemay]

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

[ssenthil]

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:

[MikeLockwood]

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

[abhishekarya]

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.

[Marco_Tosin]

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.

[gmontgomery-2]

Abhishek,

I thought there might be a way to access BLOB type data elements using a Java Method with QueryBuilder. I'd already found the reference you provide and that does not point directly at accessing the contents of the BLOB. Specifically I'm interested to access the RuleData for an LWCBASICCONSTRAINT e.g. legal list values from QueryBuilder using a Java Method. If you have a snippet of code along these lines I would very much appreciate being able to reference it.

Regards,

Greg Montgomery