I'm trying to know with a query what professors has activities without corrections.
Does anybody has a query in Bb Ultra to run in DDA to get:
Student, activity, summit date, garde (y/n), Bb course?
I Think that i have this query, do you still need ?
Yes please, I will appreciate. Guilherme Rodrigues Candido
Frederico, can u try with code below ?
U.USER_ID,CONCAT(U.FIRSTNAME,' ',U.MIDDLENAME, ' ', U.LASTNAME), GM.TITLE, A.ATTEMPT_DATE, COURSE_ID, A.STATUS
GRADEBOOK_GRADE GG ON A.GRADEBOOK_GRADE_PK1 = GG.PK1
GRADEBOOK_MAIN GM ON GG.GRADEBOOK_MAIN_PK1 = GM.PK1
COURSE_USERS CU ON GG.COURSE_USERS_PK1 = CU.PK1
COURSE_MAIN CM ON GM.CRSMAIN_PK1 = CM.PK1
USERS U ON CU.USERS_PK1 = U.PK1
AND GM.TITLE = ? /*Put name of the activity*/
AND A.LATEST_IND = 'Y' /*Take only last attempt of this activity*/
AND A.STATUS = 6 /*IN_PROGRESS:3, SUSPENDED:4, NEEDS_GRADING:6, COMPLETED:7*/
AND U.ROW_STATUS = 0 /*Be sure that student are active in Blackboard*/
AND CU.ROW_STATUS = 0 /*Be sure that student are active in this course/
AND CU.CRSMAIN_PK1 IN (SELECT
(COURSE_ID = ? /*Put course_id*/))
Thanks, I will try tomorrow as my first task.
Thanks for the help.
I tested and it's awesome, thanks Guilherme Rodrigues Candido for helping, It's great, now I can save a lot of time and can continue with my dashboard
Retrieving data ...