Applications in B25J/Y10S but not B60W/B60K/B60L
Posted: Tue May 29, 2018 8:56 am
Dear PATSTAT user forum,
I am looking into robot technologies and am starting out my analysis in the B25J and Y10S classes to start things off.
However, I am already now aware that for my purposes I am not interested in robotics technologies in relation to cars. Accordingly, I woulk like to eliminate the data subset being classified both in B25J/Y10S and one of B60W, B60K, B60L and B60Y.
For this purpose I used the NOT IN operator but when I use the statistics option in patstat online and select the parameters as CPC or IPC vs Applicant, there are still Bubbles corresponding to the classes I tried to eliminate (B60W, B60K, B60L and B60Y).
The database used is Patstat online spring 2018 edition and my search query is the following:
Select
tls201_appln.earliest_filing_year,
tls201_appln.appln_id
FROM tls201_appln
JOIN tls207_pers_appln
ON tls201_appln.appln_id = tls207_pers_appln.appln_id
JOIN tls206_person
ON tls206_person.person_id = tls207_pers_appln.person_id
JOIN tls226_person_orig
ON tls206_person.person_id = tls226_person_orig.person_id
JOIN tls209_appln_ipc
ON tls209_appln_ipc.appln_id = tls201_appln.appln_id
JOIN tls224_appln_cpc
ON tls224_appln_cpc.appln_id = tls201_appln.appln_id
WHERE
IPR_type = 'PI'
And tls201_appln.earliest_filing_year between '2010' and '2020'
AND (LEFT(ipc_class_symbol, 4) = 'B25J' OR LEFT(cpc_class_symbol, 4) = 'B25J' OR LEFT(cpc_class_symbol, 4) = 'Y10S')
AND LEFT(ipc_class_symbol, 4) not in ('B60W','B60L','B60K')
AND LEFT(cpc_class_symbol, 4) not in ('B60W','B60L','B60K', 'B60Y')
GROUP BY
tls201_appln.earliest_filing_year,
tls201_appln.appln_id
ORDER by
tls201_appln.earliest_filing_year
I know that the 'NOT IN' reduced the total search hits, but I must either be missing something or the patstat statistics panel might not belimited to the particular dataset returned by the search query?
Can anyone offer any insights as to what might have gone wrong?
Best regards,
Joachim
I am looking into robot technologies and am starting out my analysis in the B25J and Y10S classes to start things off.
However, I am already now aware that for my purposes I am not interested in robotics technologies in relation to cars. Accordingly, I woulk like to eliminate the data subset being classified both in B25J/Y10S and one of B60W, B60K, B60L and B60Y.
For this purpose I used the NOT IN operator but when I use the statistics option in patstat online and select the parameters as CPC or IPC vs Applicant, there are still Bubbles corresponding to the classes I tried to eliminate (B60W, B60K, B60L and B60Y).
The database used is Patstat online spring 2018 edition and my search query is the following:
Select
tls201_appln.earliest_filing_year,
tls201_appln.appln_id
FROM tls201_appln
JOIN tls207_pers_appln
ON tls201_appln.appln_id = tls207_pers_appln.appln_id
JOIN tls206_person
ON tls206_person.person_id = tls207_pers_appln.person_id
JOIN tls226_person_orig
ON tls206_person.person_id = tls226_person_orig.person_id
JOIN tls209_appln_ipc
ON tls209_appln_ipc.appln_id = tls201_appln.appln_id
JOIN tls224_appln_cpc
ON tls224_appln_cpc.appln_id = tls201_appln.appln_id
WHERE
IPR_type = 'PI'
And tls201_appln.earliest_filing_year between '2010' and '2020'
AND (LEFT(ipc_class_symbol, 4) = 'B25J' OR LEFT(cpc_class_symbol, 4) = 'B25J' OR LEFT(cpc_class_symbol, 4) = 'Y10S')
AND LEFT(ipc_class_symbol, 4) not in ('B60W','B60L','B60K')
AND LEFT(cpc_class_symbol, 4) not in ('B60W','B60L','B60K', 'B60Y')
GROUP BY
tls201_appln.earliest_filing_year,
tls201_appln.appln_id
ORDER by
tls201_appln.earliest_filing_year
I know that the 'NOT IN' reduced the total search hits, but I must either be missing something or the patstat statistics panel might not belimited to the particular dataset returned by the search query?
Can anyone offer any insights as to what might have gone wrong?
Best regards,
Joachim