Hello Isabel

Thank you for your purchase.

Can you please try with this:

function table_filtering($query,$table_id ) {
  $month = 3;
  if ( $table_id == 18 ) {
    
      $query = "SELECT tTransactions.`id_transaction`,
                tTransactions.`transaction_date`,
                tTransactions.`id_product`
                FROM tTransactions
                where month(tTransactions.`transaction_date`)=". $month;
   }
   return $query;
}
add_filter('wpdatatables_filter_mysql_query', 'table_filtering',10,2);

Basically, replace single with double quotes, and move the filter below the function.

Please let me know if that works.

Thanks for your feedback, Isabel.

I've forwarded the ticket to one of our developers, so he can take a look. As soon as I hear from him, I will let you know.

Hi again Isabel.

When our developer tested it, it's working fine.

Issues like this usually occur when there is a conflict either with the theme currently active on your website, or another plugin you have installed.

Can you please change the theme and see if the issue is resolved? If not, then please deactivate all other plugins except for our plugin, refresh the page where the issue is, and see if it is resolved (it should be). If it is, then start activating other plugins one by one, and after each activation refresh the page to see if the issue reoccurred. Once it does reoccur, you will have found the plugin causing the issue.

If that doesn't help, it could be a caching issue.

Please try this hook again:

function table_filtering($query,$table_id ) {
  $month = 3;
  if ( $table_id == 18 ) {
    
      $query = "SELECT tTransactions.`id_transaction`,
                tTransactions.`transaction_date`,
                tTransactions.`id_product`
                FROM tTransactions
                where month(tTransactions.`transaction_date`)=". $month;
   }
   return $query;
}
add_filter('wpdatatables_filter_mysql_query', 'table_filtering',10,2);