Exporting Contacts associated with a Project

[janders0]

Hello,

I'm running Sugar 4.5.1 and I'd like to know if its possible to export the list of contacts that are associated with a Project. When I've tried the export I just get the project details and not the list of contacts which would be really useful,

I think this would be possible by modifying the export query in project.php but am unsure of the SQL statement needed. Has anyone else done this and can they let me know what the create_export_query should be changed to?

function create_export_query(&$order_by, &$where)
{
$custom_join = $this->custom_fields->getJOIN();
$query = "SELECT
project.*,
users.user_name as assigned_user_name ";

if($custom_join){
$query .= $custom_join['select'];
}
$query .= "FROM project ";

if($custom_join){
$query .= $custom_join['join'];
}
$query .= " LEFT JOIN users
ON project.assigned_user_id=users.id ";
$where_auto = " project.deleted=0 ";

if($where != "")
$query .= "where ($where) AND ".$where_auto;
else
$query .= "where ".$where_auto;

if(!empty($order_by)){
//check to see if order by variable already has table name by looking for dot "."
$table_defined_already = strpos($order_by, ".");

if($table_defined_already === false){
//table not defined yet, define accounts to avoid "ambigous column" SQL error
$query .= " ORDER BY $order_by";
}else{
//table already defined, just add it to end of query
$query .= " ORDER BY $order_by";
}
}
return $query;

Thanks very much,

James

[andopes]

Hi, James

the create_export_query is just for exporting project itself.

If you want to export the contacts related to a given project, you must create insert a Widget into Contacts Subpanel on Project.

There is a topic about it in the forum.

Cheers

--
André Lopes
Lâmpada Global Services
Rua Bela Cintra, 299 conjunto. 51
São Paulo, SP 01415-000
tel1. 55 11 3237-3110
cel. 55 11 7636-5859
e-mail: info@lampadacrm.com.br

[SamuelAugy]

here : http://www.sugarcrm.com/forums/showt...ghlight=Widget

[janders0]

That's great, I'll try inserting the widgets. Thanks for your quick help and response I appreciate it