Parent's field in listview

[kinshibuya]

Hi. i tryed to get some parent field usiong action_listview.php with some query.

function action_ListView()
{
$this->view = 'list'; 
$GLOBALS['view'] = $this->view; 

global $db; 
$query = "select (CASE WHEN c.priority='P0' THEN s.slacrireshw ELSE (CASE WHEN c.priority='P1' THEN s.slaaltreshw ELSE (CASE WHEN c.priority='P2' THEN s.slamedreshw ELSE s.slabaireshw END) END) END) as slareshw, " .
         "(CASE WHEN c.priority='P0' THEN s.slacriressw ELSE (CASE WHEN c.priority='P1' THEN s.slaaltressw ELSE (CASE WHEN c.priority='P2' THEN s.slamedressw ELSE s.slabairessw END) END) END) as slaressw, s.description, " .
		 "ADDTIME(SUBTIME(c.date_entered,'03:00:00'), (CASE WHEN c.type='Software' THEN (CASE WHEN c.priority='P0' THEN s.slacriressw ELSE (CASE WHEN c.priority='P1' THEN s.slaaltressw ELSE (CASE WHEN c.priority='P2' THEN s.slamedressw ELSE s.slabairessw END) END) END) ELSE (CASE WHEN c.priority='P0' THEN s.slacrireshw ELSE (CASE WHEN c.priority='P1' THEN s.slaaltreshw ELSE (CASE WHEN c.priority='P2' THEN s.slamedreshw ELSE s.slabaireshw END) END) END) END)) as vencimento " .
		 "from sup_contratosuporte s, sup_contratuporte_cases_c cstm, cases c where s.id=cstm.sup_contra8d4esuporte_ida and c.id=cstm.sup_contra20a5escases_idb and c.deleted=0 and cstm.deleted=0 and s.deleted=0 and c.id= '" . $this->bean->id . "'";
$result = $db->query($query, true);
while($row = $db->fetchByAssoc($result))
{
$this->bean->sup_contratosuporte_cases_sla_critico_resolucao_hw = $row['slareshw'];
$this->bean->sup_contratosuporte_cases_sla_critico_atendimento_hw = $row['slaressw'];
$this->bean->sup_contratosuporte_cases_descricao = $row['description'];
$this->bean->data_vencimento = $row['vencimento'] ;
}


}

this in controller.php

it works for editview. how can i get it working for listview either?

[eggsurplus]

I believe you may need to use views instead for this and in view.list.php iterate through the returned results from Sugar's list query and merge in the results from your query.

At least, that's what I could recall from something similar just a few days. I could be off though.

[andopes]

Jason suggestion may works, but the best place to accomplish such feature is the logic_hook process_record.

Best regards

[kinshibuya]

Hi!
with logic hook i can use query as well?
how can i do this with logic hook?

[kinshibuya]

I tryed this:

<?php
// Do not store anything in this file that is not part of the array or the hook version.  This file will	
// be automatically rebuilt in the future. 
 $hook_version = 2; 
$hook_array = Array(); 
// position, file, function 
//$hook_array['process_record'] = Array(); 
$hook_array['process_record'][] = Array(3,'dtvenc', 'modules/Cases/CaseLogicHook.php','CaseLogicHook', 'dtvenc'); 



?>

<?php

 if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); 

class CaseLogicHook { 
    function dtvenc(&$focus, $event, $arguments) { 
global $db;
	$query = "select s.name from cases s where s.id= '" . $this->bean->id . "'" ;
          $result = $db->query($query,true);
        //$row = $db->fetchByAssoc($result);

		$focus->data_vencimento = $result;
		$focus->sup_contratosuporte_cases_descricao = $result;
}
}
?>

It's bringin me this:

[ashishmathur]

you have commented fetch record statement and directly assigned record set to variables

//$row = $db->fetchByAssoc($result);
$focus->data_vencimento = $result;

above should be replaced by

$row = $db->fetchByAssoc($result);
$focus->data_vencimento = $row['name'];

[kinshibuya]

thanks! it works just fine know!

[mel0]

Hello , i'm new at SugarCrm and i need some help ... i read the solution and i don't know what $focus->sup_contratosuporte_cases_descricao = $result;
represent ...can you please explain how it works ? ... i want to display in ListView a new field with the phone value that is in another module