Search found 8 matches
- Thu Oct 24, 2019 8:11 am
- Forum: Open Patent Services (OPS) and bulk data subscription products
- Topic: Database updates
- Replies: 3
- Views: 4517
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 ...
- Mon Jun 04, 2018 9:11 am
- Forum: PATSTAT Product Line
- Topic: Spanish applicant 1st Publications by tech field
- Replies: 3
- Views: 2505
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
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
- Tue May 29, 2018 1:12 pm
- Forum: PATSTAT Product Line
- Topic: Spanish applicant 1st Publications by tech field
- Replies: 3
- Views: 2505
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...
- Mon May 28, 2018 4:33 pm
- Forum: PATSTAT Product Line
- Topic: Spanish applicant 1st Publications by tech field
- Replies: 3
- Views: 2505
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...
- Wed Jul 26, 2017 9:02 am
- Forum: PATSTAT Product Line
- Topic: Spanish universities publications in 2017
- Replies: 3
- Views: 1823
Re: Spanish universities publications in 2017
thanks a lot!!!
- Tue Jul 25, 2017 8:38 am
- Forum: PATSTAT Product Line
- Topic: Spanish universities publications in 2017
- Replies: 3
- Views: 1823
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_...
- Tue Apr 19, 2016 11:16 am
- Forum: PATSTAT Product Line
- Topic: % wildcard in cpc_class_symbol
- Replies: 2
- Views: 1629
Re: % wildcard in cpc_class_symbol
Thanks Geert, I always learn from you.
And what about using % wild character in the "in" syntax?
Will I have the same issue ?
Thanks.
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%')
Thanks.
- Mon Apr 18, 2016 1:37 pm
- Forum: PATSTAT Product Line
- Topic: % wildcard in cpc_class_symbol
- Replies: 2
- Views: 1629
% 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 = '...