Products

Home Forums eaDocX queries SQL Query in Excel does not work SQL Query in Excel does not work

Home Forums eaDocX queries SQL Query in Excel does not work SQL Query in Excel does not work

#7101
David
Participant

It seems like the SQL query does work in Excel if you do the following:

1) Put t_object.ea_guid AS CLASSGUID, as the first statement in the SQL SELECT
1.1) The ‘AS’ must be capital letters. A lower case ‘as’ will not work.
2) Only use the ea_guid out of the t_object table. It does not seem to work on other tables.

Compare licence prices

Choose the licence that’s right for you and your team

Prices

Download a free trial

Download eaTeamWorks today for several free for life features, plus no obligation, 30-day trials of all the products: eaDocX, ea Revision Manager, eaSheets, Model Expert and PortfolioManager. Discover for yourself why we sell the world’s best-selling Enterprise Architect extension.

Download