Query CPT with CF value stored in custom table (Bricks Query Editor)

Support MB Custom Table Query CPT with CF value stored in custom table (Bricks Query Editor)Resolved

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #44921
    Touchdown TechTouchdown Tech
    Participant

    Hi,

    I have a custom post type called testimonials. I'm using the CPT for customer testimonials and also to list customer logos.

    The data for the custom fields are stored in a custom tabled called 'testimonials' I need help writing the query in Brick Builder's Query Editor to only query posts where the custom field 'customer_testimonial_switch' has a value of '1'.

    I cannot get this to work.

    Here's documentation from Bricks on how to write a query for custom posts using the Query Editor but they don't show examples of using it to only query posts with a custom field value in a custom table.

    Here's a screenshot of the documentation page.
    Screenshot of Brick's Query Editor Doc

    #44935
    PeterPeter
    Moderator

    Hello,

    If you want to get the post ID by custom field value in a custom table, please use an SQL query. Following the documentation https://docs.metabox.io/extensions/mb-custom-table/#query-posts-with-wp_query

    If you want to apply it in the Bricks builder, please contact their support to get more information.

    #44947
    Touchdown TechTouchdown Tech
    Participant

    Thanks for the response. I decided to add a new field group that uses the postmeta table so I can use the meta query parameters set within Bricks's query loop builder.

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