Multiple version assets for a category schema

iRAM Administrator

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

0 votes

1 answer

5,700 views

0 votes

One answer

Permanent link

iRAM Administrator

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

0 votes

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.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers

Answers and Comments

Question details

usage

× 12,028

rational-asset-manager

× 1,305

Question asked: Oct 28 '13, 11:50 a.m.

Question was seen: 5,700 times

Last updated: Oct 30 '13, 2:17 a.m.

Multiple version assets for a category schema

iRAM Administrator

1 answer

5,700 views

0 votes

One answer

iRAM Administrator

Your answer

Follow this question

Question details

Related questions