There are two related searchable fields in the API called: publicationCitation and publicationReplicationData.
But when I tried that with DOI it didn't return any results. I think this could partly because it searches the content of the citation, but not the id's (though I did try some searches that should have returned something and didn't, so I may need to ask Leonid
about these fields).
I also went to advanced search through the UI and did two searches:
- Publication, Replication for: "doi" and got 124 studies
- Related Publications: 'doi' and got 46 studies.
Clearly, we should add a searchable field for publication id (or make it part of a general field for publication like advanced search) and/or fix the above fields. If anyone has specific suggestion on how they would like to see this work, please let us know.
______
Regardless I ran a direct query in the db just now to try get all current DOIs:
select distinct s.protocol||':'||s.authority||'/'||s.studyid as handle,
idtype||':'||idnumber as doi,
CASE
WHEN strpos(lower(text), 'doi:') > 0
THEN substr(text,strpos(lower(text), 'doi:'),50)
END as text
from studyrelpublication, studyversion sv, metadata m, study s
where studyrelpublication.metadata_id =
m.id
and
m.id = sv.metadata_id
and sv.study_id =
s.id
and sv.versionstate='RELEASED'
and ((idtype='DOI' and idnumber != '') or lower(text) like ('%doi:%'))
order by handle;
This returned 222 results I've attached the results of the query as a text file. (look for doi either in the 2nd column which means they filled out the id field, or the 3rd column, which means it found it somewhere in the text - note I just find the dpi, then
take the next 50 characters, since doi can be of variable length):