-
Hooks
-
-
- wpdatatables_before_get_table_metadata
- wpdatatables_before_render_table
- wpdatatables_before_render_table_config_data
- wpdatatables_after_save_table
- wpdatatables_try_generate_table
- wpdatatables_get_ajax_data
- wpdatatables_before_filtering_form
- wpdatatables_after_filtering_form
- wpdatatables_before_table
- wpdatatables_after_table
- wpdatatables_after_header
- wpdatatables_before_header
- wpdatatables_before_footer
- wpdatatables_after_last_row
- wpdatatables_before_row
- wpdatatables_after_row
- Show Remaining Articles (6) Collapse Articles
-
- wpdatatables_after_save_settings
- wpdatatables_settings_page
- wpdatatables_browse_page
- wpdatatables_support_page
- wpdatatables_welcome_page
- wpdatatables_system_info_page
- wpdatatables_getting_started_page
- wpdatatables_addons_page
- wpdatatables_constructor_page
- wpdatatables_dashboard_page
- wpdatatables_admin_before_edit
- wpdatatables_admin_before_edit_simple_table
- Show Remaining Articles (2) Collapse Articles
-
- Articles coming soon
-
-
-
- wpdatatables_filter_table_metadata
- wpdatatables_filter_rendered_table
- wpdatatables_try_generate_table_result
- wpdatatables_filter_insert_table_array
- wpdatatables_filter_browse_tables
- wpdatatables_filter_mysql_query
- wpdatatables_filter_json
- wpdatatables_filter_excel_array
- wpdatatables_filter_table_description
- wpdatatables_filter_cell_val
- wpdatatables_filter_simplexml
- wpdatatables_filter_date_cell
- wpdatatables_filter_datetime_cell
- wpdatatables_filter_time_cell
- wpdatatables_filter_email_cell
- wpdatatables_filter_int_cell
- wpdatatables_filter_float_cell
- wpdatatables_filter_image_cell
- wpdatatables_filter_link_cell
- wpdatatables_filter_string_cell
- wpdatatables_before_generate_constructed_table_name
- wpdatatables_filter_table_title
- wpdatatables_filter_server_side_data
- wpdatatables_filter_table_cssClassArray
- wpdatatables_filter_query_before_limit
- wpdatatables_filter_initial_table_construct
- wpdatatables_before_create_manual_table
- wpdatatables_before_preview_file_table
- wpdatatables_before_read_file_data
- wpdatatables_query_before_save_frontend
- wpdatatables_before_generate_manual_table
- wpdatatables_add_default_columns
- wpdatatables_insert_additional_column_header
- wpdatatables_filter_column_metadata
- wpdatatables_filter_init_table_data
- wpdatatables_filter_nested_json_endpoint_args
- wpdatatables_get_one_level_deep_json_data_from_array_as_string
- wpdatatables_set_one_level_deep_json_data_separator
- wpdatatables_filter_nested_json_final_array
- wpdatatables_curl_get_data
- wpdatatables_curl_get_data_complete
- wpdatatables_filter_source_data_on_auto_update_cache
- Show Remaining Articles (32) Collapse Articles
-
- wpdatatables_filter_columns_metadata
- wpdatatables_filter_column_before_save
- wpdatatables_filter_update_column_array
- wpdatatables_filter_insert_column_array
- wpdatatables_filter_column_cssClassArray
- wpdatatables_filter_column_js_definition
- wpdatatables_filter_column_options
- wpdatatables_columns_types_array
- wpdatatables_columns_not_in_source
- wpdatatables_filter_column_config_object
- wpdatatables_filter_column_description_object
- wpdatatables_insert_additional_column_value
- wpdatatables_filter_column_title
- wpdatatables_filter_filtering_default_value
- wpdatatables_filter_editing_default_value
- wpdatatables_column_formatter_file_name
- wpdatatables_extend_column_js_definition
- Show Remaining Articles (7) Collapse Articles
-
- wpdatatables_filter_style_block
- wpdatatables_filter_frontend_formdata
- wpdatatables_allow_edit_table
- wpdatatables_filter_formdata_before_save
- wpdatatables_excel_filter_frontend_formdata
- wpdatatables_filter_excel_editor_query
- wpdatatables_excel_filter_delete_rows
- wpdatatables_filter_editing_default_value
-
- wpdatatables_filter_date_cell_before_formatting
- wpdatatables_filter_datetime_cell_before_formatting
- wpdatatables_filter_email_cell_before_formatting
- wpdatatables_filter_float_cell_before_formatting
- wpdatatables_filter_image_cell_before_formatting
- wpdatatables_filter_int_cell_before_formatting
- wpdatatables_filter_string_cell_before_formatting
- wpdatatables_filter_link_cell_before_formatting
- wpdatatables_filter_time_cell_before_formatting
- wpdatatable_cell_include_formatting
-
- Articles coming soon
-
-
Javascript
-
Extend wpDataTables
-
CSS
-
Database
-
PHP API (coming soon)
- Articles coming soon
wpdatatables_query_before_save_frontend
Contents
Description
This filter allows the modification of the actual SQL query that updates the table before it is executed. It is useful if you want to change how the SQL query behaves before it’s executed.
Usage
add_filter( 'wpdatatables_query_before_save_frontend', 'filter_query_before_save', 10, 2 );
Parameters
- $query string
Query string. - $tableId integer
ID of table from database.
Examples
// Callback function for the wpdatatables_query_before_save_frontend filter hook function filter_query_before_save( $query, $tableId ) { // Check for specific table Id if ( $tableId == 1) { // Example: Log or alter query before executing error_log("Running SQL query: $query"); return $query; } } add_filter( 'wpdatatables_query_before_save_frontend', 'filter_query_before_save', 10, 2);