eaDocX
High quality smart documents - fast
eaSheets
Spreadsheet tools for EA modelers
ea Revision Manager
Round-trip model updates direct from document reviews
Model Expert
AI enhanced quality validation & verification
Portfolio Manager
Plan and collaborate real-time across projects
Sparx in the Cloud
Model EA in your browser
eaDocX
High quality smart documents - fast
eaSheets
Spreadsheet tools for EA modelers
ea Revision Manager
Round-trip model updates direct from document reviews
Model Expert
AI enhanced quality validation & verification
Portfolio Manager
Plan and collaborate real-time across projects
Sparx in the Cloud
Model EA in your browser
Home › Forums › eaDocX queries › How do I put SQL query results in my document? › Re: How do I put SQL query results in my document?
Home › Forums › eaDocX queries › How do I put SQL query results in my document? › Re: How do I put SQL query results in my document?
In the installed help, I did a search on Repository Class. The RunModelSearch and SQL Query are documented.
RunModelSearch is passed in 4 arguments. The fourth argument is an XML format. The results of the model search are put in the XML format. If the fourth argument is an empty xml format, the results are populated in the xml format.
There are also JScript and VBasic script examples of the RunModelSearch. It looks like the example script only returns an element ID. My SQL queries return the names of the elements I want in my table. I am in the process of figuring out how to send the XML file results into an RTF file.
Download eaTeamWorks today for free for life features, plus no obligation, 30-day trials of all the products: eaDocX, Revision Manager, eaSheets, Model Expert and PortfolioManager. Discover for yourself why eaTeamWorks is the world’s best-selling Enterprise Architect extension.
Download