Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page.
X
Hello All Written QML to query EPMs. I don't see option to add IBAs (String type) of EPMs to select statement. Anyone have experience of doing the same.
Hoping to not to write complex query referring String Def and Value and then link back to EPMs.
QML is normally not edited by hand but created by the Report Manager (site –> utilities), IBAs are supported so I suggest you create a report and add the type you need and you will then see the IBAs in the available list. If you want to see what the QML looks like save the report and open the QML file in an editor.
I had already in the situation how you described. So reaching this group to see any one successfully done adding IBAs into report. The issue is IBAs not appearing list (report manager).
Technically there's a different between TBA's (type-based attributes) and IBA's (instance-based attributes).
A TBA is a declared part of a type -- and should be selectable once you select the appropriate type.
An IBA is not a declared part of a type -- it's just an attribute that may or may not be applied to any given instance of an object. In this case, you are down to selecting by joining the various IBA tables.
This helps. I didn't notice subtype of EPM Document (CAD Document) should be used since IBAs were defined at that level. I have got result in a min without IBAs. But with IBAs in place, QB never completed for the same set of search criteria. I am going outside Query Builder and writing IE task. Looks like QB is not an efficient way with IBAs.
Anyway having right type definition was the key in Query Builder to show up IBAs. Thanks Ayyappan
I have Latest Rev and Latest Iteration in place. I have same set of sub-select one you shown in other email. Criteria (Sub select) brought down time to 1 min for 6045 records. Actually Criteria given me right set of records than reducing time much.
The moment I added IBAs, I am nowhere getting the result.
Recommend incrementally building then (which is what I always end up doing).
Delete Library from the query. Leave Iteration / Revision criteria Add a criteria for a single CAD Doc Number Remove everything from Select except CAD Doc Number - make sure it works Add to Select one IBA at a time
Sometimes I create a ½ dozen reports, each with just part of the query and get each working, then combine them gradually. Maddening but most of the reports have been super useful once we've gotten to work.