update tool-use-by-group query

galaxyproject / gxadmin

Handy command line utility for Galaxy administrators :rocket:

https://galaxyproject.github.io/gxadmin/#/

GNU General Public License v3.0

23 stars 27 forks source link

update tool-use-by-group query #153

Open cat-bro opened 3 months ago

cat-bro commented 3 months ago

This fails with a syntax error

cat@galaxy:~$ gxadmin query tool-use-by-group 2022-02-01 --group=QUT_users
ERROR:  invalid input syntax for type timestamp: "-01"
LINE 12: date_trunc('month', job.create_time) = '-01'

This looks like a typo with year_month vs years_month

cat-bro commented 3 months ago

making this a draft because I'm not sure if it uses the --group argument in the query