Can I make (sortable) table using data from custom acf/metabox fields?

Question

Milos.J_Trafft · Answer

Hello,\u000aYes, it is possible to make tables like that sortable in our Plugin.\u000aJust please note, in regards to pulling the data, we do not have a native integration with the ACF Plugin,\u000aso that can only be done through custom MySQL query\u002Dbased tables. (https://wpdatatables.com/documentation/creating\u002Dwpdatatables/creating\u002Dmysql\u002Dbased\u002Dwpdatatables/​)\u000a\u000aA good way to achieve this can be experimenting using our WPDB SQL Query Constructor tool. (https://wpdatatables.com/documentation/creating\u002Dnew\u002Dwpdatatables\u002Dwith\u002Dtable\u002Dconstructor/generating\u002Dwordpress\u002Ddb\u002Dqueries\u002Dwith\u002Dtable\u002Dconstructor/)\u000a\u000aPlease be advised that writing custom SQL Queries or debugging Queries does not fall under what our support covers.\u000aYou can check out this official page of WP codex,  for help with writing custom Queries. (https://codex.wordpress.org/Displaying_Posts_Using_a_Custom_Select_Query​)\u000a\u000aThe sorting/or filtering may not work correctly with our server\u002Dside processing if you include:\u000a\u000a\u002DAccent graves ( \u0060 ) around the table name\u000a\u002DJOIN functions\u000a\u002DUNION functions\u000a\u002DCONCAT functions\u000a\u002Dsub\u002Dqueries\u000a\u000aSo depending on how your final Query is, if you encounter any issue with sorting,\u000ayou can try to simplify the Query for our Plugin if possible.\u000aIf none of that helps, you can try preparing a MySQL view (which will return the data that you need, call it e.g. “view1” and then build a wpDataTables based on a simple query like \u0022SELECT * FROM view1″.\u000a\u000a If you need help with that, you can see our video, where we show an example of using View in our plugin. (https://youtu.be/xCS6hlnwuZU​)\u000a\u000aKind regards.

Sociamonials

Share Sociamonials

Related questions