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

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.

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.