search of status of an EP application

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
Post Reply

paula.gallego
Posts: 1
Joined: Mon Apr 15, 2019 12:27 pm

search of status of an EP application

Post by paula.gallego » Mon Apr 15, 2019 12:34 pm

Hello everybody,

My patent agency will soon take over several EP cases from another firm and, in order to make a complete list and not miss any pending case, we would like to check how many EP pending cases this firm has nowadays.

Is it possible to search by "status" of a EP application? How is it done?

Or

Is it possible to retrieve a list of cases of an attorney and see the status info to be downloaded in excel?

Thanks for your help in advance,
Paula


EPO / PATSTAT Support
Posts: 426
Joined: Thu Feb 22, 2007 5:33 pm
Contact:

Re: search of status of an EP application

Post by EPO / PATSTAT Support » Thu May 09, 2019 5:50 pm

Hello Paula,
Yes, that is possible.
Maybe the easiest would be to simply extract all applications & data that have been dealt with by the patent representative and then do further work offline.
A couple of things one has to keep in mind: representative names are not harmonised, so a search on a name will mostly need to be done via some wild cards (%) which might also introduce noise. Some applications have a "sequence" of professional representatives. The most recent one (after a sequence of changes) is flagged in REG107_PARTIES as "IS_LATEST".
Below is an example query: it will retrieve all applications from the EP register where the latest representative contains the string "Paula". You can adapt this query to your needs. You can simply paste/copy this query in PATSTAT Online, run it, and then extract the result table, or you can extract a sample data base that contains all the data available in the Register as well as PATSTAT Global. This all depends a bit on what you need.

Code: Select all

SELECT reg101_appln.id
      , appln_id 
      , appln_auth 
      , appln_nr 
      , appln_filing_date 
      , filing_lg 
      , status_text
      , internat_appln_id 
      , internat_appln_nr 
      , is_latest 
      , type 
      , customer_id 
      , name 
      , country 
  FROM  reg101_appln 
  join reg107_parties on reg101_appln.id = reg107_parties.id
  join reg403_appln_status on reg403_appln_status.status = reg101_appln.status
  where name like '%paula%'
  and type = 'R'
  and is_latest = 'Y'
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


Post Reply