Please help I want to see logs of user that add entry on my table based on there given roles. I only saw on how to see their name if adding a user id but I also want them to see the whole tables not only the entry that they made.
Thank you for the reply, What I mean by logs is whenever User role "Editor" added an entry and role "Subscriber" I will see the name of that role and what rows did they add or edit. Is that possible?
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( 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.
-
The only similar solution / custom workaround we have is,
we found an example from another user who wanted to send emails with the edited data,
with using a hook.
Here is what the developers advised him, i hope this might help you :
This action is executed after editing action is applied.
$formdata is the array of keys and values for editing.
$rowId is the ID field of the row in MySQL table that was edited.
$tableId is the table identifier from the MySQL plugin table (wp_wpdatatables).
For example:
function sendEmailAfterEdit( $formdata, $rowId, $tableId ){
// create logic for sending emails
}
add_action('wpdatatables_after_frontent_edit_row', 'sendEmailAfterEdit',10,3);
will be triggered in both cases when you edit or adding a new row in the table from front-end. Please note that data is already saved in database.
-
If you have coding knowledge, you can use this and try to adapt it for your use-case.
-
If you need help with that, 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.
We can recommend reaching out to someone who does custom solutions, such as WP Kraken, but we can't advise on their pricing.
Please help I want to see logs of user that add entry on my table based on there given roles. I only saw on how to see their name if adding a user id but I also want them to see the whole tables not only the entry that they made.
Hi, Venice Ann Cuevas
Sorry for the delay
-
My apology, but it seems i am not fully understanding what the goal is.
When you see you want to see logs of users who added entries, based on their role,
what exactly do you mean by "logs"?
- Perhaps you want to have the information that can show you which user roles made which entries/rows?
-
We currently don't have any built-in functionality to have one dynamic table that can achieve this,
but maybe there can be a workaround with creating multiple tables on multiple pages.
-
For example, let's say we have a role "Editor" and a role "Subscriber".
If you want the users to see all rows, but just to be able to edit rows that are "for their role",
then you can make one main "source table" as a Manual Table,
and make other SQL tables that pull data from it,
then for each SQL table you can set different Editor Role.
( You can find what is the main/source database table name, under Editing Tab, then you can call SQL Queries like :
SELECT * FROM table_name)
-
So, on page 1, we can set SQL Table 1 ( Name it something like "Table for Editors") , set Editor Roles only for "Editor",
then a user with Editor Role can see all rows, but they can also edit this table - no other user roles can edit it.
-
Then, on page 2, we can set SQL table 2 ( Name it something like "Table for Subscribers"), set Editor Role only for Subscriber,
then only Subscribers can edit that table, and so on...
-
Let me know if that could be a workaround solution for you?
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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š,
Thank you for the reply, What I mean by logs is whenever User role "Editor" added an entry and role "Subscriber" I will see the name of that role and what rows did they add or edit. Is that possible?
Hi, Venice
Sorry to disappoint you, but at this time, we don't have a built-in feature to achieve this.
If you'd like to see a built-in solution in the future,
please feel free to search on our suggestions page,
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( 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.
-
The only similar solution / custom workaround we have is,
we found an example from another user who wanted to send emails with the edited data,
with using a hook.
Here is what the developers advised him, i hope this might help you :
-
For sending emails, you can use this:
https://www.a2hosting.com/kb/installable-applications/optimization-and-configuration/wordpress2/sending-e-mail-in-wordpress#:~:text=To%20send%20an%20e%2Dmail,authentication%20settings%20you%20defined%20above
And to take values after Apply is hit, there's this hook:
wpdatatables_after_frontent_edit_row( $formdata, $rowId, $tableId )
This action is executed after editing action is applied.
$formdata is the array of keys and values for editing.
$rowId is the ID field of the row in MySQL table that was edited.
$tableId is the table identifier from the MySQL plugin table (wp_wpdatatables).
For example:
will be triggered in both cases when you edit or adding a new row in the table from front-end. Please note that data is already saved in database.
-
If you have coding knowledge, you can use this and try to adapt it for your use-case.
-
If you need help with that, 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.
We can 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
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Please close this ticket.
Hi, Venice
No problem, we will close this one, and we will keep working on the other ticket.
Of course, please don't hesitate to open new tickets for any new questions you might have.
Thank you
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Thank you! Can you check my other ticket as well I posted an inquiry on that.
Hi, Venice
Of course, we will follow through with the other ticket.
Thank you
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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