Performing a Search and Replace in Conceptual Objects
The search and replace feature allows you to update values in several records simultaneously, replacing a specified value in one column with a different value. This feature is only available for columns that are data type char or varchar.
Use the following procedure to perform a search and replace update for self recursive, network recursive, and supertype conceptual objects defined to display in either tree or advanced parent-child view.
To perform a search and replace update on records
1. On the Menu toolbar, click Manage > Manage Data.
2. Navigate to the object that you want to edit and select it.
3. Optionally, enter filtering criteria and click Apply Filter to display records.
4. Select the records in which to perform the search and replace:
In tree display view, select the top-level record in the left navigation panel.
In advanced parent child view, select the check boxes corresponding to the records you want to edit.
5. Select Edit > Search & Replace.
6. Select the column in which you want to search for matching values, and complete the remaining fields.
To perform a search that is case sensitive, select
Case Sensitive.
To update both child and parent records, select
Include Sub Levels.
7. Click Save.
OneData updates records that match the criteria specified and returns to the results screen, indicating the number of records that were updated.