I'm not sure that I understand your request fully. If I'm not mistaken, you want to pass only a certain number of columns to the front-end while keeping the entire table structure in the back-end?
If that's true, something like this is not possible with the plugin's built-in features, as the plugin is a WYSIWYG (What You See Is What You Get) concept-based plugin. This means that the table should look the same both in the back-end and in the front-end. So, the columns you see in the front-end are the same columns you see in the back-end.
You can create a few tables using the same source (MySQL query-based tables), where you would pull only certain columns, and then use the shortcodes of those newly created tables to display different tables (with different columns) in the front-end.
Hi
Is there a developer article or some article which can help me with filtering of columns.
I want to have a dropdown or multiselect of columns names and user can select few of them and datatable will show that much of data in front end.
Rest wpdatatable and its advance filtering works for me but this one is where i am stuck at.
Hello Fahim
Thank you for your purchase.
I'm not sure that I understand your request fully. If I'm not mistaken, you want to pass only a certain number of columns to the front-end while keeping the entire table structure in the back-end?
If that's true, something like this is not possible with the plugin's built-in features, as the plugin is a WYSIWYG (What You See Is What You Get) concept-based plugin. This means that the table should look the same both in the back-end and in the front-end. So, the columns you see in the front-end are the same columns you see in the back-end.
You can create a few tables using the same source (MySQL query-based tables), where you would pull only certain columns, and then use the shortcodes of those newly created tables to display different tables (with different columns) in the front-end.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Its a simple table and we are passing all columns in front end.
User wants to see few columns of its choice in front end so that he see a more compact view and can enter data easily in excell like view.
Is there a option to choose columns in front and fix few columns which cant be removed ... I hope i am clear enough.
Please close this ticket i was able to get the column visibility at front end.
Hello Fahim
Thank you for letting us know.
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables