Search found 2 matches

by Michi
Wed Nov 25, 2020 12:41 am
Forum: PATSTAT Product Line
Topic: Counting patents by IPC subclass
Replies: 2
Views: 2227

Re: Counting patents by IPC subclass

Dear Martin,

Now I see what's going on. Thank you very much for clarifying the underlying problem and the solution!

Best,
Michi
by Michi
Mon Nov 23, 2020 7:05 pm
Forum: PATSTAT Product Line
Topic: Counting patents by IPC subclass
Replies: 2
Views: 2227

Counting patents by IPC subclass

Dear PatStat experts: I'm counting patents by IPC subclass. Something like the following query worked fine a year ago (with PatStat Online 2019 Autumn), but now I'm getting an error (with the 2020 Autumn): Invalid column name 'ipc_subclass'. SELECT psn_id, psn_name, a.appln_filing_year, LEFT(ipc_cla...