I'm using wpDataTables with buddypress so I have different tables and I already using a plugin to search through different group activities and posts and taxonomies, any idea of how its possible to search through all the tables data via wordpress search.
I am sorry to disappoint You, but unfortunately a "global" page search that would search through multiple tables on the same page is not possible with the plugin's built-in features.
I cannot say if there is a plugin that would make this possible, since we have not tested any of the plugins of that kind, and also we can't guarantee that the given plugin wouldn't interfere with the tables, and in what way.
Thanks for answer, I understand, so is there a way to create a new table with like 2 column that automatically loads data from all the other tables only , for example "table name" and "first column of each table".
so we have multiple tables with 7 columns and one massive table with only 2 columns that automatically loads from all the other tables.
this way we can search through all the data!
I tried to create a new table with "Generate a query to MySQL database." but having trouble finding correct query!
My suggestion wouldn't be to generate a query, since it would pull the data from seven tables, and You'd have to use JOIN functions. If You use JOIN, then the table You're creating using a query will not be editable.
I'd suggest using foreign keys. Please see the example in our documentation, and also try out a live example on our sandbox site, where three tables have been linked into one.
I believe this will help You create what You're looking for.
Hello,
I'm using wpDataTables with buddypress so I have different tables and I already using a plugin to search through different group activities and posts and taxonomies, any idea of how its possible to search through all the tables data via wordpress search.
Thanks in advance :)
Hello abdoshajadi.
Thank You for Your purchase.
I am sorry to disappoint You, but unfortunately a "global" page search that would search through multiple tables on the same page is not possible with the plugin's built-in features.
I cannot say if there is a plugin that would make this possible, since we have not tested any of the plugins of that kind, and also we can't guarantee that the given plugin wouldn't interfere with the tables, and in what way.
Thank You for Your understanding.
Best regards.
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
Hi,
Thanks for answer, I understand, so is there a way to create a new table with like 2 column that automatically loads data from all the other tables only , for example "table name" and "first column of each table".
so we have multiple tables with 7 columns and one massive table with only 2 columns that automatically loads from all the other tables.
this way we can search through all the data!
I tried to create a new table with "Generate a query to MySQL database." but having trouble finding correct query!
Hello again abdoshajadi.
My suggestion wouldn't be to generate a query, since it would pull the data from seven tables, and You'd have to use JOIN functions. If You use JOIN, then the table You're creating using a query will not be editable.
I'd suggest using foreign keys. Please see the example in our documentation, and also try out a live example on our sandbox site, where three tables have been linked into one.
I believe this will help You create what You're looking for.
Best regards.
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