ka2

Hi there,

The third argument “$sql_clauses” on this filter is an array of the elements for generating the first argument “$sql”. Certinly so that does not need to use in the above example of the code.

For example, if you want to use of complex query conditions when filtering the SQL, you can be used this argument for refer.

Thank you,

Thank you for your inquiry.

Yes, we are able to display data of the logged-in user only. There are several ways, I have example of when to add filter below.

<?php
function custom_select_query( $sql, $table_name, $sql_clauses ){
  if ( ! is_admin() && is_user_logged_in() && $table_name === 'sample' ) {
    global $cdbt;
    $current_user = wp_get_current_user();
    $where_clause = "user_id = '". (string) $current_user->ID ."'";
    $sql = sprintf( 'SELECT %s FROM %s WHERE %s %s', $sql_clauses[0], $table_name, $where_clause, $sql_clauses[2] );
  }

  return $sql;
}
add_filter( 'cdbt_crud_get_data_sql', 'custom_select_query', 10, 3 );

Please include the above code in the “functions.php” etc. on the theme. However, it must be stored user ID in the data of the displaying table.

Example of inserting the ID of the user who is logged in at the time of data registration, please try to see below (sorry in Japanese page).

https://ka2.org/cdbt/v2/filter-reference/cdbt_before_insert_data/

Thank you,

Thank you for providing credentials.

Thanks to you, I was able to recognize the finally trouble.

I probably seem a trouble that happen when the multiple shortcodes was put in the one page at the same time.
I’m going to immediately perform bug fixes.
As soon as possible to fix, so I will release a bug fix version, please wait.

Thank you,

Thank you for your inquiry.

The initial number of records that can be set in the plugin options is the initial value for when you create the table.

The initial value that is actually enabled in the shortcode is the value that are displayed in the table list of table management. This setting can be changed from the “Modify Table”.

Thank you,

Sorry for my late reply.

I do not know whether can be solved this problem as soon as at present.
However, because I want to see actually a symptom of the problem, please to be able to access to your front end.

My e-mail address is ka2@ka2.org.

Thank you,

Certainly, as you said.

Sorry, sorting of in the current plugin does not have an ideal behavior.
Sorting process is controlled in the UI side, but I just do not make to yet bug fixes like would have been reset after processing of Ajax.
And I’m going to be fixed by refactoring of the UI at the next minor version up.

There is no excuse, but, please acknowledge.

Thank you for your inquiry.

If it is using the Ajax in WordPress, you use the “wp-admin/admin-ajax.php”. Because this plugin is working all Ajax processing via the “wp-admin/admin-ajax.php”, only that file in the “.htaccess” must have been to be able to access.

Please add a description of the following to the “.htaccess” under the “wp-admin”.

<FilesMatch "(admin-ajax.php)$">
    Satisfy Any
    Order allow,deny
    Allow from all
    Deny from none
</FilesMatch>

Thank you,

Thank you for your inquiry.

Style of content, such as tables and text color that is outputting by this plugin is basically according to “bootstrap.css”. Since it is further affected by the theme of the style at the frontend, if you want to change the color please try to adjust the style theme side.

Thank you,