Skip to content

Search questions by properties of answers #990

@cellio

Description

@cellio

We can currently search posts based on properties of the posts directly, such as score. For questions, number of answers is a property of the question, not of the answers, so we can search by number of answers.

We've gotten requests occasionally (for example, https://linux.codidact.com/posts/287557) to be able to search questions based on answer properties, such as score or (someday) reactions. You can find questions with no answers, but you can't currently search for questions with no answers scoring >0.5. Questions with no positive answers are as much in need of further answers as those with no answers. Can we extend search in this way?

From the SQL side I assume this isn't too complex (though we'll need to consider performance); questions already have relations to their answers, so we need to traverse (join?) that. The other challenges here are (a) as I said, performance and (b) working out a search syntax that's expressive enough but not too complicated to write or parse.

Metadata

Metadata

Assignees

No one assigned

    Labels

    area: backendChanges to server-side codecomplexity: unassessedNeeds further developer investigation before complexity/feasibility can be determined.priority: medium

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions