Software 101 – Database Part 1

Search for an Assessment

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

Copy link