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.
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.