Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
Master Schedule View
I'd like to have a "master view" of all scheduled items in a given db, and, it would be great if this schedule were exposed in a (read only?) table as well, allowing me to link to it, showing the items as needed.

For example, if I have a view subscription on a given table (say, Support Tickets), I want to be able to show the schedule of subscription sends to my users, without having to make an un-linked table to do it. If it's unlinked, it becomes a bit of an admin burden, since I have to dig for the info and update the exposed-to-users table.

If anything, having all the schedule items visible in one place would be a real boon to an administrator.

Anyone else think this would be useful?
ID
1022
Category
Setup
Author

Rick Cogley
Date Created
6/15/2016 8:37:59 PM
Date Updated
6/16/2016 5:17:05 AM
Status
New Idea
Score
20
Promoted By
basenineRick Cogley
Comments
basenine 6/15/2016 9:24:29 PM
Definitely useful

I fact, if I'm reading it properly, all notifications triggers/actions in one table grouped by table would be of great benefit
Rick Cogley 6/15/2016 9:30:56 PM
Yes, grouped by table: that's even better. I guess it would need to have:

* record change notifications
* view subscriptions
* reminders

... from all tables.

Maybe there could be:

* type - record change / subscription / reminder
* related table
* related view
* period (schedule)
* offset
* date
* name
* to:
* operation
* columns
* filter
* enabled

Then maybe we create own own views as needed, since each type has different fields by their nature.
Rick Cogley 6/15/2016 9:31:54 PM
And if it's a table, one nice benefit is, you can pull it with tdbackup too, and then do something with that csv if you like.
Kirill Bondar  Staff  6/16/2016 3:23:52 AM
Rick Cogley 6/16/2016 3:25:44 AM
And there it is. Unbelievably, I've never seen that page. Thanks Kirill!
basenine 6/16/2016 3:31:39 AM
Nup. Me neither!
basenine 6/16/2016 3:58:43 AM
Between us @ Rick, we get action and results!

This new table of email notifications, grouped by table is a great idea 😜
Rick Cogley 6/16/2016 5:17:05 AM
Well, it still would be nice to have it exposed, so I can show regular users. :-)
Feedback
 
Back to Search Results