Community Tip - When posting, your subject should be specific and summarize your question. Here are some additional tips on asking a great question. X
Hello Steve,
Thanks for sharing this qml report definition! Very handy.
One quick question, how do I display the user name who has the items checked out when I run the report? I can see the names when I preview from the query builder, but not when I run the report.
Thanks again!
I don't know which report are you talking about, but I have a report always opened to verify checked out objects and I can see the name of the user.
Below object type used and attribute selected.
Can you step me through how to set this up as a standard report, thanks.
Can you specify your request in more detail?
From what you have written I cannot understand what you are asking.
Sorry - that was pretty vague I guess. I am not new to Windchill but have never run a report of any kind. Would like to know objects I personally have checked out and also for the whole user group in general. Any pointers are appreciated.
I've struggled to get a trustable query builder report for checked out items, including having multiple tech support cases on this. Returned results sometimes are not in fact checked out.
There are multiple CS articles on ptc with sql scripts to pull directly from the database.
I've been using this for a while and fully trust it:
SELECT
a3.name "User",
a2.name "Workspace Name",
a5.documentnumber "CAD Doc Number",
A0.createstampa2 "Checked Out Since"
FROM EPMCheckpoint A0,EPMCheckpointMaster A0B,BaselineMember A1,
epmworkspace A2, wtuser a3, epmdocument a4, epmdocumentmaster a5
where
a4.ida3masterreference = a5.ida2a2
and A1.idA3B5 = a4.ida2a2
and A0.ida2a2 = A1.idA3A5
and A0.idA3masterReference=A0B.idA2A2(+)
and A0B.ida2a2 = a2.ida3a5
and a2.ida3m5 = a3.ida2a2
and a4.statecheckoutinfo = 'wrk'
order by A0.createstampa2