OPPOSITION OUTCOME

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

Elisa_D
Posts: 13
Joined: Wed Jan 26, 2022 10:38 am

OPPOSITION OUTCOME

Post by Elisa_D » Sun Sep 25, 2022 6:14 pm

Dear users,
did you know which is the table in PATSTAT with data on the outcome of patent oppositions? I am interested in knowing if certain oppositions have been sentenced as amendmend, rather than patent withdrawn or rejection of the opposition.
Thank you so much for your precious help
Elisa


EPO / PATSTAT Support
Posts: 425
Joined: Thu Feb 22, 2007 5:33 pm
Contact:

Re: OPPOSITION OUTCOME

Post by EPO / PATSTAT Support » Wed Sep 28, 2022 3:13 pm

Hello Elisa,
I would use one of the 2 following "proxies" to identify patent applications that resulted in "amended" patent specifications.

1) the status of the application (in reg101_appln) = 3 (--> Patent maintained as amended)
or
2) there is a B2 publication with the new European patent specification (amended specification after opposition procedure).
Both proxies work fine and give exactly the same results.

In SQL wordings:

Code: Select all

SELECT  reg101_appln.id
      ,[appln_id]
      ,[appln_auth]
      ,[appln_nr]
      ,[appln_filing_date]
      ,[filing_lg]
      ,[status]
      ,[internat_appln_id]
	  ,publn_auth
	 ,publn_nr
	 ,publn_kind
	 ,publn_date   
FROM reg101_appln join reg102_pat_publn on reg101_appln.id = reg102_pat_publn.id
where status = 3 -- or publn_kind = 'B2'
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


Elisa_D
Posts: 13
Joined: Wed Jan 26, 2022 10:38 am

Re: OPPOSITION OUTCOME

Post by Elisa_D » Thu Sep 29, 2022 11:36 am

Thank you so much for your precious help.
Best regarsds,
Elisa


Post Reply