cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X

Translate the entire conversation x

SQL Query to return ALL versions of every EPMDocument?

btinder
1-Visitor
1-Visitor
‎Feb 08, 2017 06:59 PM
‎Feb 08, 2017 06:59 PM

SQL Query to return ALL versions of every EPMDocument?

Hi all,

I've been trying to write a query which will return a list of every EPMDocument object and every revision of that in the database. I believe I need to hit EPMDocumentMaster and join that with EPMDocument, but I'm not sure how. Any help?

Labels:
0 Kudos
Notify Moderator
1 REPLY 1
BineshKumar1
13-Aquamarine
13-Aquamarine
(To:btinder)
‎Feb 08, 2017 07:13 PM
‎Feb 08, 2017 07:13 PM

‌there should be a lot of reports in Resource for reporting‌

DB relationship - ida3masterreference of epmdocument = ida2a2 of epmdocumentmaster

Notify Moderator
Announcements
Contact Community Management
Top Tags