Hi all,
we aim to send report of finished tasks done to each technician weekly, so we want to create scheduled process for that.
I have created a client report, set up the notification message for it, and setup distribution list for it.
When I tried to run the MPM, the subtitution map I set doesn’t work.
<perform_send_notification>
<parameters>
<distr_list_id>C_TIMESHEET_TASK</distr_list_id>
<message_name>C_TIMESHEET_TASK</message_name>
</parameters>
</perform_send_notification>
The query for report dataset:
SELECT
person_id,
DATE, ID, TYPE, place_id_cust, access_group, TRAVEL_START_DATE, START_DATE, START_TIME, END_DATE, END_TIME, DURATION, BREAK_DURATION
FROM C_TIMESHEET_TASK_VIEW
WHERE person_id = @PersonId
Setup of notificaiton message:
I have tried to substitute the person_id using these options:
- Parent Tab Name = TASK_EVENT » Select Tab Name = C_TASK_PERSON_VIEW » and giving the maps to (1) TASK-EVENT: TASK_ID; C_TIMESHEET_TASK_TAB: TASK_ID (2) C_TIMESHEET_TASK_TAB: PERSON_ID; C_TASK_PERSON: PERSON_ID » Contraints: TASK_ID
The substitution map doesn’t work.
Any idea how to set the substitution for PersonId?
Just FYI, when report is executed manually, report returns correct data, i.e., based on PersonId.
Thanks in advance!
~Juni
