• Resolved yarsky

    (@yarsky)


    Creating table:
    SELECT posts_page.post_title AS page_post_title,
    posts_page.post_type AS page_post_type,
    wp_users.display_name as user
    FROM wp_posts AS posts_page
    inner join wp_users on wp_users.id = posts_page.post_author
    WHERE 1=1
    AND posts_page.post_type = ‘page’

    Config filter to ‘selectbox’ on column user

    Error in log:
    Unknown column ‘wp_posts.user’ in ‘where clause’ for query SELECT SQL_CALC_FOUND_ROWS posts_page.post_title AS page_post_title, posts_page.post_type AS page_post_type, wp_users.display_name AS user FROM wp_posts AS posts_page INNER JOIN wp_users ON wp_users.id = posts_page.post_author WHERE 1 = 1 AND posts_page.post_type = ‘page’ AND wp_posts.user LIKE ‘%admin%’ ORDER BY page_post_title ASC LIMIT 10

Viewing 1 replies (of 1 total)
  • Plugin Author wpDataTables

    (@wpdatatables)

    Hello there.

    We’re sorry, but editing and SQL Query based tables are not included in the Lite (free) version of the plugin, so we cannot provide any support for those through this forum.

    Please feel free to open a ticket on our official support platform (accessible from our official website), and we’ll gladly help you out there.

    Even if your support expired, you can open a pre-purchase ticket where a purchase code is not required, so our support managers can help you out with this.

    Kind regards.

Viewing 1 replies (of 1 total)
  • The topic ‘InnerJoin and Filtering’ is closed to new replies.