How to get list of model versions information in PowerDesigner?

[hongjiang]

If I have one folder in repository, and the folder has subfolders, each subfolder has multiple models.

How do I list each model version info (version number, creator, the time each version created), plus all sub-folder names? 

For example:

FolderA-SubfolderA1-ModelM v3 *** John Doe - Tuesday, March 11, 2025 4:11:55PM ***

FolderA-SubfolderA1-ModelM v2 *** Jane Doe - Tuesday, Jan 12, 2025 10:21:34PM ***

FolderA-SubfolderA1-ModelM v1 *** Peter Doe - Friday, Dec 4, 2024 6:05:08AM ***

This is can be done by SQL queries?

[Ondrej_Divis]

Hello Hongjiang,

you can use following code:

For each cho in subObject.ChildObjects
output "-------------------------------"
output cho.name
output cho.ShortDescription
output cho.ClassID
Next

ChhildObjects collections contains all other model objects (tables, views, etc.) but you can find information about attached definition file. You can use information in the ShortDescription or ClassID properties. You can go with "Target model reference ..." or "Shortcut..." and make some further filtering. It is not optimal but it is the best you can do without checking out the model from repository.

HTH,
Ondrej Divis