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 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