Problem listing groups with "edge count" && "open" filters

[bfixowi]

This switch case (open && edgeCount) uses edge_count = vs. other cases using edge_count<=.

We were previously using open = nil and using edge count = n to find groups with open member slots.

When adding open = true, we now get 0 results because of the edge count equality requirement.

func ListGroups(ctx context.Context, logger *zap.Logger, db *sql.DB, name, langTag string, open *bool, edgeCount, limit int, cursorStr string) (*api.GroupList, error) {
...
	case open != nil && edgeCount > -1:
		// Filtering by open/closed and edge count.
		state := 0
		if !*open {
			state = 1
		}
		params = append(params, state, edgeCount)
		query = `
SELECT id, creator_id, name, description, avatar_url, state, edge_count, lang_tag, max_count, metadata, create_time, update_time
FROM groups
WHERE disable_time = '1970-01-01 00:00:00 UTC'
AND state = $2
AND edge_count = $3`

[linear]

NK-631 Problem listing groups with "edge count" && "open" filters

[bfixowi]

This is currently preventing us from showing only public groups with available slots but we can try to work around this in the runtimes in some way