IPC Classification

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
Post Reply

a497652958
Posts: 2
Joined: Tue Jun 26, 2018 6:39 pm

IPC Classification

Post by a497652958 » Thu Jul 05, 2018 7:42 pm

Hi Dear All,

I am trying to obtain all the patents under a certain IPC classification with certain criteria. It always returns with 32 million results, which I believe is the total number of patents in the world. Anyway, I did some test searching and will post some of my code (pretty simple). Would you please check it for me?

I intend to search all US and China patents under H04L29/06:

select a1.appln_id, a1.appln_auth, a4.ipc_class_symbol, a3.person_name, a3.person_ctry_code
from tls201_appln a1
left outer join tls207_pers_appln a2 on a2.appln_id = a1.appln_id
left outer join tls206_person a3 on a3.person_id = a2.person_id
left outer join tls209_appln_ipc a4 on a4.appln_id = a1.appln_id
where a1.granted = '1' and a4.ipc_class_symbol like 'H04L%29/06%' and a1.appln_auth = 'US' or a1.appln_auth = 'CN' and a3.person_ctry_code = 'US' or a3.person_ctry_code = 'CN'
(half a million results)


Later I tried to type other testing code:

select a1.appln_id, a1.appln_auth, a4.ipc_class_symbol
from tls201_appln a1
join tls209_appln_ipc a4 on a4.appln_id = a1.appln_id
where a1.granted = '1' and a4.ipc_class_symbol = 'H04L 29/06' and a1.appln_auth = 'US'
(0 results)

select a1.appln_id, a1.appln_auth, a4.ipc_class_symbol
from tls201_appln a1
join tls209_appln_ipc a4 on a4.appln_id = a1.appln_id
where a1.granted = '1' and a4.ipc_class_symbol like 'H04L%29/06%' and a1.appln_auth = 'US'
(0 results)

select a1.appln_id, a1.appln_auth, a4.ipc_class_symbol
from tls201_appln a1
join tls209_appln_ipc a4 on a4.appln_id = a1.appln_id
where a1.granted = '1' and a4.ipc_class_symbol = 'H04L 29/06' and a1.appln_auth = 'US' or a1.appln_auth = 'CN'
(32 million)

select a1.appln_id, a1.appln_auth, a4.ipc_class_symbol
from tls201_appln a1
join tls209_appln_ipc a4 on a4.appln_id = a1.appln_id
where a1.granted = '1' and a4.ipc_class_symbol = 'H04L 29/06' and a1.appln_auth = 'US'
(0 result, only thing I did is delete " or a1.appln_auth = 'cn')
(correct number)

Can someone please explain what is happening here and modify the first code for me? I would really appreciate it!

Thank you in advance!
Musso Du


Post Reply