[Student]

Hello,

I am currently having trouble displaying the title of the project on the output document when receiving it as a pdf. The data also does not appear inside the pdf. I am uncertain if it's an issue with the database or if the trigger is wrong. Has anyone encountered this issue?

The trigger for sending an email with the output document

$docId = '315355263615cb11e95f7e9005773565'; //set to the Output Document's unique ID
$caseId = @@APPLICATION;
PMFGenerateOutputDocument($docId);
$sql = "SELECT DISTINCT APP_DOC_UID FROM APP_DOCUMENT WHERE APP_UID='$caseId' AND DOC_UID='$docId'";
$aNewDoc = executeQuery($sql);

if (empty($aNewDoc)) {
throw new Exception("Error: Unable to generate Output Document with ID '$docId'.");
}
else {
$fileId = $aNewDoc[1]['APP_DOC_UID'];
$oDoc = new AppDocument();
$aDocInfo = $oDoc->load($fileId);
$ext = '.pdf'; //set to '.doc' if sending a DOC file
$g = new G();
$pathToFile = PATH_DOCUMENT . $g->getPathFromUID(@@APPLICATION) . PATH_SEP . 'outdocs' .
PATH_SEP . @@Placa .
PATH_SEP . $fileId . '_' . $aDocInfo['DOC_VERSION'] . $ext;
$filename = $aDocInfo['APP_DOC_FILENAME'] . $ext;
$aAttachments = array(
$filename => $pathToFile
);

$to = ' admin@processmaker.com'

@@msg = PMFSendMessage(@@APPLICATION, ' student@gmail.com', $to, '', '',
'Testing Subject', 'email_Info.html', array(), $aAttachments);
}

Thank you

[kirkwg]

Hello, I don't know how to help. Some how can you try to follow the ProcessMaker document in below to see if able to fix your issues. As your code is slightly different from the official doc. So worthy to try:

doc link: https://wiki.processmaker.com/3.2/ProcessMaker_Functions/Email_Functions
also see attached screenshot:

Also note that:
1/ you got $filename = $aDocInfo['APP_DOC_FILENAME'] . $ext; //.pdf only > meant $aDocInfo['APP_DOC_FILENAME'] not work
2/ Try to use the SELECT statement from the official doc or see my attached

Anyway, good luck..

[Student]

Thank you kirkwg for your response. I will try this out.