Skip to Content
author's profile photo Former Member
Former Member

PowerDesigner 16.5 Search on Repository for Keyword property

Hi team,

We want to search on repository root for keyword property.

For example we want a list of all models that keyword is “ABC”, if we search on workspace root for property KeywordList PowerDesginer retrieve all models that have the specific keyword however if we search on repository it doesn’t retrieve any object.

We are searching using feature “Find Objects” in Advanced tab.

How can we search on repository (PowerDesigner Client and PowerDesigner Portal) for keyword property?

Best regards,

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jan 31, 2014 at 02:10 PM

    Hi,

    seems this is not working. Tried several things but got no reply from the "Find Objects" feature.

    In the Repository the keyword is saved as an object in the PMOBJT table but this object seems not to be an searchable one using "Find Objects" feature.

    A bit strange workaround might be to find the objects via an SQL statement against your repository.

    Do seach steps like this

    1. Identify the keyword object with his name which is the keyword in your case ABC

    select OBJT from PMOBJT where NAME = 'ABC' and CLSS = 1055;

    2. Find all related objects to the keyword object id (for instance OBJT=12345)

    select SRCE from PMRLSH where TRGT = 12345 and PRNT = 0;

    3. select the objects using the keyword and find out the code / name (for instance there is only one SRCE=67890)

    Select name, code from PMOBJT where OBJT=67890

    Sorry a bit strange solution but it should do the job.

    Stefan

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.