Comment for consult in campaign

[ejeong]

hello All

When consult is selected in campaign, comment is required.

Please let us know where this comment is stored. (campaign.comment or certification.comments}

We used ${campaign?.comment} to show this in email but didnt work..

Can anyone help us please? We checked all variable available but it seems we cant see any variable for comment but i found we can use campaign object and cerification object. Does this mean i can use all column in these two tables?

[Srinivas]

Hello @ejeong

I think this info gets stored into the AUDITTRAIL column in various tables depending on type of the certification item..
certification_user_status
certification_account_entitlement1_status

Hope this helps

Thanks & Regards

Srinivas

[rushikeshvartak]

Try running below code in email body to find variables exposed

${this.binding.variables.each {k,v -> println "$k = $v" + "<" + "br" + ">"}}

[ejeong]

I tried this but couldnt see the comment in option

[rushikeshvartak]

share output of above code

[ejeong]

manager = PQ139081
certificationUsers = PQ139106
delegateEmail =
originalCertifier = PQ008475
campaign = com.saviynt.ecm.campaign.domain.Campaign : 614
campaignOwnerAndTheirDelegateEmailList = xxxxx@xxxxx.com
usersManager = PQ139081
users = PQ007272
secondarycertifier =
certification = com.saviynt.ecm.campaign.domain.Certification : 33560
out = java.io.PrintWriter@822507e
[manager:PQ139081, certificationUsers:PQ139106, delegateEmail:, originalCertifier:PQ008475, campaign:com.saviynt.ecm.campaign.domain.Campaign : 614, campaignOwnerAndTheirDelegateEmailList:xxxxxx@xxxxxxx.com, usersManager:PQ139081, users:PQ007272, secondarycertifier:, certification:com.saviynt.ecm.campaign.domain.Certification : 33560, out:java.io.PrintWriter@822507e]

[rushikeshvartak]

You need to use com. varaiables to find this information

Raise saviynt freshdesk ticket to get package name

it should be certification.certification_user_status.audittrail

(This needs to be done using saviynt package name )

[ejeong]

thanks. what would be stored in Comment column? we would like to show comment msg that was entered by original certifier

[rushikeshvartak]

It will be datetimestamp username then actual comment

you can query and check same