Software 101 – Database Part 1

Behavioral Assessment

1. Open up SQLQuery

2. Highlight and press ‘Execute’ on one of the below stored procedures depending if you have the assessment taker’s name or email.

• If you have the first and last name run the below stored procedure with the first and last name separated with single quotes and a comma like in the example below:
  • exec [Support].[GlobalBASearch] ‘First’, ‘Last’

Please note if someone has a ‘ in their name it will need to be replaced with a %. ie. O’Brien would be O%Brien when searching 

• If you have the email address run the below stored procedure with the email in single quotes like in the example below:
  • exec [Support].[GlobalBASearch_ByEmail] ‘test@predictiveindex.com’

Cognitive Assessments

1. Open up SQLQuery

2. Run ‘FindCognitiveAssessment’ procedure

• exec [Support].[FindCognitiveAssessment] ’email address’

Results will yield the CognitiveID used to restore Cognitive Assessments, along with the assessment status and whether it has been deleted or not.  0 = not deleted; 1 = deleted.  To understand the different CognitiveStatus’ review this GURU card: Cognitive Assessment Error Codes