It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×12,008
×1,305

question asked: Oct 28 '13, 11:50 a.m.
question was seen: 5,581 times
last updated: Oct 30 '13, 2:17 a.m.

Related questions

Multiple version assets for a category schema

0
iRAM Administrator (315●2●156●135) | 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

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
iRAM Administrator (315●2●156●135) | 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.