IBAs Query Builder select tab

[arajagopal]

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.

Thanks
Ayyappan Rajagopal

[SimonHeath]

Dear Ayyappan,

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.

BR
Simon

[arajagopal]

Simon
Great.

I should have put my question in detail.

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

Thanks
Ayyappan

Sent from my BlackBerry 10 smartphone.

[jessh]

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.

--
Jess Holle

[arajagopal]

Shreyas,

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

[jessh]

What did your query look like in QueryBuilder?

QueryBuilder does very little "magic" with IBA's -- it essentially
produces the SQL you ask for.

[arajagopal]

Jess,

I always avoid writing QB. I have given one more attempt 🙂

Here is the screen capture.

[cid:image001.png@01CF5EFB.00430C30]

[cid:image002.png@01CF5EFB.00430C30]


[cid:image003.png@01CF5EFB.00430C30]

This QB run against a Library context (w/o IBAs) in a min and retrieves 6045 latest CAD Documents. Same QB runs forever with three IBAs.

I can't get you SQL scripts. "View as a SQL" option is not enabled.

Thanks
Ayyappan

[MikeLockwood]

Criteria for Latest Rev and Latest Iteration will help greatly.

[arajagopal]

Mike,

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.

Thanks
Ayyappan

[MikeLockwood]

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.