Find
Function Description
The Search function in the property sheet is used to search for the records that meet the search criteria in the currently opened property sheet, and two methods are provided: Search Content and Search Criteria. Search criteria also provides two modes of semi-automatic SQL statement input and SQL manual input.
Function entrance
- Property Sheet tab-> Browse group-> Find.
- Use the shortcut Ctrl + F in Tabular.
- TabularContext Menu-> Find.
Operating instructions
- In Tabular, use the shortcut Ctrl + F to open the Find dialog;
- Select the search mode, and provide Search Content and Search Criteria. For example, select Search Criteria here, and use the semi-automatic SQL Input mode to query;
- Search Content: Enter the content information to be searched in the text input box. The Drop-down Button records the search history of nearly five times. You can quickly select a certain search history to search through the Drop-down Button. Fuzzy Search and Accurate Query are provided at the same time. The default is Fuzzy Search.
- Search criteria: default to semi-automatic SQL input, and can be switched to SQL manual input mode by checking SQL Input. Both modes provide Import, Export, Clear, Function functions:
- Import: Import the file (XML) saved with SQL Expression to improve work efficiency;
- Export: The currently written SQL Expression can be exported as an XML file, so that the same expression can be used to query the property table again.
- Clear: When the expression content is too much, the expression information can be quickly cleared through the Clear button;
- Function: The function button provides function help. Function information and usage can be quickly viewed through function search. At the same time, the function can be automatically added to the SQL Expression input box by double-clicking the function through Function List.
- Set the conditional statement in the SQL semi-automatic input box, such as the Select Region field here. Select Equal in the operation box. The Drop-down Button in the text box on the right will provide the unique value of the field as an option. Select "Dongcheng District";
- Select the And or Or logic expression through the Add Clause button to query the attribute table with multiple conditional statements as Search criteria. The statement expression is set as in Step 3;
- After adding the statement, click the Search All button, and the Search Result will be displayed at the bottom of the dialog box, and the records meeting the conditions will be highlighted in the attribute table;
Related topics