Using SQL Search Results

[tomp]

Can anyone tell me how to export the results from custom SQL searches performed using the Advance search functionlity in EA?

I have created a search (probably the first of many) and want to be able to export the results to word, excel or whatever, but there appears to be no option to do this. Am I missing something?

Cheers
Tom

[Aaron B]

Hello Tom,

Unfortunately there are no options to export search results at the present time, apart from generating an RTF report (right-click of search results and see "RTF Report" sub-menu).

However, you could use the Repository.GetElementsByQuery method from the Automation Interface to retrieve the search results and then output to any format you wish.  Using this method it would probably be quite simple to export to CSV for example.
http://www.sparxsystems.com.au/EAUserGuide/repository3.htm

HTH

[thomaskilian]

Alternatively execute the SQL directly on the database (using DAO, ADO or whatsoever).

[tomp]

Thanks for the responses. I went for the SQL against the database in the end as I do not have budget to develop an automation control (however simple - PM has purse strings...) and I could not seem to work out the RTF. When the search is run the right click menu is has no RTF options on it, this only appears in the report view and I couldn't see the connection. As such I used what I knew and accessed the database directly as I only wanted to copy the data into a word doc.

Cheers
Tom


***
The abilty to copy and paste these results would  be greatly appreciated though, also exposing more or all the tables would help (I was looking at connections whch are not identified in the table list for the advanced sql search)