I have a few different tables but when I used placeholders on some of them it complains that there is no data returned. I then change the query to remove the placeholder so it does return data and it works.

However whenever I go back to edit the query to include the placeholder it again complains that the dataset is empty. Is there a way to overwrite this so it will let me use the placeholder regardless if it returns results or not?

Hi Bogdan,

I have reviewed the documentation and I think i am doing everything correct. Here is an example:

select * from table where value = %CURRENT_USER_LOGIN%;

Generating a table using the above query works fine and while there is no data to be returned wpdatatables does not return the no data warning and allows me to create the table.

Then I go to create a second table using the query:

select SUM(value), AVG(value) from table where value=%CURRENT_USER_LOGIN% and date=CURDATE(); 

The above query returns the error that no data is returned. But the first query doesn't.

Regardless of no data being returned it tells me that I can put in a value to return data and then edit they query after to return a table with no data but also when I do this I still get the same error and can not apply the changes because it complains that:

See screenshots!

Hi Bogdan, I have found the problem. Appears that each time you edit a query the default placeholder %CURRENT_USER_LOGIN% reverts back to the current logged in user and you need to edit it again to allow the query return results.

I really should RTFM... Apologies... New user syndrome! Thanks for your help!