id	summary	reporter	owner	description	type	status	priority	milestone	component	version	resolution	keywords	cc	size
173	Convenient self-service way to generate group listing <select>	adehnert		"DB maintainers can use the command ""groups/format_groups.py midway"" to generate a list of groups suitable for inclusion into an HTML <select> tag. For non-DB maintainers, a cronjob runs it regularly and sticks the output in /mit/asa-db/data/db-dump/midway_groups.html. If somebody who isn't a DB maintainer wants a slightly different set of groups, though, they're out of luck. This is unfortunate.

One approach: The reporting interface could grow a ""field"" that generates an appropriate <option> tag for each group it lists. By outputting as CSV with the status and class fields, it would be relatively easy to filter the right rows in Excel, without needing to use CONCATENATE or strip quotes or whatnot, and hopefully with a reduced risk of smartquotes (see https://diswww.mit.edu/menelaus/asa-internal/15919 for Lemur's struggles with this)."	enhancement	closed	normal	Sometime	Reporting		fixed			small