Is
there An API To Update Scores Or to UPDATE/CREATE Records For OTA_ATTEMPTS,
OTA_PERFORMANCES,OTA_TEST_QUESTIONS, OTA_QUESTION_BANKS, OTA_UTEST_RESPONSES,
OTA_LO_FOLDERS, OTA_LEARNING_OBJECTS ? (Doc ID 406223.1)
Column
LESSON_STATUS in table OTA_PERFORMANCES hold the player status value. Currently
there are no publicly callable API's available the will permit a user to
manually manipulate LESSON_STATUS. The only supported method for changing this
value would require having the learner attempt and complete the learning object
again though the Learner UI.
So We
have to do direct base table update if this is feasible. I have done the direct
base table update for one class and it worked fine.
select
* from ota_activity_versions
where
version_name like ‘Course Name’;-- course
select
* from OTA_OFFERINGS
where
activity_version_id=83037;-- offering
select
* from ota_events
where
activity_version_id=83037;-- class
select
* from ota_learning_objects
where
learning_object_id=81017;--learning objects
select
* from OTA_DELEGATE_BOOKINGS
where
event_id=108019
and
delegate_contact_email='Jon.Hillegeist@taconic.com';--contains enrollments
select
* from ota_performances
where
lesson_status='P'
and
user_id=22461
and learning_object_id=81017; -- contains test
results
select
* from ota.ota_attempts
where
event_id=108019
and learning_object_id=81017
and
user_id=22461
and
attempt_id=217626
and
attempt_status='F';-- contains attempt details for the test
update
ota_performances
set
lesson_status='P'
where
performance_id=293169;
update
ota_attempts set attempt_status='P'
where
attempt_id=217626;
commit;
