Join tables

  • Resolved stewa75

    (@stewa75)


    2 years, 8 months ago

    Hi guys,

    I’ve just bought the premium version of this very useful plugin and I’m trying to achieve my goals.
    One doubt I have regards the ability to join two tables or something similar that consents me to show in a table the resulted linked value from another table.

    Do anybody know how I can handle this need?

    Thank you ??

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

    (@peterschulznl)

    Hi @stewa75,

    Thank you for upgrading to premium!

    You can use the Query Builder to join tables. If you know SQL you probably know how to write joins. If you do not know SQL, you can use the Visual Query Builder:
    https://wpdataaccess.com/docs/documentation/query-builder/visual-query-builder/

    The Visual Query Builder is a user friendly UI to write queries, including joins.

    Queries saved in the (Visual) Query Builder can be use directly in charts. I’m currently finishing the same feature for the Data Publisher (hope to release Friday).

    But there is a workaround to use joins in the Data Publisher without the new feature: just save your join as a view and use your view instead of a table.

    Does this help?

    Best regards,
    Peter

    Thread Starter stewa75

    (@stewa75)

    Thank you Peter,

    I got it.

    I’m a bit curious about the TDL around this awesome plugin. Is there a way to know more of it?

    It could be useful also to the plugins users for planning future options.

    Thank you

    Stefano

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Stefano,

    Hope to finish it this week and deploy Friday… ??

    Bets regards,
    Peter

    Thread Starter stewa75

    (@stewa75)

    Can’t wait Peter,

    ciao!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Join tables’ is closed to new replies.