The Search & Repair UI allows users to perform the following:
Search for Data Veracity records (erroneous UDRs or batch files)
Change the state
Mark Data Veracity records for deletion
Force delete Data Veracity records
Repair Data Veracity records
...
...
Searching for UDR Input Type
To perform a search for UDR Input Type in Data Veracity, follow the steps below:
| Note |
|---|
Note! Unsupported Data Type for Search
|
To search for UDR Input Type, you must first select a Data Veracity profile. Click the Filter button to open the Search dialog.
Data Veracity Search dialog
Click Browse to select the Data Veracity profile.
Select UDR for Input type.
Info title Enabled Input Type for Search UDR radio button will be enabled only if it is enabled in the selected Data Veracity profile When you have selected UDR for Input type, you can configure the following:
UDR types - Select the specific UDR from a list. You can only choose ONE UDR type to access.
Data Veracity UDR types combo boxDisplay Fields - Select specific fields (which includes meta data, user defined MIMs and UDR fields) that you would like to display in thequery results.
Display Fields selection dialog boxSearch Query - Add the filter rules that you want in the query builder by clicking on Add. If more than one rule is defined, you would be able to choose between AND or OR by clicking on either of the buttons. You could also add a new group of rules by clicking on the Add Group button to define a nested set of rules for the query. When you run a query, rows in the table that matches the expression will be displayed in the Query Results.
For more information, see the Search Query section below.Info title Saving the filter To save the filter, click on the Save button to either save it as a new filter, or to update it if you were using an existing filter to search.
Click OK to execute the query and the results will be displayed.
Example Query Result for UDR Input type
...
To search for Batch, you must first select a Data Veracity profile. Click the Filter button to open the Search dialog.
Data Veracity Search dialogClick Browse to select the Data Veracity profile.
Select Batch for Input type.
Info title Enabled Input type for Search Batch radio button will be enabled only if it is enabled in the selected Data Veracity profile
When you have selected Batch for Input type, you can configure the following:
Display Fields - Select specific fields (which includes meta data and user defined MIMs) that you would like to display in the query results.
Display Fields selection dialog boxSearch Query - In the Search Query panel, add the Filter rules that you want in the query builder by clicking on Add. If more than one rule is defined, you would be able to choose between AND or OR by clicking on either of the buttons. You could also add a new group of rules by clicking on the Add Group button to define a nested set of rules for the query. For more information, see the Search Query section below.
Info title Saving the filter To save the filter, click on the Save button to either save it as a new filter, or to update it if you were using an existing filter to search.
Click OK to execute the query and the results will be displayed.
Example Query Result for Batch Input type
...
To search with a saved filter, you must select a previously saved filter. Click the Filter button to open the Search dialog.
Search and select a saved filter with the Saved filters drop down and the configured filter values will all be loaded in the Search dialog.
Click OK to execute the query and the results will be displayed.
...
This panel represents an expression based on the columns in the Data Veracity table. When you execute a query, rows in the Data Veracity table that matches the expression will be displayed.
Item | Description |
|---|---|
AND | Click this button to apply AND logic on a set of rules or groups. |
OR | Click this button to apply OR logic on a set of rules or groups. |
Field name | This drop-down list contains columns in the selected database table that you can use in your query. The query is carried out based on this selection as a filter rule to populate the result for the Display Field. |
Example field names | |
Operator | This is a comparison operator that is applied to the values of the specified column. The available operators are listed according to the data type of the selected column. |
Example operators drop-down | |
Value | This field contains a value that is used for comparison with the selected column. When between and not between is the selected operator, two value fields are displayed. When you click this field and the column is of a date type, a date picker will be displayed. |
Add | Click this button to add a new rule to the expression. |
Add Group | Click this button to add a group of rules within the expression. The groups can be nested. |
Remove Group  | This button will only appear when a group is added. Click this button to delete a group. When you delete a group, the rules contained within it will be deleted as well. |
Delete | Click this button to delete a rule. |
Additional Actions
Apart from searching for Data Veracity records in the Data Veracity tables, you can perform the following actions in the Search & Repair. These actions buttons/menus can be found on the query results table.
...
Click the Export button in the result table menu bar.
In the Export search result dialog, enter the following:
Filename - The export filename should contains alphanumeric- or dash (-) characters. Do not add a file extension or a path.
Delimiter - You can enter a character or string that should represent the separator token, e.g. a comma or a semi-colon.
Export search result dialog
Select the check box Include Header to add the column names to first row in the file.
Click the OK button. A dialog box containing a link to download the zipped file will be displayed. All the columns of the table that is specified in Display Field will be included in the file.
...