object ID of the EPMDocument

[JohnDavid]

Hello,

could you please someone help me to get the Object ID of the EPMDocument from EPMDocument table using query builder?

Thanks in advance..

[ptc-3864225]

Try Attribute, EPM Document, Persist Info, Object Identifier, Id
This will return the number part of the identifier
Or skip the last step, use Object Identifier to return as wt.epm.EPMDocument:310682810

This works on Windchill 9.1

[JohnDavid · Accepted solution]

Hello Nick,

Thanks for your reply. Actually i tried EPM Document, Persist Info, Object Identifier, Id.

That returned some number, However it is not object Number.

I will try EPM Document, Persist Info, Object Identifier.

I am using Windchill 9.0 M080.

[ptc-3864225]

Hi John,

I fell into that trap then, thought it was too easy.

I've given you what is known as the Object Identifier according to the Windchill API.

Just answered the question, not sure what you wanted it for.

So my next question is, which value you are looking for?

The EPMDocument number is given by Number

The CAD Name is given by File Name

Anything else, perhaps you could clarify.

[JohnDavid]

Hello Nick,

The url, When I am opening the EMPDocument.

http://windchill/Windchill/servlet/TypeBasedIncludeServlet?oid=VR%3Awt.epm.EPMDocument%3A1034626599&u8=1

I need the numbser after 3A ie 1034626599.

I thought it is the object ID. Sorry if i am wrong here.

Thanks for your reply again.

[GregoryPERASSO]

Hello,

in your URL there's a VR (= Version Reference, ie latest iteration of that version)

it is a different id that the OR (Object Reference or Object Identifier, ie a particular interation of your object) You can see some URL similar to yours with OR (notably if you navigate on a particular iteration in the history table ...)

You should be able to find the VR id in QueryBuilder, try version reference or branchid ...

[ptc-3864225]

Hi John,

Your URL is for a Version (VR in the URL)

My original answer would give you a specific iteration (OR in the URL)

From the Select tab, I'm adding a select clause for an Attribute of EPM Document

If you are OK with an iteration, change your URL to use OR instead of VR then use one of the following

Persist Info.Object Identifier.Id will return you a number, e.g. 310682810

Persist Info.Object Identifier will return you a full object identifier, e.g. wt.epm.EPMDocument:310682810

e.g. http://windchill/Windchill/servlet/TypeBasedIncludeServlet?oid=OR%3Awt.epm.EPMDocument%3A310682810&u8=1

If you really want a version, keep the VR in your URL, and use the Branch Identifier

e.g. http://windchill/Windchill/servlet/TypeBasedIncludeServlet?oid=VR%3Awt.epm.EPMDocument%3A310682809&u8=1

[JohnDavid]

Hi Nick,

Thanks for your detailed explanation..