List of categories suppressed from homepage


(Charles Walter) #1

Anyone know a query or easy way to get a list of categories that are suppressed from homepage?

I could eyeball it, but we have over a 100 categories.

Getting ready for a test to switch to category view vs. latest view, and I want to make sure I reenable all the categories that had previously been suppressed.


(Mittineague) #2

The categories table has a lot of fields, so you may want to not do a SELECT *
but the field you’re interested in is
suppress_from_homepage boolean null, default false


(Charles Walter) #3

Thanks. I ran this query in case anyone wants to use it in the future. Providing me other details as well…

SELECT
    c.name,
    c.topics_month,
    c.topics_year,
    c.suppress_from_homepage,
    c.posts_month
FROM categories c
WHERE c.id > 0