Retrieve all requirements in a eap file

[jepessen]

I'm creating an external C# application for synchronizing EA requirements with an external tool.

I need to retrieve all requirements that are defined in packages. Since project structure is not defined I cannot read specific packages.

How can retrieve all requirements from a EA project?

Code: [Select]

var repository = new EA.Repository();
fileOpened = repository.OpenFile(filePath);
// Project is opened here

// This works
var edition = repository.EAEdition;

// Retrieve list of requirements
var requirements = repository.???;


[Geert Bellekens]

use Repository.GetElementSet(sqlQuery, 2)

Geert

[jepessen]

I don't know which query should I use, so I've tested a bit and I've used this method that returns everything:

var data = repository.GetElementSet("", 0);

I obtain a bunch of objects, that probably are all objects in the Project Browser.

I've seen that requirements have a Metatype of type "Requirement". I can cycle all of them, control this field and make operation just if a requirement is found, but maybe it's better to retrieve only requirements with the query.

What query should I use in order to retrieve only objects with specific metatype?

[Geert Bellekens]

You should really learn the database as a add-in/script developer. That is as important as getting to know the API.

In your case the query is

Code: [Select]

select o.Object_ID from t_object o where o.Object_Type = 'Requirement'
Geert

[jepessen]

Ok I'll try to learn it. Thanks for the query, it works...