Absolutely,
1.Horizontal and vertical grouping refer to how OR conditions and columns are displayed in the Query and Diagram tabs.
Horizontal grouping displays conditions joined by OR for the same field on a single row, providing a more compact and readable layout.
Example:
WHERE ((Column1) AND (Column2))
OR ((Column1) AND (Column2))
OR ((Column1) AND (Column2))
In the Diagram tab:
The first set of conditions is displayed in the Where row.
The second set of conditions is displayed in the first OR row.
The third set of conditions is displayed in the second OR row.
Vertical grouping displays each OR condition group on a separate line or in a distinct block.
Example:
WHERE (
(Column1)
AND (Column2)
)
OR (
(Column1)
AND (Column2)
)
OR (
(Column1)
AND (Column2)
)
In this example, each group of conditions connected by OR is displayed in its own block, resulting in a vertical layout.
2.As mentioned in the previous post, the Convert Where/Or Grouping button was introduced for Query Builder files created in versions prior to Toad Data Point 6.3 to maintain backward compatibility.
When selected, the following message is displayed:
"Convert to new Query Builder diagram? The Where clause conditions from the Diagram tab will be moved to Global Where. This change will be irreversible after the Query Builder file is saved."
Users can choose:
OK to proceed with the conversion.
Cancel to keep the existing layout.
3.Changes to the Field Settings area primarily affect the layout and ordering of fields, resulting in improved organization and usability.
4.The Sort option has been changed from a radio button control to a combo box while retaining the same available sorting options. This change provides better visual clarity and a more streamlined user interface.
With this enhancement, users can define multiple OR conditions for the same column while benefiting from a cleaner, more intuitive, and visually organized Field Settings area in the Query Builder Diagram tab.
