Hi,
I’m trying to develop a little module for EGW (using 1.4) using etemplate and I have a little problem with the search function of the so_sql class :
I want to get an account name (egw_accounts.account_lid) to replace the owner number when my datas are displayed, so I use the search function this way :
$found = $this->search($content,False,‘fields_date’,’’,‘account_lid’,false,’’,false,’’,’, egw_accounts WHERE egw_accounts.account_id = egw_fields.owner_id’);
The query is ok (when I delete the comma from the ‘join’ parameter, I see the SQL query), but when I var_dump the returned content, it only shows me the fields of my module’s own table, although the query says “SELECT * FROM…”. Did I miss something? How can I get the account_lid values along my datas?
Thx
