Option Description. Highlight All Highlight all matches in the editor. Incremental Search Find matched text for the search string as each character is typed. Match Case Enable case sensitive search. Regular Expression Search regular expressions. Whole Word Return the objects that match the entire word of the search string. Click the Replace All button to replace all occurrences automatically. There are some additional options for Find and Replace, click : Navicat Data Modeler has the ability to zoom in or zoom out the SQL in the editor. Zoom In: [CTRL++] or [CTRL+Mousewheel Up] Zoom out: [CTRL+-] or [CTRL+Mousewheel Down] Reset: [CTRL+0] View Builder (Available only in Enterprise Edition) Navicat Data Modeler provides a useful tool called View Builder for building views visually. It allows you to create and edit views without knowledge of SQL. Even if you are familiar with SQL, the convenient and fluent graphical interface makes it easier to create relations and visualize the view. In View Designer, click the View Builder button to open the visual View Builder. All database objects are displayed on the left Object pane. Whereas on the middle pane, it is divided into two portions: the upper Diagram pane, and the lower Criteria pane. When building the view, you can view the auto-generated SQL on the right SQL pane. The first step is to decide which tables and views you need to add to the view. To add tables and views to the view, use one of the following methods: • Drag them from the Object pane to the Diagram pane. • Double-click them on the Object pane. You can set aliases for tables, views and subqueries by double-clicking the object title on the Diagram pane and entering the name to use as an alias for the object name. After you have added objects to the diagram, you can use the FROM tab to adjust the view to your needs. • To change the object, click the object and select an identifier. • To add the table alias, click <Alias>. You can right-click an object on the Diagram pane and select Remove, or simply press DELETE key to remove the selected object from the view. When you remove an object, View Builder automatically removes joins that involve that object. To include fields in the view, use one of the following methods: • Check the left checkbox of a field name you want to add to the view on the Diagram pane. • To include all the fields for an object, check the * checkbox on the Diagram pane. • To add all fields for all objects, click on the SELECT tab and select All fields(*). The selected fields display on the SELECT tab. You can specify additional output field options. • Check the DISTINCT checkbox to force the view to return distinct results. • To add the field alias, click <Xxxxx> and enter the name. • Click the identifier and select the Aggregate function. • Use the up arrow and down arrow buttons to change the order of fields. View Builder will automatically join the tables as per the foreign key relations. If you want to associate database objects manually, just select a field from an object and drag it to a field in another object. A connector line appears between the two objects to visually represent the relationship and the join type. There are two views to show the connector lines: Table Relation and Field Relation. The Field Relation view allows you to identify matching fields in two tables, while the Table Relation view displays the join relationship between the two tables. All joins are initially created as INNER JOIN by default. To change the association, click or double-click the connector line on the Diagram pane or click the JOIN keyword on the FROM tab, and then select a join type. If a join type is not listed, you can enter a customized one in the Custom textbox. To remove a join, right-click the connector line and select Remove. To modify the join condition, right-click a connector line and select Edit Join, or click the condition on the FROM tab. The pop-up menu options of the FROM tab: Insert Add an identifier, an expression or a subquery. Insert Bracket Add a pair of parentheses. Remove Remove the identifier, expression or subquery. Clear and Convert to USING Clause Remove the ON condition and convert it to USING clause. Clear and Convert to ON Clause Remove the USING condition and convert it to ON clause. Group with Bracket Add parentheses to group the selected conditions. Ungroup Remove the parentheses. 33 When retrieving data, you may want to set up a filtering expression. To filter data returned by the view, right-click a field on the Diagram pane and select Add Field To -> WHERE and an operator. The condition is added to the WHERE tab. You can edit the value there by clicking <Value>. If you want to add a condition with parentheses, click . You can change a logical operator (and/or) by clicking it. Use the up arrow and down arrow buttons to change the order of conditions. The pop-up menu options of the WHERE tab: Toggle Negator Reverse the meaning of the condition. Insert Add a condition. Insert Custom Add a custom condition. Insert Bracket Add a pair of parentheses. Remove Remove the condition. Group with Bracket Add parentheses to group the selected conditions. Ungroup Remove the parentheses. You can set the conditions for grouping records by right-clicking a field in the Diagram pane and selecting Add Field To
Appears in 2 contracts
Samples: User Manual, User Manual
Option Description. Highlight All Highlight all matches in the editor. Incremental Search Find matched text for the search string as each character is typed. Match Case Enable case sensitive search. Regular Expression Search regular expressions. Whole Word Return the objects that match the entire word of the search string. Click the Replace All button to replace all occurrences automatically. There are some additional options for Find and Replace, click : Navicat Data Modeler has the ability to zoom in or zoom out the SQL in the editor. Zoom In: [CTRL++] or [CTRL+Mousewheel Up] Zoom out: [CTRL+-] or [CTRL+Mousewheel Down] Reset: [CTRL+0] View Builder (Available only in Enterprise Edition) Navicat Data Modeler provides a useful tool called View Builder for building views visually. It allows you to create and edit views without knowledge of SQL. Even if you are familiar with SQL, the convenient and fluent graphical interface makes it easier to create relations and visualize the view. In View Designer, click the View Builder button to open the visual View Builder. All database objects are displayed on the left Object pane. Whereas on the middle pane, it is divided into two portions: the upper Diagram pane, and the lower Criteria pane. When building the view, you can view the auto-generated SQL on the right SQL pane. The first step is to decide which tables and views you need to add to the view. To add tables and views to the view, use one of the following methods: • Drag them from the Object pane to the Diagram pane. • Double-click them on the Object pane. You can set aliases for tables, views and subqueries by double-clicking the object title on the Diagram pane and entering the name to use as an alias for the object name. After you have added objects to the diagram, you can use the FROM tab to adjust the view to your needs. • To change the object, click the object and select an identifier. • To add the table alias, click <Alias>. You can right-click an object on the Diagram pane and select Remove, or simply press DELETE key to remove the selected object from the view. When you remove an object, View Builder automatically removes joins that involve that object. To include fields in the view, use one of the following methods: • Check the left checkbox of a field name you want to add to the view on the Diagram pane. • To include all the fields for an object, check the * checkbox on the Diagram pane. • To add all fields for all objects, click on the SELECT tab and select All fields(*). The selected fields display on the SELECT tab. You can specify additional output field options. • Check the DISTINCT checkbox to force the view to return distinct results. • To add the field alias, click <Xxxxx> and enter the name. • Click the identifier and select the Aggregate function. • Use the up arrow and down arrow buttons to change the order of fields. View Builder will automatically join the tables as per the foreign key relations. If you want to associate database objects manually, just select a field from an object and drag it to a field in another object. A connector line appears between the two objects to visually represent the relationship and the join type. There are two views to show the connector lines: Table Relation and Field Relation. The Field Relation view allows you to identify matching fields in two tables, while the Table Relation view displays the join relationship between the two tables. All joins are initially created as INNER JOIN by default. To change the association, click or double-click the connector line on the Diagram pane or click the JOIN keyword on the FROM tab, and then select a join type. If a join type is not listed, you can enter a customized one in the Custom textbox. To remove a join, right-click the connector line and select Remove. To modify the join condition, right-click a connector line and select Edit Join, or click the condition on the FROM tab. The pop-up menu options of the FROM tab: Insert Add an identifier, an expression or a subquery. Insert Bracket Add a pair of parentheses. Remove Remove the identifier, expression or subquery. Clear and Convert to USING Clause Remove the ON condition and convert it to USING clause. Clear and Convert to ON Clause Remove the USING condition and convert it to ON clause. Group with Bracket Add parentheses to group the selected conditions. Ungroup Remove the parentheses. 33 When retrieving data, you may want to set up a filtering expression. To filter data returned by the view, right-click a field on the Diagram pane and select Add Field To -> WHERE and an operator. The condition is added to the WHERE tab. You can edit the value there by clicking <Value>. If you want to add a condition with parentheses, click . You can change a logical operator (and/or) by clicking it. Use the up arrow and down arrow buttons to change the order of conditions. The pop-up menu options of the WHERE tab: Toggle Negator Reverse the meaning of the condition. Insert Add a condition. Insert Custom Add a custom condition. Insert Bracket Add a pair of parentheses. Remove Remove the condition. Group with Bracket Add parentheses to group the selected conditions. Ungroup Remove the parentheses. You can set the conditions for grouping records by right-clicking a field in the Diagram pane and selecting Add Field To
Appears in 2 contracts
Samples: User Manual, User Manual
Option Description. Highlight All Highlight all matches in the editor. Incremental Search Find matched text for the search string as each character is typed. Match Case Enable case sensitive search. Regular Expression Search regular expressions. Whole Word Return the objects that match the entire word of the search string. Click the Replace All button to replace all occurrences automatically. There are some additional options for Find and Replace, click : Navicat Data Modeler BI has the ability to zoom in or zoom out the SQL in the editor. Keyboard shortcuts are: Zoom In: [CTRL++] or [CTRL+Mousewheel UpCTRL+=] Zoom outOut: [CTRL+-] or [CTRL+Mousewheel Down] Reset: [CTRL+0] View RDBMS - Query Builder (Available only in Enterprise Edition) Navicat Data Modeler BI provides a useful tool called View Query Builder for building views queries visually. It allows you to create and edit views queries without knowledge of SQL. Even if you are familiar with SQL, the convenient and fluent graphical interface makes it easier to create relations and visualize the viewquery. In View Designerthe New Query window, click the View Query Builder button to open the visual View Query Builder. All database objects are displayed on the left Object pane. Whereas on the middle pane, it is divided into two portions: the upper Diagram pane, and the lower Criteria pane. When building the viewquery, you can view the auto-generated SQL query on the right SQL pane. The first step is to decide which tables and views you need to add to the viewquery. To add tables and views to the viewquery, use one of the following methods: • Drag them from the Object pane to the Diagram pane. • Double-click them on the Object pane. You can set aliases for tables, views and subqueries by double-clicking the object title on the Diagram pane and entering the name to use as an alias for the object name. After you have added objects to the diagram, you can use the FROM tab to adjust the view query to your needs. • To change the object, click the object and select an identifier. • To add the table alias, click <Alias>. You can right-click an object on the Diagram pane and select Remove, or simply press DELETE key to remove the selected object from the viewquery. When you remove an object, View Query Builder automatically removes joins that involve that object. To include fields in the viewquery, use one of the following methods: • Check the left checkbox of a field name you want to add to the view query on the Diagram pane. • To include all the fields for an object, check the * checkbox on the Diagram pane. • To add all fields for all objects, click on the SELECT tab and select All fields(*). The selected fields display on the SELECT tab. You can specify additional output field options. • Check the DISTINCT checkbox to force the view query to return distinct results. • To add the field alias, click <Xxxxx> and enter the name. • Click the identifier and select the Aggregate function. • Use the up arrow and down arrow buttons to change the order of fields. View Query Builder will automatically join the tables as per the foreign key relations. If you want to associate database objects manually, just select a field from an object and drag it to a field in another object. A connector line appears between the two objects to visually represent the relationship and the join type. There are two views to show the connector lines: Table Relation and Field Relation. The Field Relation view allows you to identify matching fields in two tables, while the Table Relation view displays the join relationship between the two tables. All joins are initially created as INNER JOIN by default. To change the association, click or double-click the connector line on the Diagram pane or click the JOIN keyword on the FROM tab, and then select a join type. If a join type is not listed, you can enter a customized one in the Custom textbox. To remove a join, right-click the connector line and select Remove. To modify the join condition, right-click a connector line and select Edit Join, or click the condition on the FROM tab. The pop-up menu options of the FROM tab: Insert Add an identifier, an expression or a subquery. Insert Bracket Add a pair of parentheses. Remove Remove the identifier, expression or subquery. Clear and Convert to USING Clause Remove the ON condition and convert it to USING clause. Clear and Convert to ON Clause Remove the USING condition and convert it to ON clause. Group with Bracket Add parentheses to group the selected conditions. Ungroup Remove the parentheses. 33 51 When retrieving data, you may want to set up a filtering expression. To filter data returned by the viewquery, right-click a field on the Diagram pane and select Add Field To -> WHERE and an operator. The condition is added to the WHERE tab. You can edit the value there by clicking <Value>. If you want to add a condition with parentheses, click . You can change a logical operator (and/or) by clicking it. Use the up arrow and down arrow buttons to change the order of conditions. The pop-up menu options of the WHERE tab: Toggle Negator Reverse the meaning of the condition. Insert Add a condition. Insert Custom Add a custom condition. Insert Bracket Add a pair of parentheses. Remove Remove the condition. Group with Bracket Add parentheses to group the selected conditions. Ungroup Remove the parentheses. You can set the conditions for grouping query records by right-clicking a field in the Diagram pane and selecting Add Field ToTo -> GROUP BY. The condition is added to the GROUP BY tab. Use the up arrow and down arrow buttons to change the order of fields. On the HAVING tab, you can filter summarized data or grouped data. Select the identifiers, operators, aggregate or enter expressions to include in the condition. Use the up arrow and down arrow buttons to change the order of conditions. The pop-up menu options of the HAVING tab: Toggle Negator Reverse the meaning of the condition. Insert Add a condition. Insert Custom Add a custom condition. Insert Bracket Add a pair of parentheses. Remove Remove the condition. Group with Bracket Add parentheses to group the selected conditions. Ungroup Remove the parentheses. You can set the way of sorting query records by right-clicking a field on the Diagram pane and selecting Add Field To -> ORDER BY -> ASC or DESC. The condition will be added to the ORDER BY tab. On the LIMIT tab, you can limit your query results to those that fall within a specified range.
Appears in 2 contracts
Samples: End User License Agreement, End User License Agreement
