We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

Okay
  Public Ticket #1681897
Filters not rendering with placeholder
Closed

Comments

  • hulabula started the conversation

    Hi

    Filters don't seem to render correctly when using a placeholder in the MySQL query.  

    The attached image shows the same page rendering a table correctly (green) without a placeholder AND a table marked in red is not rendering correctly but does use placeholders.

    NON-PLACEHOLDER QUERY filters render (green)

    SELECT wp_fl_agreements.foreign_agreement_name,
           wp_fl_agreements.foreign_agreement_num,
           wp_fl_agreements.foreign_publisher_agreement,
           wp_fl_agreements.foreign_agreement_term_start,
           wp_fl_agreements.foreign_agreement_term_end,
    FROM wp_fl_agreements
    

    PLACEHOLDER QUERY filter don't render (red)

    SELECT wp_fl_agreements.foreign_agreement_name,
           wp_fl_agreements.foreign_agreement_num,
           wp_fl_agreements.foreign_publisher_agreement,
           wp_fl_agreements.foreign_agreement_term_start,
           wp_fl_agreements.foreign_agreement_term_end,
    FROM wp_fl_agreements
    WHERE wp_fl_agreements.fl_client_agreements LIKE '%%CURRENT_POST_ID%%'
    

    I need to pull and render all the rows where the CURRENT_POST_ID is found in the fl_client_agreements column which is stored like so in the MySQL table, "[post_id,post_id,post_id]"

    I even tried a different query not using LIKE and the filters still won't render:

    SELECT wp_fl_agreements.foreign_agreement_name,
           wp_fl_agreements.foreign_agreement_num,
           wp_fl_agreements.foreign_publisher_agreement,
           wp_fl_agreements.foreign_agreement_term_start,
           wp_fl_agreements.foreign_agreement_term_end,
    FROM wp_fl_agreements
    WHERE LOCATE('%CURRENT_POST_ID%',wp_fl_agreements.fl_client_agreements)>0
    

    Thoughts?

    The preview in the backend does work :/

    Also, filters also do not render when you use "Filters in a form" above the table. 

  • hulabula replied

    This is the attachment showing that the form above also does not render the filters when using a placeholder.

  •  472
    Isidora replied

    Hi hulabula,
    Thank you for your purchase.

    Sorry for late response. 

    We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.

    I suppose that is related with way how is saved that values in database for that column wp_fl_agreements.fl_client_agreements. Did you try to replace placeholder %CURRENT_POST_ID% with actual value of post id and check do you have same issue?

    Best regards


    Kind Regards, 

    Isidora Markovic

    wpDataTables: FAQFacebookTwitterFront-end and back-end demoDocs

    Amelia: FAQFacebookTwitter |  Amelia demo sites | Docs

    You can try our wpDataTables add-ons before purchase on these sandbox sites:

    Powerful FiltersGravity Forms Integration for wpDataTablesFormidable Forms Integration for wpDataTables