INPUT BOX¶

---

Steps to Add a Input Box Panel¶

Select Input Box from the Add Panel options and click Submit.

A List Box panel will appear on the Dashboard.

Click the Pencil Icon to open a configuration tab with various fields for customization.

General¶

The General tab allows you to configure the basic appearance and properties of the List Box. This tab is selected by default.

• Title: The panel's name is displayed as the panel name on the dashboard by default, but users can modify it.
• Table Name: Select a table from the dropdown menu. The list is populated based on the selected database connection.
• Field Name: Field names are fetched from the selected table. Choose a specific field to display as list options.
• Label Name: By default, the field name is used as the label name, but users can change it if necessary.
• Order By Type: Define the sorting order for the list options (e.g., ascending or descending).

Submit: Click Submit to save the general settings.

If user wants to set a condition to filter the data in the list click on the pencil icon and click on the condition tab

Condition¶

The Condition tab is used to filter the list data by applying specific conditions using various operators.

• Template condition: Enter a custom condition in the text box (e.g., name == 'Gil-Lamb').
  • Operators: Use the following operators to build conditions
    • Arithmetic Operators: +, -, *, /
    • Comparison Operators: ==, <, >, <=, >=, !=
    • Logical Operators: AND, OR, NOT
    • Parentheses: Use ( ) to group expressions.
  • Clear Button: Reset the condition input box.
• Select Table: The table selected in the General tab will be displayed here.
  • Selected Table Field Names: Choose the field name selected in the General tab.
• Submit: Apply conditions to filter the dataset.

Note: Enclose all conditions in single quotes.At once only one condition can be given

RAW Query¶

The Raw Query tab allows users to define both conditions and expressions directly using SQL-like syntax.

Note: User can refer condition tab to use the raw query.

• SQL Query: In the Text box field Enter custom condition.
  • Operators: Use the same operators as in the Condition tab
    • Arithmetic Operators: +, -, *, /
    • Comparison Operators: ==, <, >, <=, >=, !=
    • Logical Operators: AND, OR, NOT
    • Parentheses: Use ( ) to group conditions.
    • Apply Filters: Whenever users are using a raw query, and if there is a WHERE clause in the query, {apply_filters} should be added.
  • Clear Button: Click on Clear to Clear the SQL query input box.
• Select Table: Whatever table is selected in general tab the same will be displayed here.
  • Selected Table Field Names: Select the field name which was selected in the field name section in the general tab.
• Submit: Execute the query and update the dataset.

Once the Raw Query is submitted, the panel will reflect the updated dataset.

Note: Enclose all conditions in single quotes.

Note: User can write sql query in raw query.The query provided in the raw query should be optimized based on the database structure.