Hi, Just wondered whether there is a maximum number of search results being set in the background of Discourse at all? I wanted to see how many of the automated topics we have that are created have any responses, I found 305 that do not, but I wanted to find the total number of the automated posts…

Yup, it’s capped at 500 :slight_smile: [afbeelding] Search Results Limited to 50 each time bug Here is the pull request resolving this issue: https://github.com/discourse/discourse/pull/4981 - added infinite loading of search results, in total 10 pages of 50 results are l…

Hi @HAWK , thanks for the reply. Is there anything that I can add in the search criteria or to a querystring to bypass the limit? Kind regards Rob

Not really, we do this here to protect the server, search becomes very expensive when you are paging through enormous amounts of topics, the offset keeps on costing more and more.

Why would you need more than 500 results? Who exactly is going to page 13 of search results?

It’s not a really a feature I am asking for - as such - I just wondered whether you had something like this in the background, almost like a debugging feature. It isn’t something I would want to do every day, its just in this specific case I am trying to establish how many automated topics have bee…

So all you need is the count not the actual results?

Yeah, pretty much, was just using the tools at my disposal. If I could get a break down of the category / sub-category with their counts that would be useful, but not essential as if it comes to me having to delete them I will be going through category after category - just helps to have a bit of a…

Could you use a Data Explorer query to get the exact count?

I’ve nevered used them Joshua, where/how would I begin? I have come from / been spoilt by direct access to SQL databases in the past, so pinging off the odd query here and there when needed was fairly straight forward - obviously now I’m on the other side of that fence :slight_smile:

Data Explorer very likely what you’re looking for then! It allows you to write SQL queries against the database. You can see the basics in the Data Explorer Plugin topic. In short, visit your plugins page and enable it. Then you’ll see Data Explorer as a tab on the left site of the page. From there,…

Maximum Number of Search Results?

Ondersteuning

HAWK (Hawk) 8 november 2017 om 17:16 2

Yup, it’s capped at 500

Topic		Antwoorden	Weergaven
Maximum number of search results in the drop box Support search	0	384	24 mei 2023
Search Results Limited to 50 each time Bug search	13	3410	2 augustus 2017
Discourses API get just the number of search results Development rest-api	10	3183	30 juni 2023
Searching Users returns a maximum of 20 users Feature search	7	470	11 oktober 2024
Any way to load more than 50 search results per query? Support	7	2157	2 augustus 2017

Maximum Number of Search Results?

Gerelateerde topics