Search found 3 matches

by stefana.vasilache
Fri May 08, 2020 4:32 pm
Forum: PATSTAT Product Line
Topic: Problem with concatenated fields
Replies: 1
Views: 1393

Problem with concatenated fields

Hello, I am trying to retrieve the technical sector and technical field of an application, between 2014-2020, with both inventor(s) and applicant(s) romanian and i want to concatenate the sector and the field to avoid multiple results for the same application. The problem is that when i concatenate ...
by stefana.vasilache
Thu May 07, 2020 7:37 am
Forum: PATSTAT Product Line
Topic: Accessing Data from ER Register PATSTAT Online
Replies: 2
Views: 1834

Re: Accessing Data from ER Register PATSTAT Online

Hello, Thank you so much for the feedback. I was involving the title table because i considered that table to be a link table between reg101_appln and reg107_parties, but i was wrong. (i considered the field bulletin_year a FK, but now i see that i just should have used the id field ) Now that i see...
by stefana.vasilache
Wed May 06, 2020 2:25 pm
Forum: PATSTAT Product Line
Topic: Accessing Data from ER Register PATSTAT Online
Replies: 2
Views: 1834

Accessing Data from ER Register PATSTAT Online

Hello, I am currently working on my MSc thesis and i am trying to interrogate the EP Register from PATSTAT Online to retrieve a list of patent applications' register number and the inventor's and applicant's country, but i receive the following error: "[SELECT - 0 row(s), 0 secs] [Error Code: 8...