Searching on Archived Legacy (TSA) Assessment Data

You can search for archived TSA assessment data in the Governance Portal by the means of isArchived filter. Going forward from v4.3, isArchived is available to be added as a column or a filter in a particular search to fetch either the archived TSA data, live TSA data, or both.

Case 1: IsArchived added as a search column

1. Create a Search with the AME legacy fields you wish to include in the search.
2. Select IsArchived in the Selected Columns to Display section.
3. Execute the search. The search results will display the archived and live legacy assessment data

   

   Note: Please note that the archived legacy data will have the IsArchived checkbox selected. The IsArchived checkbox will not be selected for the live data.

   Case 2: IsArchived added as a search filter

1. Create a Search with AME related fields.
2. Create a Filter with the IsArchived filter selected.

   Use the Filter tab to narrow the result set of the search you are creating.

   Once the fields (columns) have been defined as part of a search, these fields can be filtered to return only the criteria that you specify. Each filter must include an And/Or selection and requires the user to complete the next three fields with a field name, query condition, and a value.

   

   1. Select And or Or from the drop-down list.
   2. Select the object you wish to use in defining your filter.

      Note: See Create a View Definition for more information on how to set a default object type.

   3. Select the field you wish to use in defining your filter.
   4. Select a condition from the drop-down list.

      Note: View the link to the condition types below for more information on condition types.

   5. Enter a value in the last text box. In case of a boolean field, True or False will display.

      Note: Highlight a parameter and select ( ) to enclose it in parentheses, and -( )- to remove them.

   6. Click Add Filter.
   7. Highlight a parameter and use the Move Up or Move Down arrows to move a parameter up or down in a list, and select Delete to remove the parameter from the list.

   Condition Types

   The following are a list of conditions, descriptions and values through which you can filter your data:

   Condition	Description	Values
   Equals	Allows for user to enter a single exact value to be found and returned	Input a single value, number or text
   Not Equals	Allows for user to enter a single exact value, that should not be returned	Input a single value, number or text
   Contains	Number or text (exact or partial) that is found within that field	Number or text
   Not Contains	Number or text (exact or partial) that is not found within that field	Number or text
   Greater than	Value that all returns must be higher than	Number or text
   Less than	Value that all returns must be less than	Number or text
   Greater than or equal to	Value that all returns must be equivalent to or higher than	Number or text
   Less than or equal to	Value that all returns must be equivalent to or less than	Number or text
   Between	Brings up two fields with an “and” statement between	Number or text
   In	Brings up a pick list with the values found in that particular field. Records with this value found will be returned	Multi-selections are possible.
   Not in	Inverse of the “not in” parameter, meaning that selections with these records will not be in the return list.	Multi-selections are possible.
   Begins with	Records where the value begins with a particular text entry will be returned.	Number or text
   Ends with	Records where the value ends with a particular text entry will be returned.	Number or text
   Is Null	Records where the value is null for a particular field will be returned (e.g. show me risks where the control name is null would show you risks that do not have controls linked to them).	Number or text
   Is Not Null	Records where the value is not null for a particular field will be returned (e.g. show me risks where the control name is not null would show you risks that have controls linked to them).	Number or text
   @me	Records the name of the logged in user when a search is executed. It would apply only for the Name fields.	Text

   

3. If IsArchived is set as False, search results will display ONLY the live data.
4. If IsArchived is set as True, search results will display ONLY the archived data.

   Note: Including the IsArchived as a filter will ignore the addition of IsArchived as a column to display. In addition, the search would bring up only the live assessment data, if IsArchived is not included either as a column to display or a filter.