Click HERE to see how Saviynt Intelligence is transforming the industry. |
03/06/2023 11:15 PM
Hi,
we are trying to fetch details of analytics report in email as following:
so in log it says Missing Property exception. Am I missing something? Please do help.
Thank you,
Harsha
03/06/2023 11:23 PM - edited 03/06/2023 11:24 PM
In your email template space is missing between FirstName and LastName, please try following sample with space.
Body:${ANALYTICSDATA.'First Name'[0]} ${ANALYTICSDATA.'Last Name'[0]}
For more details on email templates please refer to following document : https://docs.saviyntcloud.com/bundle/EIC-Admin-v232/page/Content/Chapter06-EIC-Configurations/Creati...
03/06/2023 11:34 PM
Hello,
Yes we tried both ways by giving space and by removing it but error is still the same Missing property exception.
03/06/2023 11:38 PM
Please share the complete template.
03/07/2023 12:08 AM
Hi,
Thank you for your quick response.I am just testing analytics mail, so this is the complete template is as following
Email body:
Hi,
Please find below the details:
First Name- ${ANALYTICSDATA.'First Name'[0]}
Last Name- ${ANALYTICSDATA.'Last Name'[0]}
Please let me know why ANALYTICSDATA is not supporting, following is the error in logs:
023-03-07T08:04:50.832961538Z stdout F 2023-03-07 08:04:50,832 [http-nio-8080-exec-329] DEBUG println.PrintlnToLogger - Println :: [1;31m| Error [22;39mgroovy.lang.MissingPropertyException: No such property: ANALYTICSDATA for class: SimpleTemplateScript325[m
Thank you,
Harsha
03/07/2023 12:15 AM - edited 03/07/2023 12:16 AM
In your email template please use only ${ANALYTICSDATA} do not use any other attributes.
----------------------
Hi,
Please find below the details:
${ANALYTICSDATA}.
----------------------
Could you please let me know the test result is success or failure.
If success, what is the result set.
If failure, please share error.
03/07/2023 12:38 AM
Hello,
mail was sent successfully but resultset is blank
below is email template:
Also analytics is not empty, it has 1 record. Below is analytics query:
select u.username, u.firstname as 'First Name', u.lastname as 'Last Name', u.email, u.startdate, u.enddate, (select u1.email from users u1 where u.manager=u1.userkey) as 'Manager Email' from users u where u.customproperty30 in ('GUEST') and u.enddate between CURDATE() and CURDATE()+24
below is report:
Please let me know, if you have any idea what is the issue.
Thank you,
Harsha
03/07/2023 01:03 AM - edited 03/07/2023 01:16 AM
In global config, Group emails by username.
If still facing issue request you to open FreshDesk ticket with support team and share this forum post for reference.