Find latest revision with any status (Not in RAC)

[Amol_XPLM]

Hello Experts,

how to get following sets of Revisions where a Solid Edge datasets are attached.

1. Latest with any status

2. Latest working

As the quantity is large, we are looking for ways to get it using utility or SQL so the report could be out to a file.

[GaneshDasmale]

Are you looking for ITK API for making command line Utility?

or are you interested in using SOA?

[Amol_XPLM]

Hi Ganesh, thanks for your reply. I have tried with SOA already, but it seems to be very slow.
Do you know how to get it with ITK or SQL ?

Applying revision rules on BOM doesn't seem to be an option, we have to work on Item level.

[jonathan_morris]

For ITK you could use the following;

ITEM_ask_latest_rev(tag_t item, tag_t* rev) - Returns the latest revision of an item (irrespective of status).

CFM_item_ask_configured(tag_t rule, tag_t item, tag_t* configured_rev, char** how_configured)

Finds the revision of the given item that is configured when the given revision rule is used to configure the given item. Also returns a textual representation of which entry/entries in the rule caused the particular revision to be configured.

Use CFM_find(const char* name, tag_t* rule) to find a revision rule.

[Amol_XPLM]

Thanks for your reply.
We found out that the low performance of SOA utility was due to more CPU consumption on server.
SOA seems to run fine after fixing that.