How can I show the Last Ticket Thread to the open ticket Dashboard?

ntozier Basically what we want to see is the last communicated thread in the Dashboard for the agent. Currently, we can show the Last Thread Date but we want to show the message..

The Dashboard doesn't have any ticket thread details in it.

2 years later

function render($row) {
$text = $this->renderBasicValue($row);
if ($text && ($filter = $this->getFilter())) {
$text = $filter->filter($text, $row) ?: $text;
}

    $styles = array();
    if ($text instanceof LazyDisplayWrapper) {
        $text = $text->display($styles);
    }

    $text = $this->applyTruncate($text, $row);

    foreach ($this->getAnnotations() as $D) {
        $text = $D->render($row, $text);
    }
    foreach ($this->getConditions() as $C) {
        $text = $C->render($row, $text, $styles);
    }
    $style = Format::array_implode(':', ';', $styles);
    $nname = $this->getName();
    if( $nname == "Last Updated"){
        $sql = 'select * FROM ost_thread_entry where thread_id='.$row["ticket_id"].' ORDER BY created DESC  LIMIT 1 ';
        
        $result =  db_query($sql);
       $postername = "";
       if ($result->num_rows > 0) {
        while($row = $result->fetch_assoc()) {
          $postername = $row["poster"];
        }
        $text = $postername;
      }
     }
        
    return array($text, $style);
}

Replace this method in class.queue.php in upload/include folder.

Write a Reply...