3

feature suggestion

It would be great if there were 2 different searches:

  • standard search (status quo): search in tag names only
  • extended search: search in tag names + tag descriptions
    That would make it easier to find some tags.

use cases

I'll give some examples for aviation.SE:

  • user doesn't know a certain technical term. Standard search for "drone" doesn't find anything. Searching "drone" in descriptions would find . Same for "oxygen deprivation" instead of .

  • user wants to find a health-related tag, but doesn't know which one is used for that. "Health" doesn't yield any results in the standard search. Using the tag description search, the user would find .

  • user wants to find ALL tags including a certain word like "wings" or "radar". Standard search for "radar" finds , , , , but not

  • Also remember that for some users English is a foreign language. So the extended search is helpful for users with limited vocabulary.

  • 1
    Do you have an example of where this would be useful? – fbueckert Dec 13 '18 at 21:28
  • 1
    I don't understand the question. This is useful for any tag. – summerrain Dec 13 '18 at 21:39
  • 1
    I don't understand your request. What use case is there for searching descriptions? Give us an example where this can provide some utility. – fbueckert Dec 13 '18 at 21:44
  • There are so many use cases that I have a hard time believing that you can't imagine any. It's like asking "why would a search be useful" ? Regardless, I have added some use cases to the RFE. – summerrain Dec 13 '18 at 22:24
  • How would this be implemented? A specific operator to switch to tag description mode? If this were to be implemented, maybe it should include the tag wiki. – hat Dec 14 '18 at 19:52
  • maybe a drop-down menu or radio buttons to choose between "search in tags only", "search in tags+description", "search in tags+description+ wiki" (the latter is possible via the SEDE query posted in the answer below). – summerrain Dec 14 '18 at 20:54
5

Until this feature is implemented, you can use the following SEDE query to search in tag names, tag descriptions ('excerpts') and tag wikis.

enter image description here

SELECT t.TagName, 'Tag', ''
  FROM Tags AS t
  WHERE t.TagName LIKE '%' + ##query:string## + '%' collate sql_latin1_general_cp1_ci_ai

UNION ALL

SELECT t.TagName, 'Excerpt', p.Body
  FROM Tags AS t
  INNER JOIN Posts AS p
    ON p.Id = t.ExcerptPostId
  WHERE p.Body LIKE '%' + ##query:string## + '%' collate sql_latin1_general_cp1_ci_ai

UNION ALL

SELECT t.TagName, 'Wiki', p.Body
  FROM Tags AS t
  INNER JOIN Posts AS p
    ON p.Id = t.WikiPostId
  WHERE p.Body LIKE '%' + ##query:string## + '%' collate sql_latin1_general_cp1_ci_ai

Note that SEDE is updated once every week, on Sunday morning.

  • You might want to add collate sql_latin1_general_cp1_ci_ai to those LIKE clauses to make those searches case insensitive – rene Dec 13 '18 at 21:40
  • Heh, I always forget about those... – Glorfindel Dec 13 '18 at 21:41
  • Very helpful for the meanwhile. Thanks! – summerrain Dec 13 '18 at 22:34

You must log in to answer this question.

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