vtiger_faq column where ticket column is the troubletikcets vtiger_field name & vtiger_faq - column_fields $ticket_faq_mapping_fields = Array( 'title'=>'question', 'product_id'=>'product_id', 'description'=>'faq_answer', //'ticketstatus'=>'faqstatus', //'ticketcategories'=>'faqcategories' ); $sql = " select ticketid, title, product_id,vtiger_crmentity.description, solution,vtiger_troubletickets.status, category from vtiger_troubletickets inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_troubletickets.ticketid where ticketid=?"; $res = $adb->pquery($sql, array($_REQUEST['record'])); //set all the ticket values to FAQ foreach($ticket_faq_mapping_fields as $ticket_column => $faq_column) { $focus->column_fields[$faq_column] = $adb->query_result($res,0,$ticket_column); } $focus->save("Faq"); if($focus->id != '') { $description = $adb->query_result($res,0,'description'); $solution = $adb->query_result($res,0,'solution'); //Add the solution of the ticket with the FAQ answer $answer = $description; if($solution != '') { $answer .= "\r\n\r\n".$app_strings['LBL_SOLUTION'].":\r\n".$solution; } //Retrive the ticket comments from the vtiger_ticketcomments vtiger_table and added into the vtiger_faq answer $sql = "select ticketid, comments, createdtime from vtiger_ticketcomments where ticketid=?"; $res = $adb->pquery($sql, array($_REQUEST['record'])); $noofrows = $adb->num_rows($res); if($noofrows > 0) $answer .= "\r\n\r\n".$app_strings['LBL_COMMENTS'].":"; for($i=0; $i < $noofrows; $i++) { $comments = $adb->query_result($res,$i,'comments'); if($comments != '') { $answer .= "\r\n".$comments; } } $sql1 = "update vtiger_faq set answer=? where id=?"; $adb->pquery($sql1, array($answer, $focus->id)); } header("Location:index.php?module=Faq&action=DetailView&record=$focus->id&return_module=Faq&return_action=DetailView&return_id=$focus->id"); ?>