EmailTemplate Variable in Subject

IdentityIQ (IIQ) IIQ Discussion and Questions
,
23

I believe i found the error, it is equal to the other error, as can be seen here:

<EventMessage>Importer failed with exception: sailpoint.tools.GeneralException: org.hibernate.exception.GenericJDBCException: could not execute statement</EventMessage>
24

@joaovrodrigues

image
image2204Ɨ720 77.2 KB

below is the error in logs

image
image2210Ɨ266 86.3 KB

1 Like
25

Thx for the feedback :grinning:. I finally understood what you where mentioning, and that does seem to be the issue. How would you go about changing the maximum character length of the subject?

26

ALTER TABLE identityiq.<table_n`ame> modify <column_name> varchar(4000);

1 Like
27

I would introduce that command in sql, right?

28

Yes you can use . its totally depend how you run sql cmd .

1 Like
29

@joaovrodrigues ,
Did it worked ?

1 Like
30

Unfortunately Iā€™m unable to make those types of changes. So I couldnā€™t test it.

31

I have another idea, I can get the quarter value from the certification name with the following code

<Subject>
  	<![CDATA[
		[CISO PT IAM] ā€“ Inicio de certificaĆ§Ć£o de acessos das Fontes AutoritĆ”rias $certification.getDisplayName().split("-")[4] $certification.getDisplayName().split("-")[5]
	]]>
</Subject>

With this code no variables are replaced when receiving the email
image

What am I doing wrong?

32

Yes if your campaign name has Quarter value you can use that too.

1 Like
33

Yeah, can confirm. The following code solves it:

<Subject>
  	<![CDATA[
		Year: $certification.getCertificationName().split("-")[4] Quarter: $certification.getCertificationName().split("-")[5]
	]]>
</Subject>

This code takes into account the certification name, being specific to my case.

34

Awesome !
Happy learning !!

1 Like