Creating a view across many to many tables

  • Resolved mygrove

    (@mygrove)


    1 year, 1 month ago

    As an example, in the Student – Course – Class scenario is it possible to create a view in WPDA to display a selection of fields across all three tables? e.g.

    firstname lastname coursename classname

    or even

    (Group by) coursename
    (Detail) classname firstname lastname

    Perhaps there is another plugin that can access the the WPDA tables?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Contributor Kim L

    (@kimmyx)

    Hi @mygrove,

    It’s possible to create a view using the Query Builder.

    You just need to JOIN the three tables.

    If you need a guide on how to write JOINS, please see here: How to Join 3 Tables (or More) in SQL (learnsql.com)

    Hope that helps! Let us know if you have more questions. ??

    Thread Starter mygrove

    (@mygrove)

    Thanks, that’s all fine. How do I incorporate my query into WP Data Access – into the Project? Or directly on my site?

    Plugin Contributor Kim L

    (@kimmyx)

    Hi @mygrove,

    Once you create the view using?the?Query Builder, this view will appear on your list of tables in Data Explorer.

    For example: https://share.zight.com/bLuQwByd

    You can then use this view as a source data for a data table. To create a data table, we have a guide here: Creating and publishing | WP Data Access

    Hope that helps! Let us know if you have more questions.???

    Thread Starter mygrove

    (@mygrove)

    So, I can create a query and I have named and saved it. It can be run and produces the expected output.

    How does it become a view because it does not appear in the Data Explorer page. I have also tried importing the SQL statement into the Data Explorer. It gives a confirmation message saying it has been imported but is still not visible.

    Plugin Contributor Kim L

    (@kimmyx)

    Hi @mygrove,

    Are you running the query on the same database viewed on your Data Explorer?

    If it’s not too much trouble, could you send us a video recording of when you ran the create view query up to checking the Data Explorer?

    That would help us a lot in understanding the issue.

    You can also send us a message via Contact | WP Data Access if you wish to share more information privately.

    We’ll wait for your message!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Creating a view across many to many tables’ is closed to new replies.