Alerts based on DB table data

  • Resolved measy

    (@measy)


    2 years, 7 months ago

    Hi 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 2 years, 7 months ago by measy.
Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Marco,

    Is this a back-end a front-end application?

    Thanks,
    Peter

    Thread Starter measy

    (@measy)

    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

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    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

    Thread Starter measy

    (@measy)

    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

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    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

    Thread Starter measy

    (@measy)

    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

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Alerts based on DB table data’ is closed to new replies.