Search found 8 matches

by jantonio.peces
Thu Oct 24, 2019 8:11 am
Forum: Open Patent Services (OPS) and bulk data subscription products
Topic: Database updates
Replies: 3
Views: 2967

Re: Database updates

Hello, I understand that when patent data are received they loaded into OPS as son as possible. But I know that in many cases there is a long interval between the publication date and the date in which the patent data are available in OPS. What I want to know is if there is a date of addition field ...
by jantonio.peces
Mon Jun 04, 2018 9:11 am
Forum: PATSTAT Product Line
Topic: Spanish applicant 1st Publications by tech field
Replies: 3
Views: 1861

Re: Spanish applicant 1st Publications by tech field

Hi, following my previous question.

When running that query that I sent initially I get 728 results.
How can I group those results by year so I get a publication count per year?

Thanks in advance.

JA Peces
by jantonio.peces
Tue May 29, 2018 1:12 pm
Forum: PATSTAT Product Line
Topic: Spanish applicant 1st Publications by tech field
Replies: 3
Views: 1861

Re: Spanish applicant 1st Publications by tech field

Thanks a lot for your response. Yes, the spelling corrector changes two blanks into only one. First publication in Spain is A1 or A2 for patents and U for utility models. In this case I don't mind if it has a foreign priority. I just need the applicant to reside in ES and that the National Authority...
by jantonio.peces
Mon May 28, 2018 4:33 pm
Forum: PATSTAT Product Line
Topic: Spanish applicant 1st Publications by tech field
Replies: 3
Views: 1861

Spanish applicant 1st Publications by tech field

Dear all, We're trying to get the Spanish applicant 1st patent publications for some IPCs and some CPCs. But surely I need some expert advice because of my unfrequent practice. Please, is my query OK? Thanks in advance. Regards, José A. Peces SELECT distinct ppbn.appln_id, year(publn_date), ppbn.pub...
by jantonio.peces
Tue Jul 25, 2017 8:38 am
Forum: PATSTAT Product Line
Topic: Spanish universities publications in 2017
Replies: 3
Views: 1352

Spanish universities publications in 2017

Hi Martin and Geert, I need some help to find out if I wrote correctly my query. I am searching for patent publications applied by Spanish Universities that were publised in 2017. Please see below if I did it correctly. Thanks a lot. Greetings from Spain. José A. Peces OEPM SELECT DISTINCT a. appln_...
by jantonio.peces
Tue Apr 19, 2016 11:16 am
Forum: PATSTAT Product Line
Topic: % wildcard in cpc_class_symbol
Replies: 2
Views: 1210

Re: % wildcard in cpc_class_symbol

Thanks Geert, I always learn from you.

And what about using % wild character in the "in" syntax?

Code: Select all

where cpc_class_symbol in ('F03B13/12%', 'F03B 13/14%', 'F03B 13/16%' , 'F03B 13/18%' , 'F03B 13/2%')
Will I have the same issue ?
Thanks.
by jantonio.peces
Mon Apr 18, 2016 1:37 pm
Forum: PATSTAT Product Line
Topic: % wildcard in cpc_class_symbol
Replies: 2
Views: 1210

% wildcard in cpc_class_symbol

(SELECT a.appln_id FROM tls201_appln a JOIN tls224_appln_cpc c ON a.appln_id = c.appln_id WHERE cpc_class_symbol = 'F03B 13/12%' and earliest_publn_year > 2013) returns 0 results but (SELECT a.appln_id FROM tls201_appln a JOIN tls224_appln_cpc c ON a.appln_id = c.appln_id WHERE cpc_class_symbol = '...