Question

Triggering Email Notification monthly and weekly in FSM

  • 17 January 2023
  • 1 reply
  • 96 views
M
Rank
Userlevel 3
Badge +6

Hi Team , 

Can Anyone Suggest Me an idea to achieve  the below requirement .

 

requirement:

I need to create  a Schedule Process  which will run during month end .to all the places which request has been created on that Month 

Add the report as an attachment to the email and send.
Report Parameters to be sent :
Date from: 1st of that month 00:01 Hrs
Date to : end of that month 23:55
 

Distribution List : place email address 

 

I have Created the schedule process for monthly and calling the perform notification MPM in schedule process but the excepted output of the report is not generated since the parameter constraint is not getting applied to report when notification message is triggered.

thanks


 

 

 

1 reply

ALFA
Rank
Userlevel 1
Badge +4

Hi @Muthujayashree  maybe you can take the problem by the other side and create a view that only display the values you want. For example with the following sql : select * from  request where month(created_dttm) = month(GETDATE()) AND YEAR(created_dttm) = YEAR(GETDATE()) where place_id = '{0}'

Then you could base your report and scheduled process on this so you are sure to only get the value expected and you do not even need those report parameters.

Reply


Terms & ConditionsCookie settings