Chapter 7 - Query 111 About Query 111 RDBMS 112 Query Editor 112 Query Builder (Available only in Non-Essentials Edition) 116 Query Parameters 122 Debug Oracle Query (Available only Query Results 122 MongoDB 123 Query Editor 123 Find Builder (Available only in Non-Essentials Edition) 126 Aggregate Builder (Available only in Non-Essentials Edition) 127 Query Results Results 128 Redis 128 Query Editor 128 Query Results 132 Code Snippets (Available only in Non-Essentials Edition) 133 Chapter 8 - Model (Available only in Navicat Premium and Enterprise Edition)

Chapter 7 - Query 109 About Query 109 RDBMS 110 Query Editor 110 Query Builder (Available only in Non-Essentials Edition) 114 Query Parameters 120 Debug Oracle Query (Available only Query Results 120 MongoDB 121 Query Editor 121 Find Builder (Available only in Non-Essentials Edition) 125 Aggregate Builder (Available only in Non-Essentials Edition) 126 Query Results Results 126 Redis 127 Query Editor 127 Query Results 130 Code Snippets (Available only in Non-Essentials Edition) 131 Chapter 8 - Model (Available only in Navicat Premium and Enterprise Edition)

Chapter 7 - Query 108 About Query 108 RDBMS 109 Query Editor 109 Query Builder (Available only in Non-Essentials Edition) 113 Query Parameters 119 Debug Oracle Query (Available only Query Results 119 MongoDB 120 Query Editor 120 Find Builder (Available only in Non-Essentials Edition) 124 Aggregate Builder (Available only in Non-Essentials Edition) 125 Query Results Results 125 Redis 126 Query Editor 126 Query Results 129 Code Snippets (Available only in Non-Essentials Edition) 129 Chapter 8 - Model (Available only in Navicat Premium and Enterprise Edition)

Table 42 Adjust Field Structures 42 Preview Data 42 Start Import 43 Add Query 43 Query Editor 43 Query Builder 46 Modify Data Source Connections 52 View Data 53 Filter / Sort / Refresh Data to view the data. Add Query to Database Connection For database connections, you can save query results to create a new dataset. To create a new query 1. On the Connections pane, double-click New Data Source Query. 2. Write the statement in Query Editor. You can also use Query Builder to build the query visually. 3. Click Save Query. 4. Enter the name of the query and click Save.

Table 40 Adjust Field Structures 40 Preview Data 40 Start Import 41 Add Query 41 Query Editor 41 Query Builder 45 Modify Data Source Connections 50 View Data 51 Filter / Sort / Refresh Data to view the data. Add Query to Database Connection For database connections, you can save query results to create a new dataset. To create a new query 1. On the Connections pane, double-click New Data Source Query. 2. Write the statement in Query Editor. You can also use Query Builder to build the query visually. 3. Click Save Query. 4. Enter the name of the query and click Save.

Table 40 Adjust Field Structures 41 Preview Data 41 Start Import 42 Add Query 42 Query Editor 42 Query Builder 45 Modify Data Source Connections 51 View Data 52 Filter / Sort / Refresh Data to view the data. Add Query to Database Connection For database connections, you can save query results to create a new dataset. To create a new query 1. On the Connections pane, double-click New Data Source Query. 2. Write the statement in Query Editor. You can also use Query Builder to build the query visually. 3. Click Save Query. 4. Enter the name of the query and click Save.

units storage Basic Plan and a 5000 units storage Pro Plan, and each entity (i.e. a connection, a query, a snippet, a model, a Charts workspace or a virtual group) occupies one unit. If the storage limit account. View Usage Each user comes with 5000 units storage, and each entity (i.e. a connection, a query, a snippet, a model, a Charts workspace or a virtual group) occupies one unit. If the storage multiple objects is supported. Note: If you move or copy a connection to another project, all its query files and virtual groups will also be moved or copied. To preview an object 1. Select an object

layer where you can build it visually in the same way as the main query. You can always go back to the main query by clicking (Main Query). View Generated SQL The SQL pane presents a read-only, formatted php . 3. If your server installed a Web Application Firewall, you can check the Encode outgoing query with base64 option. 4. If the tunneling script is hosted in a password protected server or you

layer where you can build it visually in the same way as the main query. You can always go back to the main query by clicking (Main Query). View Generated SQL 37 The SQL pane presents a read-only details. 4. If your server installed a Web Application Firewall, you can check the Encode outgoing query with base64 option. 5. If you have to access internet over a proxy server, click the Proxy Settings