Hi guys, I'm trying to put together a page with a bunch of data taken from the datatable but only the cell specific shortcode (eg [wpdatatable_sum table_id=13 col_id=229 value_only=1]) - However I need to programmatically change the variable used in the SQL query (its currently set with %VAR1%.  I understand I can set it with the standard shortcode - but this page only uses the sum shortcodes, and the table itself is never loaded.  So it always loads the data with the preset placehoder I set in the table config.

Ive tried adding it to the shortcode - but it doesn't seem to do anything. 

Failing that - is there a way I can tell it using php in my functions.php etc to use a specific variable that will also update the sum shortcodes too?

Many thanks

Hiya Milos,

thanks for the reply...I actually managed to figure it out myself in the end..

I used the wpdatatables_before_get_table_metadata action and used some example code I found to set the variables prior to the table loading which meant that the sum shortcodes are updated in advance and show the data needed.

Thanks