Hi Amar,

sorry to disappoint you, but it is not possible to use the VAR placeholders in this way.

Here are some of the ways how VAR is generally used (and other placeholders);

You can use placeholders for table generation.

1. For example, if you have a MySQL query-based table, you can use this query:

SELECT * FROM yourDatabaseTable
WHERE someColumn = %VAR1%

%VAR1% can be defined in the Placeholders tab when you're creating a table.

You can also alter this in the shortcode. 

2. Or,  if you don't add the condition in the query,

 you can add %VAR1% in column settings -> Filtering, under "Predefined filtering value".

For example, in this Table in the "Countries" Column :

Then, when you add the table to a page, you can use [wpdatatable id=1 var1=USA] on one page if we want to predefine to filter just rows of "USA" on table load,

or  [wpdatatable id=1 var1=Germany]  on a page where we want to just pre-filter Country as Germany

and so on, to apply the values defined in the shortcode to the filter.

-

So, in your case, if you have a Column that holds rows with "State" values;

you can do the same and then pass "VAR1=value you need".

-

Let me know if that helps.

Hi Amar,

as far as i am aware, we do not have a simple search and replace method,

at least i can't find any from our working examples or custom workarounds we got from our other users.

-

We do have this Conditional Formatting, though, which can be used to look for a certain condition in cells of a Column, and then you can set certain actions, such as transforming content of the cell, changing cell, column or row color, adding CSS class etc,

please check more on this here.

-

But i am guessing you meant something more complex/different,

such as a 'search and replace' placeholder?

Could you perhaps elaborate a bit more, if you can add any kind of examples and screenshots, or a Video,

just to be sure we understand the use case,

then i can ask our developers if they know of any way to achieve it?

Thank you.

Hi Amar,

thank you for clarifying the use case, i see what you mean.

Unfortunately, it is not possible to use our current built-in Placeholder capabilities like this,

 directly placing the %VAR1% inside the table cells.

The %VAR1%  can only be used as a predefined filter on an entire Column,

but i think this is a good idea for future development.

Please feel free to search on our suggestions page, 

 to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there,  and as more people vote, the feature will move higher on the priority list.

You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

and our newsletter, so you're informed about new features, bug fixes, freebies, etc.

-

If you have coding skills and wish to try to make a custom solution now,

you can check out our available hooks for Developers on this documentation and see if you can find any hook that might help.

Please be advised that custom solutions with hooks are not included in our support.

You can also research resources such as Stack Overflow to see if any other user perhaps found a workaround.

Maybe this can be done with some custom work, but our developers are very busy at the moment, working on some priority tasks and fixing bugs and issues with our plugins, so they won't be having the time for custom work in the near future.

( We do like to give examples for certain solutions, but for this use-case, we, unfortunately, don't have anything yet)