Hello olderdais.

There is a placeholder for today when You add conditional formatting to a cell, but in order to hide that column from the edit or new entry modals, editing has to be turned off, and in that case the placeholder would render useless.

I invite you to take a look at this ticket:

https://tmsplugins.ticksy.com//ticket/1840721/

The customer was asking the same thing, he was only using the user_id instead of %TODAY%, but eventually it works in the same logic.

Please let me know if that helps.

Best regards.

Hello olderdais.

1. I am sorry to inform you, but something like this can be done with some customization. The %TODAY% placeholder can only be used for Conditional Formatting, and can't be used for editing.

2. I apologize, but I did not quite understand what you're trying to do with this variable. Can you please explain it to me in a bit more detail, and send me a screenshot or even better a screen cast so that I can see what you mean.

Best regards.

Hi olderdais.

Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.

Best regards.

Hello again olderdais.

Sorry for late response. 

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

Sorry to disappoint you but unfortunately something like this is not possible to achieve with the plugin's built in features at the moment.

But by default when you enter the new value and have a datepicker the datepicker will be highlighted with the today's date so basically you just need to click on it.

We already added this idea for the date to be a new placeholder, but unfortunately for now %TODAY% is only available if you're using conditional formatting for a certain column.

As for this:

In the website I work with that variable with 

if (isset($_GET['client'])) {     $clientname=  $_GET['client']; } 

So, how can I work with that variable in the table within the same web page ?? I cannot put $clientname in %VAR1% because is not working.

I am sorry to inform you, but unfortunately this is also not possible to achieve with the plugin's built-in features, and it would require some custom work to be done in order to get it to work in this way.

Sorry for any inconvenience.

Best regards.

Hello again olderdais.

Please take a look at this documentation - http://wpdatatables.com/documentation/table-features/using-placeholders/

You can concat that ID (in your example 'Client') that you get from URL to Variable for example %VAR1%.  All you have to do is to create Custom Page Template and to use do_shortcode()function to place wpDataTable on your page. In that shortcode.

For example:

$id = $_GET['id']; //Id that you get from URL
echo do_shortcode("[wpdatatable id=1 var1=$id]");

Hope this can help.

Please let me know.

Best regards.

Hi olderdais.

From the first look, you may be forgetting the "$", but I can't be too sure. Please note that "var1=$id" has to be equal to "['id']" so that may be another issue, since you have "notas" defined as ID, and later on it's being called as "sintemoresadmin".

Please investigate these two options and let me know.

Best regards.

Hello again olderdais.

Glad to hear you got it to work.

As for editing, searching and filtering - if your MySQL-query based wpDataTable doesn’t work correctly with server-side processing, probably this is happening because wpDataTables server has problems with parsing of the query and building new queries dynamically (rarely happens, but does sometimes). To avoid this please prepare a MySQL view (a stored query), which will return the data that you need, call it e.g. “view1” and then build a wpDataTabled based on a simple query like “SELECT * FROM view1″.

Please try this and let me know if it works.

Best regards.

Hello olderdais.

From what I understand, the following query displays results, but you can't edit them, correct?

SELECT ID, post_title, post_content, post_status, wpy4_terms.name FROM wpy4_posts
INNER JOIN wpy4_term_relationships ON wpy4_term_relationships.object_id=wpy4_posts.ID
INNER JOIN wpy4_term_taxonomy ON wpy4_term_taxonomy.term_taxonomy_id=wpy4_term_relationships.term_taxonomy_id
INNER JOIN wpy4_terms ON wpy4_terms.term_id=wpy4_term_taxonomy.term_id
Where post_status="pending"

If that is true, you can try creating a view in PHPMyAdmin by clicking on your database on the left, and then click on SQL tab on the right (see attachment):

CREATE VIEW `view_wpy4_posts` AS SELECT ID, post_title, post_content, post_status, wpy4_terms.name FROM wpy4_posts
INNER JOIN wpy4_term_relationships ON wpy4_term_relationships.object_id=wpy4_posts.ID
INNER JOIN wpy4_term_taxonomy ON wpy4_term_taxonomy.term_taxonomy_id=wpy4_term_relationships.term_taxonomy_id
INNER JOIN wpy4_terms ON wpy4_terms.term_id=wpy4_term_taxonomy.term_id
WHERE post_status="pending";

I cannot say for sure that this is the correct query, but this is how it should like.

Then, in wpDataTables, you'd use this query:

SELECT
* FROM view_wpy4_posts

and that's it.

The other way to do it would be this:

If the table generated successfully, when you go to Editing tab, you should see the table's MySQL name. It is stored in the database under that name. So, if the table's name is (for example) wp_wpdatatable_12, you'd need to create a view in PHPMyAdmin like this:

CREATE VIEW `test` AS SELECT * FROM `wp_wpdatatable_12`;

And then, again, in wpDataTables, generate a new table using this query:

SELECT
* FROM test

Using this plugin feature requires at least a basic knowledge of SQL. It is assumed that you can create the table in some MySQL data manager (e.g., PHPMyAdmin, MySQL Workbench), and prepare an SQL query that will return the data you need. If you do not know how to use MySQL, refer to the “Create a MySQL-query-based table by generating a query to MySQL database” section. It will explain how to create complete tables or MySQL queries without this basic knowledge. Please be advised that preparing MySQL queries for you is not included in the plugin support.

Also, please note these limitations on editing tables with wpDataTables:

Only one MySQL table can be edited at a time. Queries from multiple tables with joins cannot be used as an editable feature, since SQL UPDATE and INSERT statements are generated automatically, and there currently is no way to update multiple tables – but this problem is being investigated and pursued.

Only MySQL tables or tables created with “Create a table manually” and “Create a table by importing data from data source” options of “Create a Table” page can be edited.

Server-side processing MUST be turned on for front-end editing – Note: It will turn on automatically if you forget to enable it.

MySQL Views may not be edited properly – only one of the underlying tables can be edited if you pass the proper ID.

Good luck, and best regards.

Hi again olderdais.

I've been reading and as you detailed in your last post "Only one MySQL table can be edited at a time", and I'm using 3 tables to run this query so what I'm trying to do is not possible I guess.

Yeah, that's exactly the case here, unfortunately.

As for this new issue, creating a view should resolve the issue. Can you tell me how that view looks like in the query editor?

If it is inline, can you try moving the "* FROM table_name" to a new row? Something like this:

SELECT
* FROM table_name

If this doesn't resolve the issue with search, could you please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.

Also, please tell me which table ID this is, and paste here how the view was created.

Best regards.

Yeah, olderdais.

Sorry, I may have forgotten to tell you that.

From version 2.3 we implemented a feature that you can use multiple separate db connections for (MySQL, MSSQL and PostgreSQL) and for MySQL engine we are dynamically adding accent grave ( ` ). If you remove that accent grave ( ` ) from query in query box, searching and filtering will work fine. Best regards.

My bad.

Best regards.