Validation state

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

ferhane
Posts: 1
Joined: Mon Feb 10, 2020 1:46 pm

Validation state

Post by ferhane » Mon Feb 10, 2020 2:16 pm

is it possible to extract data relating to applications which paid the validation fee for a validation states, for example MOROCCO.


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

Re: Validation state payment

Post by EPO / PATSTAT Support » Fri Feb 14, 2020 4:26 pm

Hello Ferhane,
In patstat you can retrieve some of the data on validation fees being paid for Morocco via this query:

Code: Select all

SELECT * 
FROM tls201_appln join tls231_inpadoc_legal_event 
on tls201_appln.appln_id = tls231_inpadoc_legal_event.appln_id 
where event_code = 'RAV' and extension_states like '%MA%'
order by tls201_appln.appln_id
HOWEVER, due to the way data was aggregated and processed in the past for the EP RAV code, the data in PATSTAT may be incomplete and wrong. We have fixed the problem but some corrective actions still need to be done. We anticipate that this will be reflected in the PATSTAT 2020b edition, but I can only confirm this when we have tested the new data. (Sept-Oct 2020)
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


mhaddad
Posts: 2
Joined: Tue Mar 17, 2020 1:13 pm

Re: Validation state

Post by mhaddad » Wed Jul 06, 2022 12:46 pm

I am looking for EPO's patents validated in Tunisia. I used SQL query and classic espacenet tool.
Depending on the search tool, I find different results (check pics).
Any recommendation/advice?
https://twitter.com/espacenet/status/15 ... 3364876288


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

Re: Validation state

Post by EPO / PATSTAT Support » Thu Sep 01, 2022 11:20 pm

Can you post your SQL query?
In principle, the approach is the same as for MOROCCO

Code: Select all

SELECT * 
FROM tls201_appln join tls231_inpadoc_legal_event 
on tls201_appln.appln_id = tls231_inpadoc_legal_event.appln_id 
where event_code = 'RAV' and extension_states like '%TN%'
order by tls201_appln.appln_id
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


Post Reply