Manipulating results
Top Area Functions
1. 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
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
The users can customize the expression related to columns in detail.
The following is about the main configuration options.
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
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
1. Copy
Copy the value of a cell.
2. Advanced Copy
Customize the options to copy the value of a cell.
Advanced Copy
The main options are as follows.
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
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.
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.
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
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.
Last updated