What to do about undefined (no description) tags? (Example: [react-templates])


Please login or register to vote for this query.

(click on this box to dismiss)


Stack Overflow

Q&A for professional and enthusiast programmers

select t.tagname
     , (case when t.WikiPostId is null and t.excerptPostId is null
            then 'No Wiki/NoExcerpt'
            when t.WikiPostId is null 
            then 'No Wiki'
            when t.excerptPostId is null 
            then 'No Excerpt'
            else '???'
            end) as [What is missing]
from  tags t
where (t.excerptPostId is null -- where the excerpt foreignkey is null
or t.WikiPostId is null) -- or the wiki foreignkey is null
order by [count] desc

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results