Search through repository based on type

[sravang]

Hello,

I have a huge repository with many packages and elements. Is there any way I can filter out elements in my repository based on type. I have tried GetElementsByQuery but is not the way I want search because it involves you to create search in sparx ui .I want to filter them out in add-in code. Also is there any way to traverse through repository tree faster. The repository I am working is around 800 mb and it takes me around 2 hours to process through repository. Is there any easier way to traverse repository faster.

Thanks

[Geert Bellekens]

Repository.GetElementSet(myQuery,2)

Geert

[sravang]

Hello,

I have just used basic query to try this out.

         string SQLSearchString = "select Object_Type from t_object";

         logger.DebugFormat("searchtermsql -- {0}", SQLSearchString);


         EA.Collection test;
          test = repository.GetElementSet(SQLSearchString, 2);

When I try to run this I get an error "Item not found in collection" multiple times.

Thanks,

[qwerty]

GetElementSet needs the ObjectID as first in the result row.

q.

[sravang]

Thanks I'll work on it.
Is there any way to traverse through repository in faster way.

Thanks,

[qwerty]

Not really. Using a SQL (like here) is the fastest way. However, GetElementSet fetches the whole EAElement and constructs the object. If you need only certain columns a repository.SQLQuery is even faster.

q.