Hello Community, I need a list of all answered questions of all time. The problem: I saw that its possible to filter via search for this, but we have over 1 Mio questions, so its not really possible to go this way. How can it be done? Is there a plugin, feature or DB request?

The filter you want is possible functionally, but the number of topics is the limitation, at least at the UI level. Like Moin and Nate suggested, applying multiple filters/ using data explorer and keeping track of your progress are likely your best solutions in the UI. If you really need the out…

If you want to see these topics in the topic list (not search), you can go to /filter?q=status%3Asolved%20 to see all solved topics, and /filter?q=status%3Aunsolved%20 for all unsolved topics. For example, this shows all solved topics on Meta.

Das geht leider nicht, weil wir über 1 Mio Einträge haben.

Right. What are you planning to do with all these topics, and what are you trying to do? Thanks.

Wir möchten aussortieren. Wir haben über 1 Mio Fragen und möchten prüfen, welche unbeantwortet sind.

[изображение] Nate Dhaliwal: /filter?q=status%3Aunsolved%20 will find all unanswered topics.

Maybe a data explorer query could help you. Here is an example on working around the 10,000 result limit of data explorer .

Für alle unbeantworteten Themen

Do you mean topics with 0 replies or with no Solutions? If you’re referring to topics with 0 replies, try using the /filter?q=posts-max%3A1 filter to look for topics with 0 replies.

Hallo, ich meine damit Themen ohne Anworten. Wie gesagt, wir haben über 1 Mio Themen, da ist der Filter keine Option!

Okay, may I know what you are trying to do with all these topics?

Список всех вопросов без ответов

Поддержка

Moin 28.Август.2025 09:39:14 7

Возможно, вам поможет запрос исследователя данных.

Вот пример обхода ограничения в 10 000 результатов для исследователя данных.

Тема		Ответов	Просм.
Can I view a list of solved and unsolved topics in a category Support solved	4	2948	07.07.2023
Solved and Unsolved Topic Stats with Date and Tag Parameters Data & reporting sql-query , solved	4	346	19.09.2025
How can I show topics that have not received an answer yet? Support search	4	659	08.07.2023
List of the filters Support	3	1222	26.02.2020
Topics stats of Solved/Unsolved topics, inc. 'time to solution' Data & reporting sql-query , solved	0	190	22.04.2023

Список всех вопросов без ответов

Связанные темы