Help with CPC

[talya.ponchek]

Hello,
I've read all the threads on CPC search here.
I have constructed the following query (this is just for getting a feeling with how to work with patstat):
select tls201_appln.appln_id, appln_auth, appln_nr, appln_kind, appln_filing_date, granted, nb_citing_docdb_fam, cpc_position, cpc_class_symbol
from tls201_appln join tls224_appln_cpc on tls201_appln.appln_id = tls224_appln_cpc.appln_id
where
tls201_appln.appln_id in (select distinct appln_id from tls224_appln_cpc where cpc_class_symbol = 'B60L 11/1881')
I received zero results.
Can you please tell me if I'm doing anything wrong. I wasn't expecting zero results.
Thanks!
Talya

[mkracker]

I copied your query and just made sure that there are 2 spaces between the CPC subclass part 'B60L' and the CPC subgroup part '11/1881'. Then the query returned 24 991 rows in the PATSTAT 2015 Autumn Edition.

Code: Select all

select tls201_appln.appln_id, appln_auth, appln_nr, appln_kind, appln_filing_date, granted, nb_citing_docdb_fam, cpc_position, cpc_class_symbol
from tls201_appln join tls224_appln_cpc on tls201_appln.appln_id = tls224_appln_cpc.appln_id
where tls201_appln.appln_id in 
   (select distinct appln_id from tls224_appln_cpc 
   where cpc_class_symbol = 'B60L  11/1881')

The format of the CPC symbol in PATSTAT is the same as the format of the IPC symbol. For a detailed explanation please see this forum entry: "Question about search for IPC_class_symbol" (patstat/topic4767.html)

Best regards,
Martin

[talya.ponchek]

Dear Martin,
Thank you so much for the help!
Best,
Talya

[talya.ponchek]

Dear Martin,
I have a follow-up question.
Why when I use both CPC and IPC codes in the same search using "and" I'm getting fewer results.

This is the query:
select distinct
app.*
from
TLS201_APPLN app,
TLS224_APPLN_CPC cpc,
TLS209_APPLN_IPC ipc
where 1=1
and app.appln_id=cpc.appln_id
and app.appln_id=ipc.appln_id
and app.ipr_type='PI'
-- and app.granted=1
and app.appln_auth in ('DE','IL')
and cpc.CPC_CLASS_SYMBOL in (
'H01M 10/00',
'H01M2010/00',
'H01M 6/00',
'H01M 2/00',
'H01M 8/00',
'Y10S 977/948',
'H01M 12/00',
'Y02E 60/12',
'B60L2240/54',
'B60Y2400/112',
'B60Y2400/114',
'Y02T 10/7005',
'Y10S 903/908',
'Y10S 903/903',
'B60L 11/1851',
'B60L 11/1881',
'B60L 11/1879',
'Y02T 10/6273',
'Y02T 10/7072',
'B60Y2300/91',
'H02J 7/00',
'H02J 7/0027',
'G01R 31/36',
'Y10S 320/00',
'Y10S 320/21',
'Y10S 320/12',
'H02J2007/00',
'H02J 7/14',
'B60Y2400/435',
'Y02T 10/7072',
'G01R 31/3624',
'G01R 31/3606',
'B60L 11/1809',
'Y02T 90/10',
'B60L2230/00',
'Y02T 90/12',
'Y02T 90/14',
'Y02T 90/16',
'Y02T 90/167',
'Y02T 90/163'
)
--and ipc.IPC_CLASS_SYMBOL in ('H01M 6/00','H01M 2/00','H01M 8/00','H01M 10/00','H01M 12/00')
--and ipc.IPC_VALUE='I'

When I add the last 2 rows I get only 507 results whereas without them I have 7,901 results.
Thanks in advance,

Talya

[nico.rasters]

If you say CPC IN (A,B,C,D,E) AND IPC IN (A) then the IPC IN (A) part will severely cut down the results.
AND does not add things. You'll need OR for that.
I wouldn't mix IPC and CPC like this anyway. Also note that the coverage may vary, as CPC is the new classification. I think I saw a graph in one of the posts here pointing it out.

Btw, since you are exploring the database, here's a tip. If WHERE cpc_class_symbol = 'B60L 11/1881' gives you zero results then you could have done SELECT DISTINCT cpc_class_symbol FROM tls224_appln_cpc WHERE cpc_class_symbol LIKE "B60L%"; just to inspect what's going on. Or leave out the WHERE clause entirely.
Also note that the IPC classes are based on version 8 of the IPC. This is nice if you are using some old articles with IPC based definitions, but not so handy if you are building your own definitions based on the most recent version at WIPO.