Skip to main content
J
JimTVancouverCa1-Visitor
1-Visitor
May 15, 2014
Question

RE: Easiest Way to Report on "Checked out Objects"?

  • May 15, 2014
  • 2 replies
  • 3019 views

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!

2 replies

Marco Tosin
21-Topaz I
Marco Tosin21-Topaz I
21-Topaz I
April 23, 2018

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.

 

Checkout Link [wt.vc.wip.CheckoutLink]
Original Copy.Checked Out By.Display Name [originalCopy.locker.displayName]
Marco
G
gharris-31-Visitor
1-Visitor
November 4, 2019

Can you step me through how to set this up as a standard report, thanks.

Marco Tosin
21-Topaz I
Marco Tosin21-Topaz I
21-Topaz I
November 4, 2019

Can you specify your request in more detail?

 

From what you have written I cannot understand what you are asking.

Marco
M
22-Sapphire I
MikeLockwood22-Sapphire I
22-Sapphire I
November 4, 2019

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

Terms & ConditionsCookie settingsAccessibility statement