Dynamic querying or filtering of database extension on web page for all

  • Hi

    I have the FSCF on my site and it populates a table using the database
    extension.

    I’d like to make a report page where anyone can come onto the site,
    select some drop downs and have that filter the database table to produce the data they need.

    For example my “bands” contact form collects info on bands such as
    area located and genre of music.

    I’d like a page where anyone can select an area and genre of music and it produces the filterd results on the webage.

    I can get the whole table on a page using [cfdb-table form=”Bands”
    show=”from_name,subject,ex_field1″] but cannot find any help in adding
    a dynamic drop down filter.

    Thanks
    Mike

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    You would need to use [cfdb-datatable] and use the dt_options to try to pull in DataTable features like a search box like the one you see on the admin panel. If you want to use your own controls (drop downs and such) then you would have to put them in and hook up their Javascript events (like “onchange”) to make calls on the DataTable API to filter it. You need some Javascript/jQuery knowledge and to look at the DataTables documentation to figure out how to hook it up.

    Thread Starter Mike_ox

    (@mike_ox)

    Thanks for your reply.

    I’m now using the WP Tables Reloaded plugin. I can’t get this working successfully either

    I can only get the sort function to work using the tablesorter library.

    I really want the search and Pagination functions. I’ve changed the library to DataTables+TableTools and tried the defualt DataTables and selected the relevant option in the table editor but nothing works.

    If I can get my table working like the demo table on this site: https://tobias.baethge.com/wordpress-plugins/wp-table-reloaded-english/
    That would be awesome

    My theme does have <?php wp_footer(); ?> in the footer.

    Anyone know why This isn’t working?
    Thanks
    Mike

    Plugin Author Michael Simpson

    (@msimpson)

    Sounds like you should post this question on the support forum for WP Tables Reloaded plugin

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Dynamic querying or filtering of database extension on web page for all’ is closed to new replies.