Okay
  Public Ticket #1062724
Filters not working when using "front end editing" option
Closed

Comments

  •  2
    Ankur Govil started the conversation

    Hi,


    I am facing an issue where if I make my table editable from front end, in that case the "filters under each column" or advanced filters are not working and neither they are displayed . Please help with this issue as I am getting stuck on the same.


    Regards

    Ankur Govil 

  • [deleted] replied

    Hi Ankur Govil,
    Thank you for the purchase.

    Please send me a link of the page where you have your table displayed and also please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check PRIVATE so nobody can see it except us.

  •   Ankur Govil replied privately
  • [deleted] replied

    Hi Ankur Govil,

    What type of wpDataTables are you using? Mostly filters are not working when you are using MySQL based tables that have server-side processing enabled. If that is the case you'll have to create MySQL View from your query in the database and after that use that MySQL View as table input.

    You can take a look at this link how to create MySQL View - Link. After that you'll just have to create a table e.g. SELECT * FROM view_name