grade student tab

  • Resolved ijtzib

    (@ijtzib)


    2 years, 3 months ago

    HI,

    Im trying to replicate the school demo but having trouble especially with the Grade TAB. can anyone explain to me how i can make it work. I have student table grade table and instead of course table I have the enrollment table. would want to upload a screenshot but not sure how. Please assist.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter ijtzib

    (@ijtzib)

    2 years, 3 months ago

    this is a screenshot of what I want to accomplish..I want to assess the students in the student list. be able to select a student for each assessment created.

    Plugin Contributor Kim L

    (@kimmyx)

    2 years, 3 months ago

    Hi @ijtzib,

    Could you send us a message via Contact | WP Data Access?

    We might need to take a closer look at how your relationships are currently set up.

    We’ll wait for your message!

    Thread Starter ijtzib

    (@ijtzib)

    2 years, 3 months ago

    Hi Kim,

    I manage to accomplish the relationship and view and it worked just fine. Thank you for replying to this post. Below view and screenshot:

    CREATE ALGORITHM=UNDEFINED DEFINER=root@localhost SQL SECURITY DEFINER VIEW studentenrollmentview1 AS select s.student_id AS student_id,s.student_firstname AS student_firstname,c.enrollment_id AS enrollment_id from ((bz_sas_student s join bz_sas_class c on((s.student_id = c.student_id))) join bz_sas_student_enrollment se on((c.enrollment_id = se.enrollment_id)))

    See belowhttps://snipboard.io/Sx2IUW.jpg

    Plugin Contributor Kim L

    (@kimmyx)

    2 years, 3 months ago

    Hi @ijtzib,

    Thanks for the update. 😊

    Feel free to create a new thread or send us a message if you have more issues.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘grade student tab’ is closed to new replies.