9
$\begingroup$

I like being a "necromancer" in CV and digging through the bones of things that have been abandoned but are meaningful.

I want to search unanswered, as in zero answers at all, questions by my tag, ordered from oldest to newest.

How do I do that. I saw that the interface had a "newest" option, but not an "oldest" option.

$\endgroup$
3
  • 4
    $\begingroup$ Is there any problem skipping to the last page when ordered by "newest" and working back from that? $\endgroup$
    – whuber Mod
    Apr 27 at 17:54
  • 1
    $\begingroup$ You can use the advanced search options to set a date range. $\endgroup$
    – Sycorax Mod
    Apr 27 at 18:06
  • 2
    $\begingroup$ +1 I like being a necromancer also. :) $\endgroup$
    – Alexis
    May 4 at 15:54
5
$\begingroup$

You can you use the StackExchange Data Explorer to write an SQL query that does exactly what you want. Below a query that returns what you are looking for. That is, unanswered posts, sorted from oldest to newest, that are not closed and contain the tags you will define in the parenthenses in the t.TagName IN ('r', 'monte-carlo') clause (I used 'r' and 'monte-carlo' just for example).

select distinct p.Id AS [Post Link], p.*
from Posts p
  inner join PostHistory ph on ph.postid = p.id
  join PostTags pt ON pt.PostId = p.Id
  join Tags t  ON t.Id = pt.TagId
where p.PostTypeId = 1 and p.AnswerCount = 0 and ph.PostHistoryTypeId != 10 -- closed
and t.TagName IN ('r', 'monte-carlo')
order by p.CreationDate asc

Note that the site queried is not part of the query itself. You have to select it in the query configuration page by searching for the site you want.

You can use the above query already configured for the Cross Validated site here (allow it some seconds and it will probably execute automatically; if not just click "Run Query"). You may fork it and edit it as you like.

If you want to learn more about writing queries against the Stack Exchange Data Explorer, have a look into their tutorial.

$\endgroup$
3
$\begingroup$

As a comment to the answer by @gung, some more examples of the advanced search features, modify, mix & match at will. The first is my standard starting point:

experiment-design answers:0 closed:no duplicate:no                (845 hits)
experiment-design answers:0 closed:no duplicate:no score:0        (249 hits)
experiment-design answers:0 closed:no duplicate:no views:..20     (171 hits)
experiment-design answers:0 closed:no duplicate:no created:..2012 (44 hits)

For more search operators, see https://stats.stackexchange.com/help/searching. Note that .. is the range operator, which can be used with many search operators, as in 2015..2018 which is inclusive, so from 1 January 2015 to 31 December 2018, or 2021.. which is after (inclusive) 1 January 2021.

$\endgroup$
1
$\begingroup$

Use the various advanced search features. To find unanswered threads, search for answers:0 closed:no. Then you can sort by Newest, and skip to the last page (currently 1074): the oldest non-closed question without answers appears to be What's good about I-projections? posted on Aug 24, 2010.

$\endgroup$

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .