Hot answers tagged

13

Search should be back online now. We pushed a configuration change to ElasticSearch to enable Search Slow Logging and there was an issue with the change. We rolled back the config change and will do further testing before pushing it again.


8

Such a complicated search practically begs for a SEDE query. Since comments can be deleted, I've made that part optional. Here is a list of questions you edited containing the word 'code': Note that SEDE is updated once a week, on Sunday morning. If you want to experiment, fork the query, before or after you've read the awesome tutorial.


6

Stack Overflow has 11 million users. Auto-searching after typing just a single character would generate far too many results to be useful (there are probably at least a million usernames that begin with "S", for example), so it waits until you've typed at least three characters before doing anything. Not only are there far fewer tags than users (60,000 ...


6

Since using the markdown [tag:exception] on Meta Stack Overflow creates a link to https://stackoverflow.com/questions/tagged/exception, you can search for url:https://stackoverflow.com/questions/tagged/exception This search currently gives 5 results: It'll miss instances where people aren't using the tag markdown, e.g. like this: When you use the [...


5

While url:* is the obvious way to search for all the links (so ideally highlighting would work with it), you can also use url:// which returns the same results with no weird highlighting:


4

Here is a SEDE query you could use. Note that due to the variable nature of how tags are created, you'd need to search for both bigdata: and big-data: As stressed by the comments, a tag being often used (even in the same context, like choosing Cooking's 'salt' when you have a question about flavour, instead of the more often used Stack Overflow's 'salt') ...


3

Answers don't have tags, Questions have. Joining with PostTags on the Posts.ParentId should do the trick for that snippet: WITH Answers AS ( SELECT * FROM Posts as P INNER JOIN PostTags pt -- posttags is the join table ON pt.postid = p.parentid -- join the question INNER JOIN Tags ...


3

The Tags field looks like this: <java><unicode><comments> so you need to use LIKE. Here's how I did it (matching on the questions' tags): WHERE Questions.PostTypeId = 1 -- Questions AND Questions.Tags LIKE '%<java>%' -- Line I added AND year(Questions.CreationDate) between '2014' AND '2018'


2

The on site search is a bit less optimal with attempts like [tags] exception and title:exception. With a SEDE Query that check all revisions of the raw markdown for the markup [tag:exception] the results becomes much better: Keep in mind SEDE is only updated once a week, on Sunday morning. If you're new to SEDE do checkout the tutorial and visit SEDE chat ...


2

There's no list in your profile, but you can use the Data Explorer if you accept that results can be up to one week old (it's refreshed every Sunday morning). This query lists all protections a user has made on a certain site (they may be superseded by a later unprotection).


1

They're called deleted posts for a reason: they are deleted, since they do not belong on the site. From the Help Center: Viewing deleted posts You now have privileged access to posts that have been removed, either by their authors, by users with access to moderator tools, by moderators, or by the system. Use this privilege wisely: Make ...


1

In the 6 to 8 weeks you have to wait to get this implemented, you can use this SEDE query, if you allow for a lag of up to 7 days: select a.id as [Post Link] , a.body , a.owneruserid as [User Link] , a.score , a.creationdate , a.lasteditdate from posts a inner join posts q on q.id = a.parentid where q.owneruserid = ##userid:int?...


Only top voted, non community-wiki answers of a minimum length are eligible