Unable to filter from a table based on sql

  • Resolved mikecrf121

    (@mikecrf121)


    6 years, 11 months ago

    Hi I have 2 issues so far with this plugin.
    1. I cannot filter(do filters on columns) on a table(or guess view cuz its not actually creating the table).
    So i cannot create a table based off a query??? i did a hacky thing and in the query window put the create table statement and then it does, but plugin doesnt recognize it or throws an error.

    2. if i say have 2 columns in a table, lets say user id and username, i need the username to be automatically selected when i select a user id, or vice versa if that makes sense??

    Thank you.

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

    (@wpdatatables)

    6 years, 11 months ago

    Hello there.

    Sorry for the late response.

    You can create tables using the same query that works in PHPMyAdmin, without any issues. Troubles with filtering and search usually appear when you create a table with multiple JOINs or CONCAT functions.

    2. The plugin doesn’t yet have conditional formatting between columns, so what you’re asking cannot be done with plugin’s built in features.

    Best regards.

Viewing 1 replies (of 1 total)

The topic ‘Unable to filter from a table based on sql’ is closed to new replies.