Skip to Content
0

Query PowerDesigner for the current Model

Dec 29, 2017 at 01:26 PM

73

avatar image

I am looking to query the PowerDesigner Repository to return the current / latest Model version as is displayed in the Object Browser Repository Tab. The PMOBJT LVRS column is flagged for many versions and doesn't seem appropriate for this use. Any suggestions or thoughts?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

George McGeachie Dec 29, 2017 at 03:31 PM
0

I don't know why you're looking for the name of a column to access metadata about an object in the PD interface - in the object model, the version for the latest version of a repository model object in the current Branch is held in the Version property.

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Unsure of your need to know, however I need the capability to report on current Model content to provide concise socialized metadata (including custom tacit metadata) regarding our orgs data assets. Think of it as how do we optimize the investment of the new currency (i.e. data) within the enterprise? I suspect this is a higher level that you originally responded to? Thanks for the effort.

0

Thanks for the clarification, Michael. I was merely wondering aloud why you were accessing the database directly (presumably with SQL), rather than accessing it via the API, hence my comments about the object model. I expect you're using the tools that work for you. Personally, I'd rather use a scripting language, mostly because I've never written SQL - I know that's heretical in some data modelling circles, but there you go.

0
Michael Frey Jan 08 at 06:02 PM
0

George, to clarify the latest version of the Model Object is in PMOBJT, correct? When you say Current Branch, we have some Models that haven't gone through any "branching" per se. The issue is that multiple PMOBJT Model objects have the LVRS set to 1, and every branch doe as well, not just the current branch. I could certainly be missing something. Thx.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Sorry, I'm not going to guess where and when PD does things in database tables and columns. I stick to the API and object model.

0
Michael Frey Mar 01 at 04:48 PM
0

Just to render a close to this, for everyone's information PowerDesigner builds the Object Browser Repository Tab Tree map of Models and their current versions from PMOLOG table looking for the latest version via NAME and VRSN columns. It is then possible to traverse all child objects via the PMOBJT Objects.

The PMOBJT LVRS seems to have a different purpose other than the austere description within the installation materials "Repository Metamodel" PDM.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks for the info, Micahel :)

0