Table view not filtering

  • Resolved ijtzib

    (@ijtzib)


    8 months, 4 weeks ago

    HI,

    I have a table view. see sql script below

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

    I have enrollment, student, class and grade table. My issue is when I create the enrollment/s and add student to the class table then move to the grade table upon selecting the student from my drop down select, I get the list of ALL students from the different enrollments. I think it should only display the student for that specific class and enrollment.. see below image. In this example only Billy, Jonathan and Larry suppose to appear.

    https://snipboard.io/VGEuha.jpg

    See below relationship

    https://snipboard.io/uksSOq.jpg

    Regards,

    Ian

    • This topic was modified 8 months, 4 weeks ago by ijtzib.
Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter ijtzib

    (@ijtzib)

    Hi,

    Another issue I am observing is that it is duplicating the students as I create another enrollment. eg. Standard II and so on…

    See below screenshot

    https://snipboard.io/lBCPmF.jpg

    Ian

    Plugin Contributor Kim L

    (@kimmyx)

    Hi @ijtzib,

    Thanks for the screenshots. I think you should use a one-to-many relationship for the student column instead of a lookup listbox.

    Can you try that? Let us know if that works. ??

    Thread Starter ijtzib

    (@ijtzib)

    HI Kim,

    I tried changed it to a one-to-many relationship instead of lookup listbox but I’m trying to understand how will I then be able to select the student?

    Ian

    Plugin Contributor Kim L

    (@kimmyx)

    Hi @ijtzib,

    We’ve responded to your ticket!

    We’ll wait for your update when you can send us your project files so we can take a look. ??

    We appreciate your patience. ??

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Table view not filtering’ is closed to new replies.