I'm trying to prototype a custom solution using your plugin with as little code as possible and I find the foreign key feature extremely useful.
There is one feature that would be even more useful and perhaps you can advise me if this is possible with any of the current shortcodes/hooks, etc. - filtering foreign key values!
Scenario is:
1. user has a read-only table with links to a "specific" page
2- when link is clicked, it forwards an ID that will be used to pre-filter a table that the user will see/edit
3. once user loads the table and starts adding/editing entries, there is a (one or more) foreign key columns that should also depend on the provided filter
Is that possible to achieve somehow? Basically, I need to see if we can filter the referenced options for the end user in a dynamic way (based on some parameter/filter/placeholder)
Let me know if you need any more information or clarification.
This is a high level of custom solution, and it is not entirely possible to achieve all the details you described.
In the first table you would make an SQL CONCAT in which you would "pack" the links with ID's , as well as GET parameters you need,
and then on the page where they output, you would place a table based on SQL Query that depends on placeholders.
Then you would have to use a hook wpdatatables_before_get_table_metadata in order to update the placeholder.
Although the table is filtered, all the values of the foreign key column would be from the linked table,
so all of this would have to include custom work.
Our developers are very busy at the moment, working on some priority tasks and fixing bugs and issues with our plugins, so they won't be having the time for custom work in the near future.
If you would require additional assistance for this solution, we can only recommend reaching out to someone who does custom solutions, such as WP Kraken, but we can't advise on their pricing.
Thanks for the reply, I think I understood the solution.
I wasn't aware I can dynamically affect the placeholder via a hook, this gives me some ideas.
Indeed, this does require some custom work, don't know if I'll have the resources to try it out myself, but in any case thanks for the advice.
Do please put this in your backlog :) The foreign key setup from the Admin panel is a very convenient mechanism, it enables a very fast setup of a relation data model, yet it requires few more features like to this to make it a truly powerful feature ;)
Sorry for the waiting time once again, we had a National Holiday in the meantime which slowed down our work.
You're welcome, i will have to thank our 2nd level Team and our developers for providing advice, all of this is well above my level of knowledge at this moment.
I will certainly keep fingers crossed that you find a solution with modifying our example, that could suit your use-case and project.
We will pass this feedback to our management and the developers as well, thank you for the suggestions.
If you wish, you can follow our changeLog page( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
Hello,
I'm trying to prototype a custom solution using your plugin with as little code as possible and I find the foreign key feature extremely useful.
There is one feature that would be even more useful and perhaps you can advise me if this is possible with any of the current shortcodes/hooks, etc. - filtering foreign key values!
Scenario is:
1. user has a read-only table with links to a "specific" page
2- when link is clicked, it forwards an ID that will be used to pre-filter a table that the user will see/edit
3. once user loads the table and starts adding/editing entries, there is a (one or more) foreign key columns that should also depend on the provided filter
Is that possible to achieve somehow? Basically, I need to see if we can filter the referenced options for the end user in a dynamic way (based on some parameter/filter/placeholder)
Let me know if you need any more information or clarification.
Hi, Hrvoje
Sorry for the delay
-
I know that we can prefilter the tables based on User's ID,
but that can be a filter that will affect only one column -
for this use-case you described, i am not sure if it is possible like that.
We will reach out to our senior Team again, and i will report back if they know of any solution to achieve what you described;
and we will let you know if any further clarification is needed.
Thank you
Kind Regards,
Miloš Jovanović
[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, Hrvoje
Just wanted to let you know we did not forget about this case.
In the meantime, it has been escalated higher, and we asked our Developers for advice.
We will see what we can do, as soon as they respond we will report back right away.
Thank you
Kind Regards,
Miloš Jovanović
[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, Hrvoje
Our developers advised us.
This is a high level of custom solution, and it is not entirely possible to achieve all the details you described.
In the first table you would make an SQL CONCAT in which you would "pack" the links with ID's , as well as GET parameters you need,
and then on the page where they output, you would place a table based on SQL Query that depends on placeholders.
Then you would have to use a hook wpdatatables_before_get_table_metadata in order to update the placeholder.
Although the table is filtered, all the values of the foreign key column would be from the linked table,
so all of this would have to include custom work.
Our developers are very busy at the moment, working on some priority tasks and fixing bugs and issues with our plugins, so they won't be having the time for custom work in the near future.
If you would require additional assistance for this solution, we can only recommend reaching out to someone who does custom solutions, such as WP Kraken, but we can't advise on their pricing.
Kind Regards,
Miloš Jovanović
[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 Miloš,
Thanks for the reply, I think I understood the solution.
I wasn't aware I can dynamically affect the placeholder via a hook, this gives me some ideas.
Indeed, this does require some custom work, don't know if I'll have the resources to try it out myself, but in any case thanks for the advice.
Do please put this in your backlog :) The foreign key setup from the Admin panel is a very convenient mechanism, it enables a very fast setup of a relation data model, yet it requires few more features like to this to make it a truly powerful feature ;)
best regards,
Hrvoje
Hi, Hrvoje
Sorry for the waiting time once again, we had a National Holiday in the meantime which slowed down our work.
You're welcome, i will have to thank our 2nd level Team and our developers for providing advice, all of this is well above my level of knowledge at this moment.
I will certainly keep fingers crossed that you find a solution with modifying our example, that could suit your use-case and project.
We will pass this feedback to our management and the developers as well, thank you for the suggestions.
If you wish, you can follow our changeLog page( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
Kind Regards,
Miloš Jovanović
[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