CQL and query for only patents with english docs

This space is made available to users of Open Patent Services (OPS) web-service and now also to users of EPO’s bulk data subscription products such as 14. EPO worldwide bibliographic database (DOCDB), 14.11 EPO worldwide legal status database (INPADOC), 14.12 EP full text data, 14.1 EP bibliographic data (EBD)and more.

Users can ask each other questions, exchange experiences and solutions, post ideas. The moderator will use this space to announce changes or other relevant information.
Post Reply

excellenting
Posts: 11
Joined: Mon Jun 05, 2017 5:40 pm

CQL and query for only patents with english docs

Post by excellenting » Thu Jun 15, 2017 7:27 am

Hello

It's, I'm trying to build a query (CQL) with the API, similar to what would be done in the advanced search engine of espacenet.

Select the collection you want to search in WorldWide EN

In the documentation, I can not find the search

Relative doc -> Field Identifiers

It's possible?


EPO / OPS Support
Posts: 1298
Joined: Thu Feb 22, 2007 5:32 pm

Re: CQL and query for only patents with english docs

Post by EPO / OPS Support » Fri Jun 16, 2017 7:07 am

Dear user,

Please have a look at the OPS manual on page 130.

http://documents.epo.org/projects/babyl ... 3_1_en.pdf

Also the FAQ might be helpful to you:
Q: What are the differences between the Espacenet SmartSearch and OPS bibliographic search requests?
A: In OPS you must use Boolean operators, in Espacenet it is optional. Both services use the Common Query Language (CQL). OPS is also faster if you do not request the bibliographic data, as the response contains publication references only.


Kind regards,
OPS support


excellenting
Posts: 11
Joined: Mon Jun 05, 2017 5:40 pm

Re: CQL and query for only patents with english docs

Post by excellenting » Tue Jun 27, 2017 7:34 am

A lot of thanbks, but i don't understan weel.

Usually I use this:

Code: Select all

ti fish AND 20070101:20170610
If I like only retrive docs with English lang on abstract I don't see the way.

Below tries get code 404

Code: Select all

pn=EN AND ti="fish" AND 20070101:20170610
pn=EN* AND ti="fish" AND 20070101:20170610 (Request too large error)
num=EN AND ti=fish 


Apreciate some help.


EPO / OPS Support
Posts: 1298
Joined: Thu Feb 22, 2007 5:32 pm

Re: CQL and query for only patents with english docs

Post by EPO / OPS Support » Tue Jun 27, 2017 9:16 am

OPS is not Espacenet so you need to make your query exact to work properly. Tha means, if you are searching for dates, you need to put a filed identifier PD in the query. Espacenet has build-in business rules that can predict that dates are defined even without using identifier and OPS does not. OPS is a clean access to raw data, without any business rules set.

This is your query in Espacenet:
https://worldwide.espacenet.com/searchR ... ,20170610"

In case of Espacenet, its not enough to look who you put a search in, you need to have a look at how the system interpreted your search, which is shown in result list (txt is automatically added, PD is added....)

and this is the same query in OPS:
http://ops.epo.org/3.1/rest-services/pu ... ,20170610"

OPS has no TXT full text search like Espacenet so it only searches in title.

Your query is much too broad to give results in either Espacenet or OPS, so you need to reduce your query and one way is to reduce a time spam:

http://ops.epo.org/3.1/rest-services/pu ... 0071231%22
and

https://worldwide.espacenet.com/searchR ... 3A20071231

Your search for EN language does not make sense because either OPS or Espacenet do not offer a synonym search, so only titles with the actually word Fish will be found by this query. There is also not a filed identifier available for language setting, either in Espacenet or in OPS. The only service that we have that could do that would be a Global Patent Index (GPI database)

Regards,

OPS support


Mike_k43
Posts: 52
Joined: Fri Jan 06, 2017 1:34 pm

Re: CQL and query for only patents with english docs

Post by Mike_k43 » Mon Jul 10, 2017 6:56 am

I have a similar problem, I would like to get the language of patent publications.

However it seems that e.g.
exchangedocument[0].@abstract[0].lang
contains the language of the first abstract, but

exchangedocument[0].bibliographicdata.applicationreference[0].documentid[0].lang
exchangedocument[0].bibliographicdata.publicationreference[0].documentid[0].lang

never contain the filing or publication language, respectively. They always contain null.

Does OPS contain the publication languages at all? At least for PCT publications this is of importance, because there the language cannot be inferred from the receiving office country code.


EPO / OPS Support
Posts: 1298
Joined: Thu Feb 22, 2007 5:32 pm

Re: CQL and query for only patents with english docs

Post by EPO / OPS Support » Mon Jul 10, 2017 7:12 am

Code: Select all

http://ops.epo.org/3.1/rest-services/published-data/publication/docdb/EP1000000.A1/fulltext
http://ops.epo.org/3.1/rest-services/published-data/application/epodoc/WO2012EP74469/fulltext
Full text constituents will give you information on available language.

Please not than only for purpose of showing an example I am using v 3.1. You should use API Console with activated Authentication and test Full text constituent using v 3.2 instead.

Regards,

OPS support


Post Reply