As previously announced via banners and our newsletters, support is no longer available through this platform.

For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.

You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.

Paid customers: Please log in to your store account for support.

Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com

Okay
  Public Ticket #2158821
Use Placeholder %Var1% as a filter above table
Closed

Comments

  •  1
    Jon Falcone started the conversation
    September 20, 2019 at 8:32pm

    Hi, 

    I am trying to display a table that is powered by a SQL query.


    Right now that SQL query is using %Var1% in the 'WHERE' clause.


    I am wondering if I can display a filter that the user can use that changes the value in %Var1% in that SQL query.


    To be more clear, in the picture I attached..... that is currently the value that is being used in the WHERE clause of the SQL query and it be great if the user can see a filter where they can change that value so the table then filters accordingly.


    Thanks for any help!!!

  •  2,576
    Aleksandar replied
    September 23, 2019 at 10:35am

    Hello Jon.

    Well, you can use placeholders as a pre-defined filtering value. 

    So, in the query you'd remove the WHERE clause and %VAR1%, and then:

    1. Go into column settings, navigate to Data tab and change type from Integer to String; hit Apply

    2. Go back into column settings, navigate to Filtering tab, and change the filter type to either text, or select box, or whatever you like (except for numbers - float or integer). Then, under Predefined values type in %VAR1% and that column will be prefiltered with "8473507", but people can change it if they want.

    Best regards.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

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

    Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community

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

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables