Question

FSM - Send daily notifications on Tasks completed that day

  • 18 December 2022
  • 4 replies
  • 97 views
V
Rank
Badge +5

I would like to create a scheduled notifications, this scheduled job should run on daily basis and send notifications with the number of Tasks that are completed on that day.

 

Any inputs on how this can be done in IFS FSM ?

4 replies

Shneor Cheshin
Rank
Userlevel 6
Badge +26

Hey @vineeth 

There are many ways to achieve your requirements.

One way is to create a view

create view c_my_view
as
select col1,col2,colN....
from task
where completion date = today

With a daily schedule process go over that list and trigger a notification BR to be sent.

Messages will be sent according to your configurations.

Cheers!

V
Rank
Badge +5

Hey @vineeth 

There are many ways to achieve your requirements.

One way is to create a view

create view c_my_view
as
select col1,col2,colN....
from task
where completion date = today

With a daily schedule process go over that list and trigger a notification BR to be sent.

Messages will be sent according to your configurations.

Cheers!

Hi Shneor,

Thank you for responding to my query.

I tried similar thing, as i need to send only total tasks completed this week i created view as below.

create view ar_task_completed_this_week
as
select count(te.task_id) as total from task_event te
join task t
on t.task_id = te.task_id
 where t.task_template_id = 'ar_ps_si' and te.event_type = 'completed' and te.event_dttm <= getdate() and te.event_dttm >= (getdate() - 7) 

Now, how do i trigger a notification business rule using a scheduled process and pass this ‘Total’ value to Notification Message body ?

can you help on this ?

Shneor Cheshin
Rank
Userlevel 6
Badge +26

Hey @vineeth 

The requirements are a bit different than what I thought originally.

As far as I know you cannot trigger a notification BR on a custom view.

You will need to think of another solution, that will not involve a view.

Cheers!

 

I
Rank

Do you have Lobby capability in FSM? You could create a lobby/element linked with your view, and trigger the element update at any interval you choose? Lobbies are great for this type of dynamic reporting based on queries. Put the lobby wherever it needs to be accessed.

Reply


Terms & ConditionsCookie settings