how to search for 'instances' only?

[volenin]

Hi. I'm trying to setup a search filter that will include only _instances_ of the entities (ie, Objects, Node Instance, Component Instance, etc), rather than 'prototypes'. Can't figure out which field to use for that.. Must be definitely doable through SQL...

[qwerty]

Not that easy. Classes appear as Object, Activities as Action with classifier, Nodes as Nodes with classifier. You need to construct a SQL like

Code: [Select]

SELECT * FROM t_object WHERE Object_Type = 'Object' OR (Object_Type in ('Node', 'Action') AND NOT Classifier_GUID IS NULL) You need to find out the rest of your element/object conditions.

q.

[volenin]

Thanks, qwerty. Just figured it out. Once co-worker of mine mentioned that EAP files can be opened in the MS Access as a DB file, the rest was a breeze.

For anyone interested, here is the query that works with Relationship Matrix (to select instances of any object types):

SELECT ea_guid AS CLASSGUID, Object_Type AS CLASSTYPE, Name FROM t_object where classifier <> 0