Search found 119 matches
- Mon Mar 05, 2018 2:57 pm
- Forum: PATSTAT Product Line
- Topic: Retrieving patents with inventors spread across multiple countries
- Replies: 3
- Views: 3835
Re: Retrieving patents with inventors spread across multiple countries
PATSTAT Online is a read-only database. You cannot create your own database views (CREATE VIEW ...). To create views, you have to set up your own local database and import PATSTAT data from its CSV files. But in almost all cases you can just work around database views: Here is a query which returns ...
- Thu Feb 15, 2018 10:44 am
- Forum: PATSTAT Product Line
- Topic: PATSTAT 2017 Autumn - text search operators and non full-text Index table error
- Replies: 1
- Views: 2418
Re: PATSTAT 2017 Autumn - text search operators and non full-text Index table error
I suppose you are using PATSTAT Online. PATSTAT Online is powered by MS SQL Server, which is using the T-SQL dialect of SQL. There are some more wildcards than just the %-character. Please see the full Microsoft documentation here: https://docs.microsoft.com/en-us/sql/t-sql/language-elements/like-tr...
- Sat Dec 30, 2017 8:51 pm
- Forum: PATSTAT Product Line
- Topic: EPO patents designated in single European countries
- Replies: 2
- Views: 2871
Re: EPO patents designated in single European countries
Dear Carmen, There probably is a misconception about the meaning of "designated states". Article 79 of the European Patent Convention (http://www.epo.org/law-practice/legal-texts/html/epc/2016/e/ar79.html) specifies since late 2000 that "All the Contracting States party to this Conven...
- Fri Nov 03, 2017 8:18 am
- Forum: PATSTAT Product Line
- Topic: Bad character in tls201_part05.txt
- Replies: 0
- Views: 1527
Bad character in tls201_part05.txt
Dear subscriber of PATSTAT Biblio, In case you have downloaded the files of the 2017 Autumn Edition before the noon of Nov 2nd, 2017: File tls201_part05.txt contains a bad character (marked red in the middle line below) in one of its lines, which may cause issues when you import the data into your d...
- Wed Nov 01, 2017 5:32 pm
- Forum: PATSTAT Product Line
- Topic: NPL_BIBLIO value may be longer than expected
- Replies: 0
- Views: 1609
NPL_BIBLIO value may be longer than expected
Please note that in the current 2017 Autumn Edition values in attribute NPL_BIBLIO of table TLS214_NPL_PUBLN can be up to 3 800 characters long. If your DB schema is not prepared to hold such longs strings, then you might experience problems when loading the data into your database. To avoid similar...
- Fri Oct 27, 2017 11:50 am
- Forum: PATSTAT Product Line
- Topic: PATSTAT Online version 2.3.4
- Replies: 2
- Views: 3277
Re: PATSTAT Online version 2.3.4
Dear Björn,
Bad timing! The document you are looking for is right now being replaced by an updated version.
Please try again a little later (today).
Sorry for the inconvenience,
Martin
EPO / PATSTAT
Bad timing! The document you are looking for is right now being replaced by an updated version.
Please try again a little later (today).
Sorry for the inconvenience,
Martin
EPO / PATSTAT
- Wed Jul 19, 2017 6:58 am
- Forum: PATSTAT Product Line
- Topic: Cpc classification
- Replies: 2
- Views: 4431
Re: Cpc classification
Hi, CPC classification codes are always used on the group level, like 'Y02E 20/16', so they contain 11 or more characters. Your code sample cpc_class_symbol in ('y02B', 'y02c', 'y02e') is equivalent to cpc_class_symbol = 'y02B' OR cpc_class_symbol = 'y02c' OR cpc_class_symbol = 'y02e' Strings of dif...
- Sat Jun 24, 2017 8:40 am
- Forum: PATSTAT Product Line
- Topic: Searching for help concerning PATSTAT query
- Replies: 7
- Views: 4446
Re: Searching for help concerning PATSTAT query
Hi, in your second query of our previous post you are mixing ANDs and ORs. You can do that, but you have to be careful on how SQL interprets this (see https://docs.microsoft.com/en-us/sql/t-sql/language-elements/operator-precedence-transact-sql . Ist much safer to explicitely control the order of ev...
- Fri Jun 23, 2017 4:59 pm
- Forum: PATSTAT Product Line
- Topic: Annual Amount of Pat Family Applications by Country of Origi
- Replies: 7
- Views: 3766
Re: Annual Amount of Pat Family Applications by Country of O
Hi deef, Your query looks fine. You are counting all families where first filings have an applicant of a certain country published by one of its publications. There is a slight difference to your earlier query, where you counted families which have family members (i.e. applications) whose most recen...
- Tue Jun 20, 2017 3:45 pm
- Forum: PATSTAT Product Line
- Topic: Annual Amount of Pat Family Applications by Country of Origi
- Replies: 7
- Views: 3766
Re: Annual Amount of Pat Family Applications by Country of O
Hi, 1) To find the applicant who has filed the application in the first place: In PATSTAT Biblio applicants (and likewise inventors) are connected in 2 ways to an application: a) Most commonly, you use the latest applicants (as published). You get them by joining applicants with persons, i.e. TLS201...