Question

Sending Report

JuniSihombing
Rank
Userlevel 4
Badge +11

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:

  2.  

  1. 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

6 replies

H
Rank
Userlevel 5
Badge +13

hi @JuniSihombing,

 

Could you send us the screenshot of Distribution list page as well?

 

Thanks,

Hasara

Anjula Priyanath
Rank
Userlevel 6
Badge +14

Hi @JuniSihombing,

As per screenshots, those configurations are looks good. Did you set the WILD CARD MEMBER in Distribution list? If not, you need to select the correct substitution map there. But, your custom substitution map won’t be shown there until you create the record in WILD_CARD_MEMBER in the code table.

Distribution List

 

WILD_CARD_MEMBER code table

 

Anjula
JuniSihombing
Rank
Userlevel 4
Badge +11

 

Hi @Hasara Dinu, @Anjula Priyanath,

 

for testing at moment, the distribution list I set only to send to me. It works.  I got the email.  

 

But the substitution map for person-id does not work..

The attachment/report contains no data.

Anjula Priyanath
Rank
Userlevel 6
Badge +14

Hi @JuniSihombing,

For that, you need to set the Wild Card Member as my previous comment.

Did you follow those steps?

Anjula
JuniSihombing
Rank
Userlevel 4
Badge +11

Hi @Anjula Priyanath ,

I did, but didn’t work before.

Let me try again, and will let you know the outcome.

Until later,

~Juni

H
Rank
Userlevel 5
Badge +13

Hi @JuniSihombing,

If any of the above not work, please check with below modifications as well. (just a suggestion 😊)

In your substitution map, do the below modifications.

parent tab name = ‘C_TASK_PERSON_VIEW’. 

select Tab name = ‘PERSON’

select Column name = ‘EMAIL_ADDRESS’

You have to modify the relation map definition also as per the above modification in substitution map.

In relation map, Primary table = ‘C_TASK_PERSON_VIEW’. 

Related table = ‘PERSON’

Thanks,

Hasara

Reply


Terms & ConditionsCookie settings