GetResultListBySubGroup

Applies to the following products: 
Questionmark OnDemand
Questionmark Perception
Questionmark OnPremise
Applies to the following Perception versions: 
Perception 5.7

This method returns the result records for the event (subgroup) given. This can then be used for reporting or printing of certificates.

This method will:

  • Check that the required input parameters are correct
  • Get all the results for the completed assessments
  • Return the results records for the assessments

Only finished assessment results are considered, others will be ignored. The following statuses are considered finished as recorded in the A_Results table:

2 = finished ok (all blocks submitted)

3 = finished out of time (time limit expired)

4 = finished abnormally (connection closed before finished)

5 = user quit

9 = scanned (assessment results received via scanner or QMWISe)

The Result_Value will be calculated as follows at the time of returning the results:

  • If the assessment has other than two outcomes defined, then Result_Value returned will be blank
  • If the assessment has two outcomes and if the participant has reached the higher scoring outcome (the participant has a higher max score) the Result_Value returned will be 1
  • All other Result_Value returned will be 0

If an assessment is modified after being delivered it could affect the results stored in the Perception repository.

This method can use secure headers to verify credentials before it is processed by Perception. For further information about secure headers, please refer to the Security chapter.

Available in:
  • Version 4.4 +
  • Version 5.1 +

This method requires additional license options to be enabled. To use this method you will need to have a valid license for the SAP Connector.

Parameter

Input name Description Data type Optional field?

Event

The subgroup to return results for

String

N

Response

Output name   Description Data type

Result_ID

 

The result ID of this result

String

Assessment_ID

 

The assessment ID of the assessment that generated this result

String

Write_Answer_Data

 

This indicates whether answer data is written to the repository database for this result (if it is, it will be in the table A_Answer )

Boolean

Participant

 

This is the name of the participant who took the assessment that generated this result

String

Member_Group

 

If the participant who took the assessment that generated this result belonged to a group when they took the assessment, this is the name of the group

String

Participant_Details

 

The general details of the participant who took the assessment that generated this result

String

Hostname

 

Hostname of participant (if available) at the start of the session.

String

IP_Address

 

IP address of participant (if available) at the start of the session.

String

Still_Going

 

This indicates whether or not the assessment that generated this result is still active

Boolean

Status

 

0 - Started, 1 - Running, 2 - Finished, 3 - Expired, 4 - Timed out, 5 - Quit

Short

Feedback

 

0 - No feedback given, 1 - Some feedback given

Short

Number_Sections

 

The number of question blocks in the assessment that generated this result for which replies have been received

Short

Max_Score

 

The maximum score of all questions answered in the question blocks in the assessment that generated this result

Integer

Total_Score

 

The participant's actual score for all questions answered in the question blocks in the assessment that generated this result

Integer

Special_1 to 10

 

These parameters contain information specific to the outcome of the question that generated this result

String

Time_Taken

 

The time taken, in seconds, between the start and end of the assessment that generated this result (zero if the assessment is still active)

Integer

Score_Band_Title

 

The title of assessment outcome at end of the assessment that generated this result

String

Score_Band_Number

 

The number of assessment outcome defined in the assessment that generated this result

Integer

Percentage_Score

 

The percentage score achieved by the participant for the assessment that generated this result

Short

Schedule_Name

 

The name of the schedule that this result was generated through, or blank if the assessment was not scheduled

String

Monitored

 

Indicates whether or not this result came from a monitored schedule or assessment

Boolean

Monitor_Name

 

If Monitored is set, this is the name of the user (or proctor) performing assessment monitoring

String

TopicScoring

(may occur several times)

 

 

 

 

Topic_ID

The Topic_ID for the topic associated with this result

String

 

Topic_Name

The full name of the topic associated with this result

String

 

Description

A short description of the topic associated with this result

String

 

Percentage_Score

The percentage score for the topic associated with this result

Double

 

Acual_Score

The actual score for the topic associated with this result

Integer

 

Maximum_Score

The maximum score for the topic associated with this result

Integer

 

Num_Questions

The number of questions from the topic associated with this result

Integer

ScoreBandID

 

The score band ID number

Integer

Course

 

The assessment folder for this assessment

String

Participant_First_Name

 

The participant's forename

String

Participant_Last_Name

 

The participant's surnames

String

Result_Value

 

The Result_Value is calculated depending on the assessment outcomes. If the assessment has:

  • More than two outcomes defined the Result_Value passed is blank
  • Two outcomes defined and the participant has reached the higher scoring outcome the Result_Value is passed with the value of 1
  • For all other instance the Result_Value passed will be 0

String

Member_Sub_Group_1

 

If the participant who took the assessment that generated this result belonged to a sub group when they took the assessment, this is the name of the group

String

Assessment_Name

 

The name of the assessment as recorded in Perception

String

When_Started

 

Date when this result was first written to the database

String

Session_Last_Modified

 

This is the date when the assessment to which this result applies was last modified

String

When_Finished

 

The date when the assessment that generated this result finished, or when last updated if it is still going

String

Troubleshooting

Please refer to the following page for any error codes that are displayed when using this method.

Appendix - Error codes