Okay
  Public Ticket #2915784
Possible to add wildcard to %VAR1%
Closed

Comments

  • Greg started the conversation
    November 13, 2021 at 9:03pm

    The subject says it all.  Using an sql query as a data source, is it possible to have a wildcard as the default value in a placeholder.  Allowing for all records to be displayed unless the placeholder contains a specific value.

    Thanks,

    Greg

  •  472
    Isidora replied
    November 17, 2021 at 10:17am

    Hi Greg,

     Sorry for the late response, we have some agents that have contracted Covid-19, so our team is cut in half.

    Yes, you can create table from SQL query like

    SELECT * FROM yourTableName WHERE yourColumnName LIKE '%VAR1%'

    then on Placeholders tab for VAR1 you can insert %% like this on image

    3771102903.png


    Then you can insert on page for example

    [wpdatatable id=1]
    [wpdatatable id=1 var1="value1"]
    [wpdatatable id=1 var1="value2"]

    Of course you will repace your table id and your values for placeholders and you will get same table with all data(first one) and filtered (other two) based on value from shortcode parameter for placeholder var1. you can use it separate on other pages, where ever you need.

    Let me know is this what you looking for.

    Best regards.


    Kind Regards, 

    Isidora Markovic

    wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter |  Amelia demo sites | Docs

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

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables

  • Greg replied
    November 28, 2021 at 8:29pm

    Milan,


    Thanks very much for the reply.  The double wild card solved my problem!  Feel free to close this ticket.


    Thanks,

    Greg

  •  472
    Isidora replied
    November 29, 2021 at 9:02am

    Hi Greg,

    You are welcome. 

    If you have any other issue or question please open new ticket, and we help you out.

    I’d like to ask you a favor. Would you mind taking a few minutes to write a review for us, please on this link? 

    Our free version is the only place where we can have proof for our hard work; your comments are beneficial for others to know what to expect when they’re looking for our plugin.

    Thank you in advance. It means a lot to us, and I am looking forward to reading your comment.

    Best regards.

    Kind Regards, 

    Isidora Markovic

    wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter |  Amelia demo sites | Docs

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

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables