codice:
Array ( [select] => SELECT DISTINCT calls.id , calls.status , calls.recurring_source , calls.name , calls.parent_id , calls.parent_type , calls.date_start , calls.assigned_user_id [from] => FROM calls [from_min] => FROM calls [where] => where ((calls.status IN ('Planned') )) AND calls.deleted=0 [order_by] => ORDER BY calls.date_entered DESC [inner_join] => LEFT JOIN calls_users c_u on c_u.call_id = calls.id ) Array ( [select] => SELECT DISTINCT meetings.id , meetings.status , meetings.recurring_source , meetings.name , meetings.parent_id , meetings.parent_type , meetings.date_start , meetings.assigned_user_id [from] => FROM meetings [from_min] => FROM meetings [where] => where ((meetings.status IN ('Planned') )) AND meetings.deleted=0 [order_by] => ORDER BY meetings.date_entered DESC [inner_join] => LEFT JOIN meetings_users m_u on m_u.meeting_id = meetings.id ) Array ( [select] => SELECT sugarfeed.id , sugarfeed.name , sugarfeed.description , sugarfeed.date_entered , sugarfeed.created_by , sugarfeed.related_module , sugarfeed.link_url , sugarfeed.link_type , sugarfeed.assigned_user_id [from] => FROM sugarfeed [from_min] => FROM sugarfeed [where] => where ( sugarfeed.related_module in ('UserFeed','Cases','Contacts','Leads','Opportunities')) AND sugarfeed.deleted=0 [order_by] => ORDER BY sugarfeed.date_entered DESC [inner_join] => ) Array ( [select] => SELECT contacts.id , LTRIM(RTRIM(ISNULL(contacts.first_name,'')+' '+ISNULL(contacts.last_name,''))) as name, contacts.first_name , contacts.last_name , contacts.salutation , contacts.title , contacts.phone_work , contacts.date_entered , LTRIM(RTRIM(ISNULL(jt0.first_name,'')+' '+ISNULL(jt0.last_name,''))) assigned_user_name , jt0.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, contacts.assigned_user_id [from] => FROM contacts LEFT JOIN contacts_cstm ON contacts.id = contacts_cstm.id_c LEFT JOIN users jt0 ON contacts.assigned_user_id=jt0.id AND jt0.deleted=0 AND jt0.deleted=0 [from_min] => FROM contacts [where] => where ((contacts.assigned_user_id = '1')) AND contacts.deleted=0 [order_by] => ORDER BY contacts.date_entered DESC [inner_join] => ) Array ( [select] => SELECT accounts.id , accounts.name , accounts.website , accounts.phone_office , accounts.billing_address_country , accounts.assigned_user_id [from] => FROM accounts LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c [from_min] => FROM accounts [where] => where ((accounts.assigned_user_id = '1')) AND accounts.deleted=0 [order_by] => ORDER BY accounts.date_entered DESC [inner_join] => )
Tralasciando i campi che non ci interessano, e concentrandosi sulla struttura, non riesco a capire che tipo di array è per poter per esempio modificare solo una delle query contenute in esso.