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!

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

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 ?

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!

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.