The Search & Repair UI allows users to perform the following:

...

1. To search for UDR Input Type, you must first select a Data Veracity profile. Click the Filter button to open the Search dialog. 
   

   

2. Click Browse to select the Data Veracity profile.

3. 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

4. When you have selected UDR for Input type, you can configure the following:

   1. UDR types - Select the specific UDR from a list. You can only choose ONE UDR type to access.
       

      

   2. Display Fields - Select specific fields (which includes meta data, user defined MIMs and UDR fields) that you would like to display in thequery results.
      

      

   3. Search 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.

5. Click OK to execute the query and the results will be displayed.
   

   

...

1. To search for Batch, you must first select a Data Veracity profile. Click the Filter button to open the Search dialog. 
   

   

2. Click Browse to select the Data Veracity profile.

3. 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

4. When you have selected Batch for Input type, you can configure the following:

   1. Display Fields - Select specific fields (which includes meta data and user defined MIMs) that you would like to display in the query results.
      

      

   2. Search 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.

5. Click OK to execute the query and the results 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.
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: == != > >= < <= between not between is null is not null
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. 

...

1. To repair UDRs values, you can

   • Select the Data Veracity records of UDRs in which the user would like to repair the values, then click on the Repair button in the result table menu bar.

   • click Click on Repair button (found from the 3 dots meatball menu ) in the result table menu bar, when all of the records are deselected if . This allows you wish to repair all the UDRs in the result table.
     

2. The New Repair Rules dialog box will appear. From this dialog box, you can create and save a new rule. Alternatively, you can load an existing rule to use or even to modify it. There can be one or multiple rules for each repair rule in Data Veracity. For more information about managing Repair Rules refer to Repair Rules.
   Image Removed
   Repair rules dialog box

   Image Added

3. To create a new rule, click on the New Rule button to begin:

   • You will select the UDR Field in the first combo box.

   • You will then select the operation to be conducted in the second combo box.

   • You can also check the APL check box to allow the include business logic in the form of APL codes into the rule itself.

     Info
     title Info!
     Restricted fields will not appear for selection in the combo box. For more information on how to set up restricted fields, refer to Restricted Fields(4.0).

     Info
     title Info!
     If an existing repair rule contains one or more restricted fields, those fields will be grayed out and will be not be editable. The repair task will also not repair the field.

     
     

4. To remove a rule, click on the Minus button on the right side of each rule.
   

5. Clicking on the Save button will save the Repair Rule as a new rule, but if the Repair Rule is already an existing rule, you have the option to save it as a new repair rule or to update the existing rule.
   

6. Click the Repair Selected or Repair All button to execute the repair job. It will also take you to the Repair Jobs page where the repair job will be listed and the user will be able to monitor the progress of the job. For more information on the Repair Jobs page, please refer to Repair Jobs.

...

This is only applicable when Input type is UDR. Click on View UDR at the Actions column to inspect a UDR and view the field and values present in the UDR.