Skip to main content

Visual Mode

Visual mode is a no-code feature to create datasets. It is designed to enhance productivity and simplify SQL querying tasks. A rich set of visual options are available to let you search and select columns, apply filters and add parameters to your data.

Learn How to Use Visual Mode​

Columns​

  • Click the Columns option to see the columns of the selected table.
visual mode
  • By default, it contains all of the columns of the selected table. By selecting and deselecting the columns list checkbox, you can add and remove columns.
visual mode

Filter​

  • To filter data in the Visual Mode, click on the +Filter button. This will invoke the Filter Editor dialogue, which allows you to build filter criteria.
filter in visual Modes

In the invoked popup, you can choose the following options-

visual Modes

  • From the dropdown Select Field menu, choose the column whose value you want to use to filter data.

  • From the dropdown Select Operator menu, select the operator that satisfies a selection condition

  • Enter a Value

  • You can use Convert to Params feature to set parameters for filter values.

  • Click Save

Add New Filter​

value

  • Filters are cumulative, which means you can apply multiple filters to help narrow down your results. Click the Add New to add another filter

  • You can modify the result by editing and deleting the existing filters

Naming Dataset​

Give a meaningful name to the dataset and then click the Continue button for further transformation

Naming Dataset

Test & Save​

Click the Test & Save to save the dataset

Test and Save

Any Question? 🤓​

We are always an email away to help you resolve your queries. If you need any help, write to us at - 📧 support@boltic.io