diff options
| author | Martin Czygan <martin@archive.org> | 2020-07-10 21:32:41 +0000 |
|---|---|---|
| committer | Martin Czygan <martin@archive.org> | 2020-07-10 21:32:41 +0000 |
| commit | 3c266e07771271241aa8cff3e3199a45109362af (patch) | |
| tree | 73fa6aedf1bbfeffeac9c94593f5f9c4f2dd645b /extra/elasticsearch/sql_queries.md | |
| parent | fdf1028c19b0623e30b91e49ffa65ed130dcfdc1 (diff) | |
| parent | c9d8550be4bab808c2bad0b0d3642a71075202c0 (diff) | |
| download | fatcat-3c266e07771271241aa8cff3e3199a45109362af.tar.gz fatcat-3c266e07771271241aa8cff3e3199a45109362af.zip | |
datacite: resolve formatting issues in tests
Diffstat (limited to 'extra/elasticsearch/sql_queries.md')
| -rw-r--r-- | extra/elasticsearch/sql_queries.md | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/extra/elasticsearch/sql_queries.md b/extra/elasticsearch/sql_queries.md new file mode 100644 index 00000000..3ea168e5 --- /dev/null +++ b/extra/elasticsearch/sql_queries.md @@ -0,0 +1,8 @@ + +Top missing OA journals by `container_id`: + + POST _xpack/sql?format=txt + { + "query": "SELECT container_id, count(*) from fatcat_release WHERE preservation = 'none' AND is_oa = true GROUP BY container_id ORDER BY count(*) DESC LIMIT 20" + } + |