Manipulating results

Top Area Functions

Figure 1. SQL Result - Top

1. Result History

Figure 2. Result History

Click the executed SQL area and a list of previously executed SQL Lists is displayed. Click List to reexecute the SQL.

2. SQL Expression

When the users click the button, the Expression Input appears in the area below Result History. The users can enter a conditional clause in the Expression Input, run the SQL containing the conditional clause as clicking the button.

Other key features are as follows

Icon	Description
	Displays the history of the expression.
	Reruns the SQL containing the conditional clause.
	Reruns the previous conditional clause.
	Reruns the next conditional clause.

3. Customize Filter

The users can modify the expression of conditional clauses and columns in detail as clicking the button.

Columns tab

Figure 3. Customize Filter - Columns

The users can customize the expression related to columns in detail.

The following is about the main configuration options.

Features	Description
Search	Searches the information by column name.
Visible	Sets whether the column is visible or not.
Pinned	Pins the column's position to the left.
Order	Sets the Order state of the column. (ASC, DESC, NONE)
Criteria	Enters the conditionals associated with the column and Omits the column name.

Custom tab

Figure 4. Customize Filter - Custom

The users can write WHERE and ORDER BY conditional clauses to add to the existing SQL. Conditions are prioritized on the Columns tab.

Context Menu

Figure 5. Result Context Menu

1. Copy

Copy the value of a cell.

2. Advanced Copy

Customize the options to copy the value of a cell.

Advanced Copy

Figure 6. Advanced Copy

The main options are as follows.

Options	Description
Copy Header	Includes the column name in the copy.
Copy Row Number	Includes the Row number in the copy.
Always quote values	Always wraps values in quotes.
Column Delimiter	Sets the separator for columns when there are multiple columns.
Row Delimiter	Sets the delimiter for rows when there are multiple rows.
Quote Character	Sets the character to represent a quote.

Copy Column Header

Copies the column name of the selected cells.

Copy Row Number

Copies the Row Number of the selected cells.

Copy as CSV

Copies the contents of the selected cells in CSV format.

Copy as TXT

Copies the contents of the selected cells in MarkDown txt format.

Copy as SQL

Copies the INSERT syntax generated based on the value of the selected cell.

3. Paste

Pastes the copied value. However, it is limited to the table that can be modified.

4. Order By

Reruns the SQL by setting the Order By value of the selected column.

5. Customize Filter

This is the same as [Customize Filter].

6. Pin Column

Pins the order of the columns to the left.

7. Remove all Filters/Orderings

Removes all conditionals and runs SQL again.

8. Go To Row Number

Moves the focus to the entered Row Number.

9. Edit

Value View

Figure 7. Value View

The users can check the details of the selected value in the form of a window. If the viewed object is an editable object, editting the value is available.

Inline Edit

Activated only when the viewed object is an editable object, the input is activated in the cell of the table and the value is changed to a form that can be edited.

Set as Null

Activates only when the viewed object is an editable object, and changes the value of the selected cell to NULL.

Set as Default

This function is only active when the viewed object is an editable object, and changes the value of the selected cell to the type-specific Default value.

Add a New Row

Activated only when the viewed object is an editable object, this option adds a new row.

Figure 8. Added Row Cell

Duplicate Row

Activated only when the viewed object is an editable object, this option copies and adds the contents of the selected Row.

Delete Row

Activated only when the viewed object is an editable object, this function removes the contents of the selected Row.

Figure 9. Deleted Row Cell

10. Data Export

This is described in the [Export Data] chapter.

11. Refresh

Reruns SQL. If a conditional clause is set, it will be based on the SQL with the conditional clause.

---

Bottom Area Functions

Figure 10. SQL Result - Bottom

1. Refresh

This is the same as [Context Menu] - [Refresh].

2. Save

Runs the actual DML SQL statements corresponding to the operation when there is a row that has been edited (added, deleted, modified).

3. Cancel

Removes all the contents of the operation when there is a row that has been edited (added, deleted, or modified).

4. Edit Row

It is activated only when the viewed object is a modifiable object, and displays a modal to modify the value of the selected Row.

5. Add Row

Activated only when the viewed object is an editable object, it adds a new Row.

6. Duplicate Row

Activated only when the viewed object is an editable object, it copies and adds the selected Row.

7. Delete Row

Activated only when the viewed object is an editable object, it removes the selected Row.

8. Go To Top

Moves the focus to the first Row of the current page.

9. Go To Bottom

Moves focus to the last row of the current page.

10. Export

This is described in the [Export Data] chapter.

11. Fetch All

Fetches all data. Page transitions may be faster after Fetch All, but be aware that Fetch All operations can be very slow when there is a large amount of data.

12. Go To Line

Enters a value of the form Row Number, Column Number to move focus to the corresponding cell.

---

Limitations

Note

Restrict functions that require SQL to be rerun for smooth application working (Insert Conditional, Refresh, etc.) from being run when there is a Task allocated to the editor session.