View Source

<ac:layout><ac:layout-section ac:type="single"><ac:layout-cell>How the Visual SQL Query Builder works in 10.1.5 - embedded in Data Explorer, auto-populated schema, no separate connection step.<ac:link><ri:page ri:content-title="Technical Reference" /><ac:plain-text-link-body><![CDATA[Reference]]></ac:plain-text-link-body></ac:link> → <ac:link><ri:page ri:content-title="Platform Modules Reference" /><ac:plain-text-link-body><![CDATA[Modules]]></ac:plain-text-link-body></ac:link> → <ac:link><ri:page ri:content-title="Datasets Module Reference" /><ac:plain-text-link-body><![CDATA[Datasets]]></ac:plain-text-link-body></ac:link> → <ac:link><ri:page ri:content-title="Datasets Designer UI Reference" /><ac:plain-text-link-body><![CDATA[UI]]></ac:plain-text-link-body></ac:link> → <ac:link><ri:page ri:content-title="Datasets DBs Reference" /><ac:plain-text-link-body><![CDATA[DBs]]></ac:plain-text-link-body></ac:link> → <ac:link><ri:page ri:content-title="Visual SQL Query Builder Reference" /><ac:plain-text-link-body><![CDATA[Query Builder]]></ac:plain-text-link-body></ac:link> → Visual SQL Query Builder (10.1.5 draft)<hr /></ac:layout-cell></ac:layout-section><ac:layout-section ac:type="single"><ac:layout-cell><ac:structured-macro ac:name="info" ac:schema-version="1"><ac:rich-text-body>10.1.5 preview - work in progress. This page tracks the changes coming in FrameworX 10.1.5. The <ac:link><ri:page ri:content-title="Visual SQL Query Builder Reference" /><ac:plain-text-link-body><![CDATA[parent page]]></ac:plain-text-link-body></ac:link> describes the 10.1.4 behavior, which remains correct for current customers. Do not implement against the 10.1.5 model in this page until the release ships.</ac:rich-text-body></ac:structured-macro></ac:layout-cell></ac:layout-section><ac:layout-section ac:type="two_equal"><ac:layout-cell>In 10.1.5 the Visual Query Builder moves from a separate window into the Data Explorer workspace. The schema tree populates automatically from the configured Dataset DB - no Connect button, no second connection string. The visual canvas, column grid, and live SQL preview remain familiar to anyone who used the 10.1.4 builder.</ac:layout-cell><ac:layout-cell><ac:structured-macro ac:name="toc" ac:schema-version="1"><ac:parameter ac:name="maxLevel">3</ac:parameter><ac:parameter ac:name="style">none</ac:parameter></ac:structured-macro></ac:layout-cell></ac:layout-section><ac:layout-section ac:type="single"><ac:layout-cell><hr /><h2>What is new in 10.1.5</h2><ul><li>Embedded inside Data Explorer. The builder lives as a sub-tab of Data Explorer / SQL Queries, alongside Query Execution. No separate window.</li><li>Auto-populated schema. When you click the Visual Query Builder sub-tab, the schema tree fills automatically from the Dataset DB selected in the parent SQL Queries page. No Connect dialog, no provider picker, no second connection string to maintain.</li><li>One connection, not two. The 10.1.4 builder asked for its own database connection separate from the Designer's Dataset DBs. In 10.1.5 the builder reads metadata through FrameworX's own data-access layer, so the DB you already configured in Datasets / DBs is the only place a connection is defined.</li><li>Theme-aware chrome. Builder colors follow the active Designer theme - Light, Dark, and the rest of the FrameworX theme palette - rather than carrying a fixed look.</li><li>Live SQL preview. The generated SQL appears in a read-only text pane below the visual canvas. Same real-time behavior as 10.1.4, just laid out vertically inside the embedded tab.</li></ul></ac:layout-cell></ac:layout-section><ac:layout-section ac:type="single"><ac:layout-cell><hr /><h2>How to open it</h2><ol><li>Open the Designer on your solution.</li><li>Navigate to Data Explorer / SQL Queries.</li><li>Pick the Dataset DB you want to query in the Selected Database area at the top of the page.</li><li>Click the Visual Query Builder sub-tab.</li></ol>The schema tree on the left populates with the tables and columns of the selected Dataset DB. Drag tables onto the canvas, draw joins between them, and the generated SQL updates live in the read-only pane underneath.</ac:layout-cell></ac:layout-section><ac:layout-section ac:type="single"><ac:layout-cell><hr /><h2>Behavioral changes from 10.1.4</h2><table><tbody><tr><th>Aspect</th><th>10.1.4</th><th>10.1.5</th></tr><tr><td>Where it runs</td><td>Separate window, opened by a button on Datasets / DBs</td><td>Embedded sub-tab of Data Explorer / SQL Queries</td></tr><tr><td>Database connection</td><td>Builder maintains its own connection string and provider picker</td><td>Reads metadata from the Dataset DB already configured in the solution</td></tr><tr><td>Initial action</td><td>Click Connect, choose provider, enter data source path</td><td>Click the sub-tab; schema appears automatically</td></tr><tr><td>Theme</td><td>Fixed look, independent of Designer theme</td><td>Follows the active Designer theme</td></tr><tr><td>SQL output</td><td>Generated SQL inside the builder window</td><td>Read-only SQL preview pane below the canvas in the embedded tab</td></tr></tbody></table>The visual canvas, column grid (Visible, Expression, Column Name, Sort Type, Sort Order, Aggregate, Grouping, Criteria, Or), and join semantics are unchanged from 10.1.4 - if you know the older builder, the working surface is the same.</ac:layout-cell></ac:layout-section><ac:layout-section ac:type="single"><ac:layout-cell><hr /><h2>Customizing queries with tag substitution</h2>The 10.1.4 pattern of using Client tags inside SQLStatement and WhereCondition still applies in 10.1.5 unchanged - see the <ac:link><ri:page ri:content-title="Visual SQL Query Builder Reference" /><ac:plain-text-link-body><![CDATA[parent reference page]]></ac:plain-text-link-body></ac:link> for the full description and examples. Nothing about tag substitution, SelectCommand, or the synchronized-property model changed in 10.1.5.</ac:layout-cell></ac:layout-section><ac:layout-section ac:type="single"><ac:layout-cell><hr /><h2>Preview limitations</h2>The 10.1.5 preview build has the following known limitations. They are tracked for the GA release.<ul><li>The schema tree initially loads a small fixed sample (Customers, Orders, Products) for end-to-end smoke testing. Real per-Dataset-DB schema discovery using the FrameworX Ado API replaces the sample before GA.</li><li>Some inner builder chrome (the docking panel header strip) keeps a fixed navy palette that does not flip under Dark themes. The query canvas and join lines do follow the theme correctly. The docking panel theming lands in a follow-up update.</li><li>Mid-session theme switches refresh the join-line colors live; some surrounding chrome may need the sub-tab to be reactivated to fully repaint.</li></ul></ac:layout-cell></ac:layout-section><ac:layout-section ac:type="single"><ac:layout-cell><hr /><h4>In this section...</h4><ac:structured-macro ac:name="pagetree" ac:schema-version="1"><ac:parameter ac:name="root"><ac:link><ri:page ri:content-title="@parent" /></ac:link></ac:parameter></ac:structured-macro><hr /></ac:layout-cell></ac:layout-section></ac:layout>