[groakes]

Hi folks,

I am trying to store the contents of checkgroup int a report table as described in http://wiki.processmaker.com/3.1/Report ... heckgroups

I am using Community 3.2.1

But am coming up with a problem which is probably easily solveable by someone who knows what they are doing (I'm a dwarf standing on the shoulders of giants).

I have a checkgroup field named aPSEDEducationFields. I am trying to write the contents into a column called FIELD in PMT_APSED_EDUCATION_FIELDS. I have a trigger (as per below) which is executed after the Dynaform.

However, when the trigger runs it only creates one row and writes the value of the first item.

Code: Select all

$caseId = @@APPLICATION;
//look up the case number (and case status if needed):
$result = executeQuery("SELECT APP_NUMBER, APP_STATUS FROM APPLICATION WHERE APP_UID='$caseId'");
$caseNo = $result[1]['APP_NUMBER'];

//first delete all existing records from this case, if updating:
executeQuery("DELETE FROM PMT_APSED_EDUCATION_FIELDS WHERE APP_UID='$caseId' ");

//then insert a new record for each row in the "aPSEDEducationFields" checkgroup
for ($rowNo = 0; $rowNo < count(@=aPSEDEducationFields); $rowNo++) {
   $field = @=aPSEDEducationFields[$rowNo];
   $query = "INSERT INTO PMT_APSED_EDUCATION_FIELDS (APP_UID, APP_NUMBER, ROW_NO, FIELD)
      VALUES ('$caseId', '$caseNo', '$rowNo', '$field')";
   executeQuery($query);
}

All assistance is greatly appreciated.

cheers
Greg

[AlanBueno]

Hello greg, please notice that in the example from that link, they are de-encoding and encoding the checkgroup using json, this is because if you dont do that the array variable that holds the values selected only has the checked options, for example, lets say you have a checkgroup with 3 options: 1, 2, and 3; if the user checks options 1 and 3 the array holding the values will be ["true", "true"], it will not be ["true", "false", "true"] .

[amosbatto]

I suspect that your Report Table is eliminating the other rows, because Report Tables are designed to only have one row in the table per case.
You should create a separate PM Table and write to that table.