function create_export_query

[mcgiver]

Hello sugar experts!
I want to expand the export command on my customized module (created by module builder). I have a relate field linking to accounts module. How can I export the e-mail address of linked account from my customized module?
I have found I have to create the function create_export_query, but I do not know how to do this SQL query.

Any suggestions?

Thanks
Mcgiver

[mcgiver]

anyone can help me?

[andopes]

Hi Mcgiver

 SELECT {$this->table_name}.*, {$this->table_name}_cstm.*, ea.email_address
FROM {$this->table_name}
LEFT JOIN {$this->table_name}_cstm ON {$this->table_name}.id = {$this->table_name}_cstm.id_c
LEFT JOIN email_addr_bean_rel AS eabr ON {$this->table_name}.id = eabr.bean_id AND ea.bean_module = {$this->module_dir}
INNER JOIN email_addresses AS ea ON eabr.email_address_id = ea.id AND ea.primary_address = 1
WHERE {$this->table_name}.deleted = 0 AND eabr.deleted = 0 AND ea.deleted = 0 
  

Adapt this query according to current query on the function and according to your needs.

Cheers

[mcgiver]

Hello andopes, thank you very much for your help.

I have my module called "ASK_test".
My file "ASK_test.php":

require_once('modules/ASK_test/ASK_test_sugar.php');
class ASK_test extends ASK_test_sugar {

function ASK_test(){
parent::ASK_test_sugar();
}
}

... and this is my ASK_test_sugar.php:

class ASK_test_sugar extends Basic {
var $new_schema = true;
var $module_dir = 'ASK_test';
var $object_name = 'ASK_test';
var $table_name = 'ask_test';
var $importable = false;
var $id;
var $name;
var $date_entered;
var $date_modified;
var $modified_user_id;
var $modified_by_name;
var $created_by;
var $created_by_name;
var $description;
var $deleted;
var $created_by_link;
var $modified_user_link;
var $assigned_user_id;
var $assigned_user_name;
var $assigned_user_link;
var $azienda;

function ASK_test_sugar(){
parent::Basic();
}

function bean_implements($interface){
switch($interface){
case 'ACL': return true;
}
return false;
}
}

"Azienda" is the relate field to an existing account.

Can you help me finding out what to add to ASK_test.php file? (in order to show email address of the account in extract function?)

Thanks again for your time

McGiver