ka2

Thank you very much for reporting. Also I apologize for the inconvenience.

I will intend to research about your problem asap.

I am terribly sorry, but please wait for a while.

Please insert all filter hook codes, into the such as “functions.php” at on your theme.

Thank you,

In the latest version, it is as follows.

e.g. shortcode:

[cdbt-view table="your_created_table"]

e.g. filter hook (as like “functions.php” in your theme):

function custom_filter_get_data_sql( $sql, $table_name, $sql_clauses ) {
  if ( ! is_admin() && 'your_created_table' === $table_name ) {
    $_current_user_id = 0; // For guest user
    if ( is_user_logged_in() ) {
      $current_user = wp_get_current_user();
      $_current_user_id = $current_user->ID;
    }
    $_new_sql = <<<SQL
SELECT %s
FROM %s
WHERE user_id=%s
%s %s
SQL;
	$sql = sprintf( $_new_sql, $sql_clauses[0], $table_name, $_current_user_id, $sql_clauses[2], $sql_clauses[3] );
  }
  return $sql;
}
add_filter( 'cdbt_crud_get_data_sql', 'custom_filter_get_data_sql', 10, 3 );

Thank you,

I closed this issue because that has resolved.

I closed this issue because that has resolved.

Thank you for your inquiry.

To realize your needs, you will need a highly customizable by making full use of the filter hook and JavaScript.

About “1.”, you will want to trigger the edit button to pick up the click event at JavaScript.

About needs of “2.”, I think that may be quite difficult to achieve only in the “cdbt-edit” shortcode.

Both needs also, maybe, the best way will be handling as own components using the plugin builtin methods, rather than the shortcodes.

Thank you,

If the image and the URL is stored in separate columns, please try as following.

foreach ( $columns as $_i => $_column ) {
  $_custom_column = '';
  switch( $_column['property'] ) {
    case 'book':
      $_custom_column = 'rowData.book_url != "" ? $("<a/>").attr("href",_.unescape(rowData.book_url)).attr("target","_blank").css({display:"block",textAlign:"center"}).html("<img src=\""+_.unescape(rowData.book)+"\" height=\"150\">") : rowData.book';
      break;
    case 'book_url':
      unset( $columns[$_i] );
      break;
  }
  if ( ! empty( $_custom_column ) )
    $columns[$_i]['customColumnRenderer'] = $_custom_column;
}
$columns = array_values( $columns );

Thank you,

Yes, you can.

The following documents will be a good sample.

https://ka2.org/cdbt/v2/tutorial/#customize-shortcode

For example, if the “image_url” column in the “sample” table is stored url of image, it’s as following:

function my_shortcode_custom_columns( $columns, $shortcode_name, $table ) {
  if ( 'sample' === $table ) {
    foreach ( $columns as $_i => $_column ) {
      $_custom_column = '';
      switch( $_column['property'] ) {
        case 'image_url':
          // Add an image tag with link
          $_custom_column = 'rowData.image_url != "" ? $("<a/>").attr("href",_.unescape(rowData.image_url)).attr("target","_blank").html("<img src=\""+_.unescape(rowData.image_url)+"\">") : "-"';
          break;
      }
      if ( ! empty( $_custom_column ) )
        $columns[$_i]['customColumnRenderer'] = $_custom_column;
    }
  }
  return $columns;
}
add_filter( 'cdbt_shortcode_custom_columns', 'my_shortcode_custom_columns', 10, 3 );

please refer above code and try it.

Thank you,