EPO - Discussion forums

Posted: **Thu May 19, 2022 2:27 pm**

I'm trying to extract the patents that have Artificial intelligence in the title or abs filed in Korea or WO, besides that use distintct, so i dont double the inventions, but i dont know how to include WO and where put distinct. Can you guys help me?

Code: Select all

SELECT * 
  FROM TLS201_APPLN AS APP 
  INNER JOIN TLS202_APPLN_TITLE AS TIT 
  ON (APP.APPLN_ID = TIT.APPLN_ID) 
  INNER JOIN TLS203_APPLN_ABSTR ABS 
  ON (APP.APPLN_ID = ABS.APPLN_ID) 
  WHERE (    TIT.APPLN_TITLE LIKE '%인공 지능%' OR TIT.APPLN_TITLE LIKE '%Artificial intelligence%' OR ABS.APPLN_ABSTRACT LIKE '%인공 지능' OR ABS.APPLN_ABSTRACT LIKE '%Artificial intelligence%')
     AND APP.GRANTED = 'Y' 
	 AND APP.APPLN_FILING_YEAR BETWEEN '2003' AND '2017' 
	 AND APP.APPLN_AUTH = 'KR'

Posted: **Fri Jun 24, 2022 2:14 pm**

Dear Carlos
if you want to select all patents coming via PCT route from any country just add in your selection criteria
APPLN_AUTH = 'WO'

Code: Select all

SELECT *
FROM TLS201_APPLN AS APP
INNER JOIN TLS202_APPLN_TITLE AS TIT
ON (APP.APPLN_ID = TIT.APPLN_ID)
INNER JOIN TLS203_APPLN_ABSTR ABS
ON (APP.APPLN_ID = ABS.APPLN_ID)
WHERE ( TIT.APPLN_TITLE LIKE '%인공 지능%' 
OR TIT.APPLN_TITLE LIKE '%Artificial intelligence%' 
OR ABS.APPLN_ABSTRACT LIKE '%인공 지능' 
OR ABS.APPLN_ABSTRACT LIKE '%Artificial intelligence%')
AND APP.GRANTED = 'Y'
AND APP.APPLN_FILING_YEAR BETWEEN '2003' AND '2017'
AND ( APP.APPLN_AUTH = 'KR' or APP.APPLN_AUTH = 'WO')

if instead you need the pct applications filed via the Korean patent office, just add RECEIVING_OFFICE = "KR"

Code: Select all

SELECT *
FROM TLS201_APPLN AS APP
INNER JOIN TLS202_APPLN_TITLE AS TIT
ON (APP.APPLN_ID = TIT.APPLN_ID)
INNER JOIN TLS203_APPLN_ABSTR ABS
ON (APP.APPLN_ID = ABS.APPLN_ID)
WHERE ( TIT.APPLN_TITLE LIKE '%인공 지능%' 
OR TIT.APPLN_TITLE LIKE '%Artificial intelligence%' 
OR ABS.APPLN_ABSTRACT LIKE '%인공 지능' 
OR ABS.APPLN_ABSTRACT LIKE '%Artificial intelligence%')
AND APP.GRANTED = 'Y'
AND APP.APPLN_FILING_YEAR BETWEEN '2003' AND '2017'
AND ( APP.APPLN_AUTH = 'KR' or RECEIVING_OFFICE = "KR")

EPO - Discussion forums

KR or WO as countries publication

KR or WO as countries publication

Re: KR or WO as countries publication