KnowledgeSync Ideas
Ideas for the KnowledgeSync software product including EventPaks.
Ideas for the KnowledgeSync software product including EventPaks.
Ideas for the KnowledgeSync software product including EventPaks.
Currently we are restricted to schedules based on generic time/days/weeks/month.
It would be good if we could add a custom schedule that was powered by a query as to when the next run DateTime should be.
A query could be created that returns one row and one DateTime column of {NextScheduleRunTime}. The Allowed Range would come from the existing tabs.
For example:
We have a Missing Timesheet alert, currently it runs every Monday at 9am. But really we want it to run it the day after the end of the current accounting period, as where the month end date falls within the week the accounting period ends and everyone needs their timesheet in. For us to make this work currently, we have to add a custom SQL view to join to the existing logic into a filter of the missing timesheet query itself.
This is not the right place for it. It makes it hard to edit the query as you cannot preview it as no results are passed back unless it is the day after the last accounting period. You have to delete the filter to edit and test the alert, and then add it back in. Also the logic required in the query filter is complex and hard to understand by customers or future consultants, it also conflicts with the event schedule which is set everyday.
Having worked out the solution, we are unhappy with it and do not supply this to customers as it is too complex and hard to maintain.
Having custom schedules as part of the event which is linked to a query would be a much better solution.
Peter Holcroft
I can see no mention of web hooks in the manual. We are using v10.06.02.
This is an enhancement request to improve the user experience, not to find a workaround.
We write complex alerts for non technical customers and tell them they can change the basics, e.g. schedule, email content and subscribers themselves. As it stands customers cannot change schedules without expert help if we implement a non default schedule.
Simplicity of scheduling is a core feature of KnowledgeSync. This would enhance that core feature.
How would a web hook help in this situation?
There are workarounds as mentioned, job streams is another, but the issue is mainly a usability one. These are complex solutions to something we want to simplify for users.
I want to be able to write the SQL query to decide if today is the scheduled day and hide this behind a simple schedule item which can be picked from a list by users creating alerts.
Web hooks were implemented to handle this use case. Please see if web hooks will work.