I've been asking quite a few questions on several Stack Exchange sites, and I'm finding it harder and harder to keep track of them all.

Is there any way/place to see a listing of all my questions with no answer accepted on all of the Stack Exchange (2.0) sites? Or even just per site? If not, are there any plans to implement such a feature?

Although Jeff offered an answer, I don't feel it's the answer to my question; as far I'm aware there still is no way to list only my unanswered questions.

  • 1
    You could use the Chrome extension StackStalker to keep track of your own questions, but it doesn't work on the newer sites (AFAIK)
    – Ivo Flipse
    Jan 4 '11 at 0:43
  • I don't think I've ever even used any of the "old" sites. Guess I am pretty new here. @Ivo
    – oKtosiTe
    Feb 26 '11 at 17:56
  • 1
    What about a new sorting order "number of answers" and "has accepted answer"? This could help here, I think. Sep 6 '11 at 1:32
  • 3
    This is a really relevant request that deserves an answer. If SE want people to accept answers, it should also provide an easy way for the user to be reminded which question he or she hasn't accepted any answers on yet. It would be enough if you could list your own threads the same way they are listed on the front pages of SE sites (that is, with the questions with accepted answers marked in some way).
    – Speldosa
    Nov 14 '11 at 22:13

I don't know of a good way to do this across all sites, but for any one site you can simply search using the hasaccepted operator and specifying your userID (or me) as the user.



This is planned for http://stackexchange.com -- to have a global profile with "greatest hits" of your best questions and answers across all sites.

edit: this is now complete per https://blog.stackoverflow.com/2011/04/stack-exchange-network-profiles/

  • That's good to hear! Looking forward to any updates or additional information.
    – oKtosiTe
    Jan 4 '11 at 1:28
  • 1
    On second thought, perhaps you're referring to the "top" questions. What I'm looking for is a listing of only open questions. Is that in the works too?
    – oKtosiTe
    Feb 25 '11 at 12:47
  • 10
    Still wondering if a listing of open questions is in the pipeline...
    – oKtosiTe
    Apr 20 '11 at 8:57
  • @oKtosiTe: please define open: no accepted answer, no upvoted answer or no answer at all? May 4 '11 at 7:27
  • I did. It's already in my question. (No answer accepted.) @Tobias
    – oKtosiTe
    May 4 '11 at 8:50
  • 5
    This still does not answer my question.
    – oKtosiTe
    Sep 5 '11 at 21:44
  • 3
    This is not an answer to the question.
    – Speldosa
    Nov 14 '11 at 22:13
  • This is a great feature, but, there is still no way to see all the questions for which I have to accept an answer (i.e. a question with one or more answers, that I have not accepted). Oct 7 '13 at 5:14
  • I think the global profile should contain a "check list" of things I have to do, specifically, accept an answer. Oct 7 '13 at 5:14
  • Doesn't answer the question at all! Sep 7 '16 at 16:33

It's possible to list these with a SEDE query, if you accept the fact that SEDE data is refreshed once a week, on Sunday morning. You'll need your network account ID, which you can find here.

For reference, here is the complete query:

-- result table, don't rename and keep the site column
create table #results (site nvarchar(250), id int, title nvarchar(250), answercount int);

declare @sql nvarchar(max) = ''   -- holds build up sql string

-- build one biq union sql, for each db
select @sql = @sql 
+ iif( len(@sql) > 1 
     , 'union'
     , 'insert into #results'
) +
-- here goes the per site query, fully qualify the database objects
select ''' + name + '''
     , p.id, p.title, p.answercount
from ' + quotename(name) + '.dbo.posts as p
inner join ' + quotename(name) + '.dbo.users as u on p.owneruserid = u.id
where p.posttypeid = 1
  and p.acceptedanswerid IS NULL
  and u.accountid = ' + CAST(##AccountId:int## AS nvarchar) + ''
from sys.databases
where database_id > 5
-- and (name not like '%.Meta' or name = 'StackExchange.Meta')

-- AccountId: The global account ID of the user, which you can find in the URL of their network profile. Visit this link: https://stackexchange.com/users/current to see your own ID.

-- execute it
exec (@sql)

  LOWER('https://' +
    IIF(PATINDEX('%.Mathoverflow%', site) > 0,
    IIF(PATINDEX('%.Meta', site) > 0, 'meta.mathoverflow.net', 'mathoverflow.net'),
      IIF(PATINDEX('%.Ubuntu%', site) > 0,
      IIF(PATINDEX('%.Meta', site) > 0, 'meta.askubuntu.com', 'askubuntu.com'),
        IIF(PATINDEX('StackExchange.%', site) > 0,
          CASE SUBSTRING(site, 15, 200)
          WHEN 'Audio' THEN 'video'
          WHEN 'Audio.Meta' THEN 'video.meta'
          WHEN 'Beer' THEN 'alcohol'
          WHEN 'Beer.Meta' THEN 'alcohol.meta'
          WHEN 'CogSci' THEN 'psychology'
          WHEN 'CogSci.Meta' THEN 'psychology.meta'
          WHEN 'Garage' THEN 'mechanics'
          WHEN 'Garage.Meta' THEN 'mechanics.meta'
          WHEN 'Moderators' THEN 'communitybuilding'
          WHEN 'Moderators.Meta' THEN 'communitybuilding.meta'
          WHEN 'Photography' THEN 'photo'
          WHEN 'Photography.Meta' THEN 'photo.meta'
          WHEN 'Programmers' THEN 'softwareengineering'
          WHEN 'Programmers.Meta' THEN 'softwareengineering.meta'
          WHEN 'Vegetarian' THEN 'vegetarianism'
          WHEN 'Vegetarian.Meta' THEN 'vegetarianism.meta'
          WHEN 'Writers' THEN 'writing'
          WHEN 'Writers.Meta' THEN 'writing.meta'
          ELSE SUBSTRING(site, 15, 200)
          END + '.stackexchange.com',
          IIF(PATINDEX('StackOverflow.%', site) > 0,
            CASE SUBSTRING(site, 15, 200)
            WHEN 'Br' THEN 'pt'
            WHEN 'Br.Meta' THEN 'pt.meta'
            ELSE SUBSTRING(site, 15, 200)
            END + '.stackoverflow.com',
            IIF(PATINDEX('%.Meta', site) > 0,
              'meta.' + SUBSTRING(site, 0, PATINDEX('%.Meta', site)) + '.com',
              site + '.com'
    + '/q/' + CAST(id AS NVARCHAR)
    + '|' + title,
    answercount AS [Number of answers]
  FROM #results
  ORDER BY answercount DESC

You must log in to answer this question.

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