topic query builder report in Windchill

query builder report

MikeLockwood — Wed, 02 May 2018 17:31:28 GMT

I have a long-running tech support call on this. Getting close but still not working. Seems like it should be very simple.Need a query builder report for which returns all change requests which have been approved by a specific Role (Sustaining Engineeering in our case). Note: We route

RE: query builder report

FeofilovIvan — Tue, 27 Apr 2010 07:32:01 GMT

I can help you, write full description of report that you need on fivig{@}mail.ru

RE: query builder report

VincentQuesnoit — Tue, 27 Apr 2010 08:15:56 GMT

Mike,

I would say existence of a completed workitem for the given role would mean the Change Request was approved by that role, so a sub-selection query would do the trick.

I have a query which selects change issues according to who has a workitem for a given role, I guess it would be easy to add a test for the workitem's state being "completed".

HTH,

Vincent

In Reply to Mike Lockwood:

I have a long-running tech support call on this. Getting close but still not working. Seems like it should be very simple.
Need a query builder report for which returns all change requests which have been approved by a specific Role (Sustaining Engineeering in our case). Note: We route Change Requests for approval to several roles; these vary depending on what is changing. We don't use the Change Admin I, II, III concept.
thanks in advance (9.1 M040)

Query Builder Report

MikeIbosh — Tue, 22 May 2012 20:04:37 GMT

Good afternoon all,
I'm looking for a 9.1 M060 report that, for each non-disabled user in the WTUser table, shows their last login date and time from the Audit table. Does anyone have anything like that, or be willing to share something close to it?
Mike

Query Builder Report

dwilliams — Thu, 24 May 2012 22:44:54 GMT

Hi Mike,

Did you get a working report? If not, the attached reports should get
you started.

Hope this helps,

Dax