It's all about the answers!

Ask a question

Multiple version assets for a category schema


iRAM Administrator (3152156135) | asked Oct 28 '13, 11:50 a.m.
Hello,

We would like to list all multiple-version/ multiple State (Draft & Approved) assets under a specific category schema.

Is there any automated way that can do that? DB Query or any other way,...

Thanks

One answer



permanent link
iRAM Administrator (3152156135) | answered Oct 30 '13, 2:17 a.m.
SELECT * FROM <SCHEMA_NAME>.ASSET WHERE ID LIKE ‘-%’

The above query will return assets details, which are transition states [Draft, Review, Plan Review, etc.,] of assets after modified published states [Approved, As-is] of asset.

Thank you
Bakiyaraj Arul
bakiyaraj.arul@in.ibm.com
Mobile: +91-9840144332
India

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.