Search found 3 matches

by EduardoJJM
Tue Jul 28, 2020 8:12 am
Forum: PATSTAT Product Line
Topic: Time window to control forward-citations
Replies: 6
Views: 4565

Re: Time window to control forward-citations

Dear EPO,

Awesome! :D
Thank you so much for your help!

Best regards,
Eduardo
by EduardoJJM
Tue Jul 14, 2020 12:35 pm
Forum: PATSTAT Product Line
Topic: Time window to control forward-citations
Replies: 6
Views: 4565

Re: Time window to control forward-citations

Dear EPO, Thank you so much for all the comments and guidance. After having read your queries and further information on the tables involved; I have adapted the following query to my research criteria. This query is the only one that seemed to work after including all the necessary clauses. It reads...
by EduardoJJM
Fri Jul 10, 2020 9:26 am
Forum: PATSTAT Product Line
Topic: Time window to control forward-citations
Replies: 6
Views: 4565

Time window to control forward-citations

Dear EPO and other research fellows, How can I integrate the time-span (3 and or 5) to retrieve forward citations? So far I have been using the following query to retrieve information on forward citations: SELECT * FROM tls201_appln join tls207_pers_appln on tls201_appln.appln_id = tls207_pers_appln...