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?
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.
Unfortunately, that is not possible, as we have over 1 million entries.
Right. What are you planning to do with all these topics, and what are you trying to do? Thanks.
We want to sort. We have over 1 million questions and want to check which ones are unanswered.
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.
For all unanswered topics
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.
Hello,
I mean topics without answers. As I said, we have over 1 million topics, so the filter is not an option!
Okay, may I know what you are trying to do with all these topics?
We want to sort things out. All unanswered topics should be reviewed and, if the quality is poor, deleted. If topics have no answers, it is reasonable to assume that the question itself was not good.
Then the filtered list, as @NateDhaliwal suggested, is a good solution after all. For example, you could show all topics without a reply that do not have the tag “reviewed”. Then you go through the list and delete topics you don’t want to keep, and for the others, you add the tag. Then the filtered list will only contain the topics you haven’t looked at yet.
The Data Explorer can also create a list for you, but you have to work through that one too and keep track of your progress. Excluding based on a tag could work just as well there.
What is the problem that these suggestions do not solve?
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 output of all at once, it likely won’t be in the UI - I think you will need to setup a batch rails script of some kind to do this number of topics - the data explorer limits and pagination of filter won’t work. this is not my area of expertise but I suspect you will need to do say, batch queries of 1000 and it will take some time to run with an output file of results you can analyze in a spreadsheet (you will also probably need to compress the output file).
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.