This is ready for testing. We currently include the query string, which is in the sql format. This is on stage on the datashare admin page.

The information is captured in a log file (text file). It is not captured in the database.

Example snippet from log file of download and query:

[Sun Apr 7 14:23:35 2019] [debug] POST "/download"
[Sun Apr 7 14:23:35 2019] [debug] Routing to a callback
[Sun Apr 7 14:23:35 2019] [info] Packaged query results sent.
[Sun Apr 7 14:23:35 2019] [info] {"email":null,"fname":null,"group_id":"943","group_name":"Tod Hing Test Project","is_auth":"1","lname":null,"permissions":{},"section":"datashare","study_id":"1","study_name":"Paris Study","templateid":"1","token":"198244","userid":"67858"}
[Sun Apr 7 14:23:35 2019] [info] {"file":"/var/www/filestore/downloads/0bdpXac1/study1-2019-04-07-02-27.zip","files":2,"size":"24K","url":"https://simtk-datashare.stanford.edu/filestore/downloads/0bdpXac1/study1-2019-04-07-02-27.zip";}

[Sun Apr 7 14:23:35 2019] [debug] 200 OK (0.081956s, 12.202/s)
[Sun Apr 7 14:31:30 2019] [debug] POST "/query"
[Sun Apr 7 14:31:30 2019] [debug] Routing to a callback
[Sun Apr 7 14:31:30 2019] [info] Query submitted.
[Sun Apr 7 14:31:30 2019] [info] {"email":null,"fname":null,"group_id":"943","group_name":"Tod Hing Test Project","is_auth":"1","lname":null,"permissions":{},"section":"datashare","study_id":"1","study_name":"Paris Study","templateid":"1","token":"198244","userid":"67858"}
[Sun Apr 7 14:31:30 2019] [info] {"application":"Study Datashare","comments":{},"filename":{},"nosql":"select json from \"study1\".\"metadata\" where (json->>'0b2f75648aa0aa70' = '38.09519999999999')","rules":{"condition":"AND","rules":[{"field":"0b2f75648aa0aa70","id":"0b2f75648aa0aa70","input":"text","operator":"equal","type":"string","value":"38.09519999999999"}],"valid":true},"session":"c1ca0t7orkhclumtke1lk7nm01","study":"study1","thanks":"Thank you for using the Study Datashare and your interest in Study!","url":"https://simtk-datashare.stanford.edu/apps/query";}