Conversation
supportHi Peter, for my WPDA project I need the users to be notified by the system, depending on my custom table values (kind of threshold warning), similarly to the standard WP Data Access “Successfully saved to the Database” message, or “somewhere” in the User WP home page.. I’m planning to use DB Triggers/procedures on the back-end (threshold check), but I miss the way to show the “message string” on my related WPDA project-page. Thanks in advance for any suggestion. This topic was modified 4 years, 1 month ago by measy .
Hi Marco, Is this a back-end a front-end application? Thanks, Peter
Hi Peter, presently I’m facing with back-end approach (project not published). Not yet decided if it will also be published, my test case being a kind of “admin support” system for a training centre: users will be internal to the organization, publication being an option. Thus, my alert/message would ideally appear somewhere in the user’s Dashboard home (similar to WP standard “At a Glance” box), or in an “ad hoc” WPDA project page. My data model obviously is a custom one, created and accessed by WPDA. Hope I understood/answered correctly to your question. Thanks a lot for any suggestion. Marco
Hi Marco, For the back-end you can use admin notices (native WordPress UI). This page gives a good explaination of its possibilities: https://wpmudev.com/blog/adding-admin-notices/ WP Data Access uses jQuery notify for the front-end. You can download it from here: https://notifyjs.jpillora.com/ Of download a different solution. If you want to add notices to a front-end solution using WP Data Access, you don’t need to separately install it. In that case notify is already available. Does this helps? Thanks, Peter
Hi Peter, thanks a lot for your reply. Presently I can only “argue” your hints will be helpful: I still can’t see how to connect SQL in my Triggers to HTML, namely calling the messaging function passing DB data from my post_insert Trigger check (my problem, indeed). I’ll further investigate and let you know. Regards, Marco
Hi Marco, >>> I still can’t see how to connect SQL in my Triggers to HTML You can only handle error messages from a database trigger. There is no way to add a message to your UI. But you can write messages to a message table and read the table from your code… 😉 Hope this helps, Peter
Hi Peter, actually I got the same conclusion after this afternoon “in-depth” on this issue: I’m planning to create a view which filters data according to my “threshold” level (ie, expiring contracts, or… next-week students birthday!); BUT this solution misses the “pop-up” feature. Actually, there’s a plenty of pop-up/alert/messaging plugins, no one of them seem to be open to custom feeds setup; I mean: expose a table as an interface; feed records accordingly, and having the “published” as popUp/banner/warning to Roles/Users. I only mention this as a possible future enhancement to your great data-oriented plugin. Thanks a lot for your support. Marco
Hi Marco, Is this a back-end a front-end application? Thanks, Peter
Hi Peter, presently I’m facing with back-end approach (project not published). Not yet decided if it will also be published, my test case being a kind of “admin support” system for a training centre: users will be internal to the organization, publication being an option. Thus, my alert/message would ideally appear somewhere in the user’s Dashboard home (similar to WP standard “At a Glance” box), or in an “ad hoc” WPDA project page. My data model obviously is a custom one, created and accessed by WPDA. Hope I understood/answered correctly to your question. Thanks a lot for any suggestion. Marco
Hi Marco, For the back-end you can use admin notices (native WordPress UI). This page gives a good explaination of its possibilities: https://wpmudev.com/blog/adding-admin-notices/ WP Data Access uses jQuery notify for the front-end. You can download it from here: https://notifyjs.jpillora.com/ Of download a different solution. If you want to add notices to a front-end solution using WP Data Access, you don’t need to separately install it. In that case notify is already available. Does this helps? Thanks, Peter
Hi Peter, thanks a lot for your reply. Presently I can only “argue” your hints will be helpful: I still can’t see how to connect SQL in my Triggers to HTML, namely calling the messaging function passing DB data from my post_insert Trigger check (my problem, indeed). I’ll further investigate and let you know. Regards, Marco
Hi Marco, >>> I still can’t see how to connect SQL in my Triggers to HTML You can only handle error messages from a database trigger. There is no way to add a message to your UI. But you can write messages to a message table and read the table from your code… 😉 Hope this helps, Peter
Hi Peter, actually I got the same conclusion after this afternoon “in-depth” on this issue: I’m planning to create a view which filters data according to my “threshold” level (ie, expiring contracts, or… next-week students birthday!); BUT this solution misses the “pop-up” feature. Actually, there’s a plenty of pop-up/alert/messaging plugins, no one of them seem to be open to custom feeds setup; I mean: expose a table as an interface; feed records accordingly, and having the “published” as popUp/banner/warning to Roles/Users. I only mention this as a possible future enhancement to your great data-oriented plugin. Thanks a lot for your support. Marco