SELECT COUNT reports no rows error

[HatsuneMiku3939]

I tried to get the row count of a table using this code:

	// GET total count of threads, with optional workspace filter
	var totalCount struct {
		Count int
	}
	countStmt := table.Threads.SELECT(sqlite.COUNT(table.Threads.ID))
	if workspace != "" {
		countStmt = countStmt.WHERE(table.Threads.Workspace.EQ(sqlite.String(workspace)))
	}

	err := countStmt.QueryContext(ctx, r.db, &totalCount)
	if err != nil {
		return nil, 0, err
	}

However, countStmt.QueryContext(ctx, r.db, &totalCount) is returning qrm: no rows in result set.
Could you please advise on the correct usage?"

[trevlt]

You are probably missing an alias:

countStmt := table.Threads.SELECT(
    sqlite.COUNT(table.Threads.ID).AS("count"),
)

[HatsuneMiku3939]

@trevlt
Thank you