215 Filter / Sort / Project Data 217 Add Custom Fields 219 Chart 220 About Chart 220 Build Chart 221 Filter / Sort Data 223 Apply Aggregate Function 224 Add Range 225 Set Value Pivot Table 254 Control 256 DateTime Formats 257 Dashboard 258 About Dashboard 258 Build Dashboard 259 Add Pages 259 Add Charts 260 Add Text Labels 260 Add Images 261 Add Shapes data of the view. Show the Query Plan of the view. 53 Stop the preview process. Build the view visually. It allows you to create and edit views without knowledge of SQL. See Query Builder

209 Filter / Sort / Project Data 211 Add Custom Fields 213 Chart 214 About Chart 214 Build Chart 215 Filter / Sort Data 217 Apply Aggregate Function 218 Add Range 219 Set Value Pivot Table 248 Control 250 DateTime Formats 251 Dashboard 252 About Dashboard 252 Build Dashboard 253 Add Pages 254 Add Charts 254 Add Text Labels 255 Add Images 255 Add Shapes Preview the data of the view. 54 Explain Show the Query Plan of the view. View Builder Build the view visually. It allows you to create and edit views without knowledge of SQL. See Query Builder

209 Filter / Sort / Project Data 211 Add Custom Fields 213 Chart 214 About Chart 214 Build Chart 215 Filter / Sort Data 217 Apply Aggregate Function 218 Add Range 219 Set Value Pivot Table 248 Control 250 DateTime Formats 251 Dashboard 252 About Dashboard 252 Build Dashboard 253 Add Pages 253 Add Charts 254 Add Text Labels 254 Add Images 255 Add Shapes Preview Preview the data of the view. Explain Show the Query Plan of the view. View Builder Build the view visually. It allows you to create and edit views without knowledge of SQL. See Query Builder

Designer is the basic Navicat Data Modeler tool for working with views. In View Designer, you can build the views visually using View Builder or edit the view's Definition directly. Note: The tabs and columns it is on. By clicking the button, you will be switched to a subquery 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 code-completion, sql formatting, and more. Hint: SELECT statement will be automatically generated while you build in View Builder. Beautify SQL (Available only in Non-Essentials Version) To format messy SQL code

Designer is the basic Navicat Data Modeler tool for working with views. In View Designer, you can build the views visually using View Builder or edit the view definition in SQL Editor directly. Note: columns it is on. By clicking the button, you will be switched to a subquery 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 code-completion, sql formatting, and more. Hint: SELECT statement will be automatically generated while you build in View Builder. Beautify SQL (Available only in Non-Essentials Version) To format messy SQL code

Filter / Sort / Project Data 54 Add Custom Fields 55 Chapter 6 - Chart 58 About Chart 58 Build Chart 59 Filter / Sort Data 60 Apply Aggregate Function 61 Add Range 62 Set Value Operation Table 92 Control 94 DateTime Formats 95 Chapter 7 - Dashboard 96 About Dashboard 96 Build Dashboard 96 Add Pages 97 3 Add Charts 98 Add Text Labels 98 Add Images 99 Add controls that you can use to manipulate the data. Design Pane The Design pane allows you to build the data source visually. Navicat Charts Creator provides two modes for connecting your data: Live

Filter / Sort / Project Data 52 Add Custom Fields 54 Chapter 6 - Chart 56 About Chart 56 Build Chart 57 Filter / Sort Data 58 Apply Aggregate Function 59 Add Range 60 Set Value Operation Table 90 Control 92 DateTime Formats 93 Chapter 7 - Dashboard 94 About Dashboard 94 Build Dashboard 94 Add Pages 95 3 Add Charts 96 Add Text Labels 96 Add Images 97 Add controls that you can use to manipulate the data. Design Pane The Design pane allows you to build the data source visually. Navicat Charts Creator provides two modes for connecting your data: Live

Filter / Sort / Project Data 52 Add Custom Fields 54 Chapter 6 - Chart 57 About Chart 57 Build Chart 58 Filter / Sort Data 59 Apply Aggregate Function 60 Add Range 61 Set Value Operation Table 91 Control 93 DateTime Formats 94 Chapter 7 - Dashboard 95 About Dashboard 95 Build Dashboard 95 Add Pages 96 3 Add Charts 97 Add Text Labels 97 Add Images 98 Add controls that you can use to manipulate the data. Design Pane The Design pane allows you to build the data source visually. Navicat Charts Creator provides two modes for connecting your data: Live

House Keeping in Advanced Configurations. You can control the build retention policy for logs by specifying both the Maximum Size of Each Build and the Maximum No. of Builds to Keep. Backup / Migration