Re: [Health-dev] Joining HealthProfessional and Party models

[Luis Falcon]

Hi Mario

On Tue, 16 May 2017 18:42:23 -0400
Mario Castro Squella <address@hidden> wrote:

> Hello everyone, I’m new to Tryton and its API so I’ll explain what
> I’ve been trying to achieve without success:
> 
> I’m querying HealthProfessional address@hidden get all health
> professionals but then I would like to filter, or separate, depending
> on their occupation (separate doctors from nurses, etc.). The results
> I get from querying HealthProfessionals don’t give me information
> regarding the related Party occupation. Looking at the code I see that
> HealthProfessional has a Many2One relationship with the Party model,
> which has an occupation ID. I would like to do a simple join of the
> two tables using the domain so that way I get the health
> professional’s correct ID but also its occupation ID, with which I
> can use then to filter. Any help with this will be appreciated. :)

Check the menu "Specialties by Healh Professionals". There you can
filter by specialty / branch in medicine and healh sciences at large,
and get the list of matching health professional

The occupation at Party level is generic, not only for health sciences
but for different fields. It's the current occupation / job of a
particular person.

Bests,

> 
> Thanks,
> 
> Mario Castro Squella
> Ingeniero de Software | Registrar SW <http://www.registrar.cl/>
> +56 9 9702 8116
> 



-- 
Dr. Luis Falcon, M.D., BSc
President, GNU Solidario
GNU Health: Freedom and Equity in Healthcare
http://health.gnu.org
GNUPG Fingerprint :ACBF C80F C891 631C 68AA  8DC8 C015 E1AE 0098 9199