Search found 3 matches
- 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 ...
- 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...
- 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...