I am making some changes to the calendar and I have hit a problem
If I want to display data from a custom field from tasks_cstm it works
so I can use $act->sugar_bean->incident_location_c and display the data
but if I try the same with calls
$act->sugar_bean->location_c no data is displayed
if I do foreach($act->sugar_bean->custom_fields-> as $k=>$v) {print "$k = $v <br>";} this displays all the available fields and the values
I see for a Call that location_c is there but has no data
But if I do
$id = $act->sugar_bean->id;
$q = ("SELECT location_c from calls_cstm where id_c = '$id'");
$r = $act->sugar_bean->db->query($q);
$a = $act->sugar_bean->db->fetchByAssoc($r);
$ac = $a['location_c'];
print "LOC = " .. $a;
Then the correct data is returned
Is there a way to get the custom field without doinfg a query


LinkBack URL
About LinkBacks



Reply With Quote
Bookmarks