EPO - Discussion forums

Dear All,

I've met one more problem: how to lookup separately for inventors (who on my point of view
can be only real persons, not legal) and applicants - who can be both.

When I am trying to find person_name - everything is mixed there. Am I right?
How to make a query like in Espacenet where they are placed in different columns?

Regards and thanks beforehand,
Kirill.

In tls207_pers_appln there are two variables: applt_seq_nr and invt_seq_nr.
If applt_seq_nr > 0 the corresponding person_id is is an applicant.
If invt_seq_nr > 0 the corresponding person_id is is an inventor.
If applt_seq_nr > 0 and invt_seq_nr > 0 the corresponding person_id is is an applicant and an inventor (less than 10% of the records I would reckon).