Join in column filter lookup

  • Resolved davidfosteruk

    (@davidfosteruk)


    2 months, 2 weeks ago

    I am struggling with the limited documentation available for the App Builder. I have two tables in WP Data Access: wp_site_locations and wp_site_regions. I have created a Data Admin app for wp_site_locations and I want to restrict a table filter to display only regions from wp_site_regions that match the country selected in the wp_site_locations country filter. The field name in wp_site_locations is ‘country’, the field names in wp_site_regions are ‘Country’ and ‘Region’. I am unable to achieve this using a dynamic lookup because it removes the column from the filter, and adding a default WHERE clause, also does not seem to work. How can I achieve my desired result?

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

    (@kimmyx)

    Hi @davidfosteruk,

    Could you send us a screenshot of your current setup in the App Builder?

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

    We’ll wait for your message!

    Thread Starter davidfosteruk

    (@davidfosteruk)

    Thanks. I don’t see any way of adding attachments either here, or in your contact form?

    Plugin Contributor Kim L

    (@kimmyx)

    Hi @davidfosteruk,

    You can upload attachments to Google Drive or any third-party upload service and send us a link.

    You can also just submit a question first, and we’ll reply via email, where you can add your attachments.

    If you’re on premium, a separate premium support form can be found on the top toolbar of WP Data Access.

    See here: https://share.zight.com/7KuN8qkz

    Hope that helps! ??

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.