Search cross modules

[anhle82]

Hi all,

I'm new to SugarCRM and working on the search function for the jobs module. I want it to be able to search jobs based on how many invoices that jobs have. I'm stuck because I don't know how to define search that has relationship cross module (between job module and invoice module) and since the count of invoice is dynamic, i don't know that do i have to write some type of query to get the count or i can define it inside the searchField.php.

Thanks in advance.

[andopes]

Hi, anhle82.

The search of sugar works looking for a field inside tables, then you could create a new field into jobs (invoice_count).

I don't know other way to do this.

Cheers.

André Lopes
Lâmpada Global Services
Av. Angelica, 1814 cj. 1502
São Paulo, SP 01228-200
tel1. 55 11 3668-6776
tel2. 55 11 3822-2581
cel. 55 11 7636-5859
messenger: andopes@yahoo.com.br
skype: andopes
e-mail: andre@lampadacrm.com.br

Hi all,

I'm new to SugarCRM and working on the search function for the jobs module. I want it to be able to search jobs based on how many invoices that jobs have. I'm stuck because I don't know how to define search that has relationship cross module (between job module and invoice module) and since the count of invoice is dynamic, i don't know that do i have to write some type of query to get the count or i can define it inside the searchField.php.

Thanks in advance.