Learn About Patents Around the World

 
 
 
IN THIS SECTION
4 posts
Maksym
Last seen: 12/05/2019 - 07:53
Joined: 10/23/2019 - 04:46
How to query

Hi,

There are patents with several cpc_group_ids, e.g. B60W  and Y10S.

I would like to find patents that have  cpc_group_id=B60W and cpc_group_id=Y10S.

But patentsview doesn't find anything.

I guess I make something wrong. 

Could you please let me know how to write a correct query?

Tue, 11/19/2019 - 09:39
PVTeam
Role: moderator
Last seen: 11/29/2024 - 15:02
Joined: 10/17/2017 - 10:47
HOW TO QUERY

Hi,

This is not a limitation of the API, but rather a limitation of the underlying data structure in the database that the API queries. The rows in the cpc_current table are at the patent level - so a patent will have a row for each different combination of section id, subsection id, group id, and subgroup id. Thus, a patent with two different cpc group ids "B6oW" and "Y10S" will have multiple, different rows in the cpc_current table.

In order to get the information you are looking for, you need to query the two cpc group ids "B6oW" and "Y10S" separately then combine the results and perform a set intersection in order to get a list of patents that have both cpc group ids "B6oW" and "Y10S".

Thanks,

PVTeam

Thu, 11/21/2019 - 08:27
Maksym
Last seen: 12/05/2019 - 07:53
Joined: 10/23/2019 - 04:46
Thanks!

Thanks!