Event_descr missing in 2021 Spring edition

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

Eduardo Mercadante
Posts: 6
Joined: Thu Sep 17, 2020 12:04 pm

Event_descr missing in 2021 Spring edition

Post by Eduardo Mercadante » Thu May 13, 2021 11:44 am

Hello,

I was updating my sample of legal event data (tls231_inpadoc_legal_event) and for some reason the variable event_descr is missing. I have made other queries just to test and none has retrieved this value. If I ask directly for it, the system indicates invalid column name. If I ask for all columns (*), it is missing.

Is this an error or has this variable been dropped from the table? It is very hard to understand the data without it.

Best regards,
Eduardo Mercadante
PhD Candidate at LSE


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

Re: Event_descr missing in 2021 Spring edition

Post by EPO / PATSTAT Support » Fri May 14, 2021 8:08 am

Hello Eduardo,
Indeed, the column is not included in tls231_inpadoc_legal_event in PATSTAT (but that is normal).
You can link to tls803_legal_event_code via a join using the event_auth AND the event_code.
Below is an example on how to do this.

Code: Select all

SELECT top 10 * from tls231_inpadoc_legal_event
join tls803_legal_event_code 
on tls231_inpadoc_legal_event.event_auth = tls803_legal_event_code.event_auth
AND tls231_inpadoc_legal_event.event_code = tls803_legal_event_code.event_code
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


Eduardo Mercadante
Posts: 6
Joined: Thu Sep 17, 2020 12:04 pm

Re: Event_descr missing in 2021 Spring edition

Post by Eduardo Mercadante » Fri May 14, 2021 12:08 pm

Thanks for explaining how to unite these tables. That should solve the issue.

However, is there a reason why this column was removed? I have been extracting legal event data using tls231 for over a year and event_descr was always there. Only with this last edition that it was removed. Are there plans to getting it back in?

Best,
Eduardo Mercadante
PhD Candidate at LSE


Post Reply