Search found 93 matches
- Wed Jul 19, 2017 6:58 am
- Forum: PATSTAT Product Line
- Topic: Cpc classification
- Replies: 2
- Views: 1274
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: 1663
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: 1257
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: 1257
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...
- Mon Jun 19, 2017 8:57 pm
- Forum: PATSTAT Product Line
- Topic: Annual Amount of Pat Family Applications by Country of Origi
- Replies: 7
- Views: 1257
Re: Annual Amount of Pat Family Applications by Country of O
Hi deef, You asked for feedback, so here are my thoughts. To be most useful, I am trying to be picky. DOCDB families (aka simple families) are usually used for counting inventions. All applications of the same DOCDB family can be regarded as equivalent. In contrast the broader INPADOC family (aka ex...
- Tue Jun 13, 2017 2:15 pm
- Forum: PATSTAT Product Line
- Topic: Searching for help concerning PATSTAT query
- Replies: 7
- Views: 1663
Re: Searching for help concerning PATSTAT query
Hi, When you do a JOIN, then you get 1 record for each combination of joined tables which fulfil the JOIN conditions (e. g. "ON a.appln_id = pa.appln_id"). As an example: You are joining applications and persons (e. g. applicants) and a specific application has 5 persons associated, you will retriev...
- Fri Jun 09, 2017 2:01 pm
- Forum: PATSTAT Product Line
- Topic: Searching for help concerning PATSTAT query
- Replies: 7
- Views: 1663
Re: Searching for help concerning PATSTAT query
To include worldwide regional / national filings, just remove " appln_auth = 'EP' " in your query. To also include international filings (= PCT filings at WIPO), remove " appln_kind = 'A' ". To better understand what a query does and to use SQL effectively, I suggest to read the SQL self-study cours...
- Thu Jun 08, 2017 6:54 am
- Forum: PATSTAT Product Line
- Topic: Searching for help concerning PATSTAT query
- Replies: 7
- Views: 1663
Re: Searching for help concerning PATSTAT query
Hi Constance,
Just add "and granted = 1" to the WHERE clause of your query.
Look up attribute GRANTED in the Data Catalog for more details.
Best regards,
Martin / EPO
Just add "and granted = 1" to the WHERE clause of your query.
Look up attribute GRANTED in the Data Catalog for more details.
Best regards,
Martin / EPO
- Wed May 24, 2017 2:32 pm
- Forum: PATSTAT Product Line
- Topic: NPL references cited in patent literature
- Replies: 4
- Views: 833
Re: NPL references cited in patent literature
Dear Joachim, Thanks for the specific example, which was publication US 7067501 B2. In short: PATSTAT gets its data more or less indirectly from the US office. I have no reason to believe that information gets lost on the way because the 6 NPLs listed by the applicant in the US form "Information Dis...
- Tue May 23, 2017 2:05 pm
- Forum: PATSTAT Product Line
- Topic: NPL references cited in patent literature
- Replies: 4
- Views: 833
Re: NPL references cited in patent literature
Dear Joachim, Actually, your assumption is not correct. NPLs can be cited in any phase of the patent procedure. Just check attribute CITN_ORIGIN in table TLS212_CITATION. select citn_origin, count(*) as freq from tls212_citation where cited_npl_publn_id > 0 group by citn_origin order by freq desc Th...