Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Data Veracity - Search view 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 a Data Veracityprofile.

  3. Select UDR for Input type.

    Info
    titleEnabled 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
      titleSaving 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 a Data Veracity profile.

  3. Select Batch for Input type.

    Info
    titleEnabled 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
      titleSaving 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

dataveracity_and.png

Click this button to apply AND logic on a set of rules or groups.

dataveracity_or.png

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.

dataveracity_add_group.png

Click this button to add a group of rules within the expression. The groups can be nested.

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.

dataveracity_delete.png

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 Data Veracity - Search. These actions buttons/menus can be found on the query results table. 

...

Note

Note!

Delete is only available to users with Write permissions for Data Veracity and Data Veracity - Search Application. For more information on User Privileges Management, please refer to User Privileges Management(4.0).

To delete records, you can

...

Note

Note!

Set state is only available to users with Write permissions for Data Veracity and Data Veracity - Search Application. For more information on User Privileges Management, please refer to User Privileges Management(4.0)

To set a state for records, you can

...