query builder report

[MikeLockwood]

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)

[FeofilovIvan]

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

[VincentQuesnoit]

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)

[MikeIbosh]

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

[dwilliams]

Hi Mike,

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



Hope this helps,

Dax