Time window to control forward-citations
Posted: Fri Jul 10, 2020 9:26 am
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:
However, when I have tried to integrate the 3/year time span explained in DeRassenfose et al (2014), the results exclude patents that appear using the first query. The query I used reads as follows:
Could you please explain to me where is the mistake? And more important, how can I properly integrate the 3-5 years time span for controlling the forward citations?
Thank you so much for your kind time and attention.
Best regards,
Eduardo
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:
Code: Select all
SELECT *
FROM tls201_appln
join tls207_pers_appln on tls201_appln.appln_id = tls207_pers_appln.appln_id
join tls206_person on tls207_pers_appln.person_id = tls206_person.person_id
where psn_id in (xxxxxxxxxx)
and tls201_appln.appln_filing_year in ('2007', '2008', '2009', '2010', '2011', '2012', '2013', '2014', '2015', '2016', '2017')
order by tls201_appln.appln_filing_year
Code: Select all
SELECT *
FROM tls201_appln
join tls207_pers_appln on tls201_appln.appln_id = tls207_pers_appln.appln_id
join tls206_person on tls207_pers_appln.person_id = tls206_person.person_id
join tls211_pat_publn on tls201_appln.appln_id = tls211_pat_publn.appln_id
join tls212_citation on tls211_pat_publn.pat_publn_id = tls212_citation.pat_publn_id
where tls206_person.psn_id in (xxxxxxxxx)
and tls201_appln.appln_filing_year in ('2007', '2008', '2009', '2010', '2011', '2012', '2013', '2014', '2015', '2016', '2017')
and [b](DATEDIFF (YEAR, tls201_appln.earliest_publn_date, tls211_pat_publn.publn_date) <= 3)[/b]
order by tls201_appln.appln_filing_year
Thank you so much for your kind time and attention.
Best regards,
Eduardo