appln_auth in PATSTAT2017b versus PATSTAT2018a
Posted: Tue May 15, 2018 9:20 am
Keep in mind that the domain of the appln_auth attribute has changed.
PCT applications will have "WO" in combination with a value in the receiving_office in PATSTAT2018a.
This can lead to un-expected results when using "old queries". You might need to adapt them.
Take the following query:
Will result in 3268 results for 2017b but only 2279 records for PATSTAT 2018a. The PCT applications are excluded !
To obtain the same result as before, one could use a query such as this:
PCT applications will have "WO" in combination with a value in the receiving_office in PATSTAT2018a.
This can lead to un-expected results when using "old queries". You might need to adapt them.
Take the following query:
Code: Select all
SELECT distinct appln_id, appln_auth, appln_nr, appln_kind, appln_filing_date
FROM tls201_appln
where appln_filing_year = 2012
and appln_auth = 'NL'
order by appln_idTo obtain the same result as before, one could use a query such as this:
Code: Select all
SELECT distinct appln_id, appln_auth, appln_nr, appln_kind, appln_filing_date
FROM tls201_appln
where appln_filing_year = 2012
and (appln_auth = 'NL' or receiving_office ='NL')
order by appln_id