- Mon Feb 11, 2019 2:47 am
#822853
Hi,
I upgrade Processmaker now version 3.2.1, I want to keep data APP_DOC_UID in grid,
But I don't know what variables to use.
Could you advise me?
1. I create trigger before assignment.
I upgrade Processmaker now version 3.2.1, I want to keep data APP_DOC_UID in grid,
But I don't know what variables to use.
Could you advise me?
1. I create trigger before assignment.
Code: Select all
2. But $fileId no data, Debugger show this error :
$caseId = @@APPLICATION;
$caseNo = @@APP_NUMBER;
$gridId = "contractorList"; //set to Id of grid field
$fileId = "contactFile"; //set to Id of the file field in the grid
//first delete all existing records from this case, if updating:
executeQuery("DELETE FROM PMT_MY_GRID WHERE APP_UID='$caseId' ");
//then insert a new record for each row in the "contractorList" grid
for ($rowNo = 1; $rowNo <= count(@=contractorList);$rowNo++)
{
$remark = @=contractorList[$rowNo]['remark'];
$fileNo = @=contractorList[$rowNo]['contactFile'];
$query = "INSERT INTO PMT_MY_GRID (APP_UID, APP_NUMBER, ROW_NO, remark ,APP_DOC_UID)
VALUES ('$caseId', '$caseNo', '$rowNo', '$remark', '$fileNo')";
@@retInsert = executeQuery($query);
}
Code: Select all
Could not execute update [Native Error: Duplicate entry '' for key 'PRIMARY']
[User Info: INSERT INTO PMT_MY_GRID (APP_UID, APP_NUMBER, ROW_NO, remark ,APP_DOC_UID)
VALUES ('9792480465c611712bf5648050054581', '40', '1', 'test2', '')]
Attachments
Debugger.JPG (42.5 KiB) Viewed 5371 times
Debugger2.JPG (57.67 KiB) Viewed 5371 times