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
OPPOSITION OUTCOME
-
- Posts: 440
- Joined: Thu Feb 22, 2007 5:33 pm
- Contact:
Re: OPPOSITION OUTCOME
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:
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
EPO - Vienna
patstat @ epo.org
Re: OPPOSITION OUTCOME
Thank you so much for your precious help.
Best regarsds,
Elisa
Best regarsds,
Elisa