Relational data?

  • Resolved Paul Guijt

    (@paul-guijt)


    4 weeks, 1 day ago

    On my site, data from a local database is presented. It’s a relational database, so records from different tables are connected.

    Currently, the data is presented in an iframe with legacy programming. How can I rebuild this in WP Data Access? Do I make a data app or a data table?

    The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    3 weeks, 5 days ago

    Hi Paul,

    Thank you for sharing the link. Your webpage currently displays a read-only data table. Your legacy data table can be replaced by a data table app. A data table differs from a data administration app primarily in that it is read-only. It does not facilitate any transactions.

    I hope this helps. Please let us know if you require further assistance.

    You can find more information about supported types here:
    https://docs.rad.wpdataaccess.com/supported-app-types.html

    Thanks,
    Peter

    Thread Starter Paul Guijt

    (@paul-guijt)

    3 weeks, 5 days ago

    Hi Peter,

    Thanks for reaching out. Yes, the front-end is readonly with searching functionality. Above the table is a selecting menu.

    Each table has fields that take data from other tables through an index table. I have all MySQL tables as a data table now, tomorrow I’m going to (try to) fiddle these relations.

    Later on, I’m going to work on the front-end CSS styling and (a) form(s) for adding data.

    I must be honest, the documentation is hard to navigate. Especially if you’re a dive-in read-later guy like me. So far, I’m enjoying the challenge.

    Have a nice one,
    Paul

    Thread Starter Paul Guijt

    (@paul-guijt)

    3 weeks, 4 days ago

    Hi Peter,

    In the Table Builder of a Data Table, I see that the Relationship and Global Filter options are greyed. Does that mean that I need the Premium version to rebuild my old relational database application that holds a filter option in the front end?

    Then, I need to be able to click on a row and use data from the row into JavaScript. E.g., click on a row in Afleveringen (‘Editions’) and show the Artikelen table with the related articles. My idea is to use onClick through CSS. I couldn’t find a hook or something. Is there one?

    Regards,
    Paul

    • This reply was modified 3 weeks, 4 days ago by Paul Guijt.
    Plugin Contributor Kim L

    (@kimmyx)

    3 weeks, 4 days ago

    Hi Paul,

    Yes, filters and hooks are a premium feature.

    If you have more questions about them, kindly send us a message directly via Contact | WP Data Access.

    We’ll wait for your email! 😊

    • This reply was modified 3 weeks, 4 days ago by Kim L.
    Moderator Support Moderator

    (@moderator)

    3 weeks, 4 days ago

    Good reply.

    For pro or customer support, please contact the developer on their site. This includes pre-sales information.

    As the developer is aware, customers may not be supported on this site.

    https://wordpress.org/support/guidelines/#do-not-post-about-commercial-products

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

You must be logged in to reply to this topic.