Find rows dialog

The Find rows dialog allows you to identify rows in a table or worksheet by entering any valid selection expression, scroll through found rows in the grid, and create a select operation from the results.

The Find rows dialog is accessible from the Grid view by clicking the Find rows () icon located at the top of the grid.

Expression editor: Enter a selection expression to find rows in the table or worksheet.
For more information, see Writing Expressions in the 1010data Reference Manual.
First: Displays the first row of the results at the top of the grid.
In Single-row view mode, displays the first row of the results in Single-row view.
Previous: Displays the previous row of the results at the top of the grid.
Next: Displays the next row of the results at the top of the grid.
Last: Displays the last row of the results at the top of the grid.
Select: Creates a new select operation from the rows highlighted in the grid. The outcome is a new worksheet containing only the rows that were previously highlighted.
This option is not available in Single-row view mode.
Negate this expression: Negates the expression in the expression editor. For example, if your expression is store=1, then negating the expression results in store<>1.
Clear the find expression: Clears the find expression in the Find rows dialog, but leaves the dialog open.
Hide the find dialog: Click the Hide the find dialog () icon to close the Find rows dialog.