We print 4 catalogs each year (Spring, Everyday, Fall, Christmas). We have a custom field for each Catalog season, where we input the year (so the field CatCodeSpring would show 2023 if a particular item appeared in the 2023 Spring catalog). When building a saved search, is there a formula or easier way to look at a year's worth of catalog items, rather than having each CatCode as a separate criteria or filter field? #savedsearch
ETA: This seems to be working - CASE WHEN {custitem_mhi_catalog_code_spring} like '%23' OR {custitem_mhi_catalog_code_everyday} like '%23' OR {custitem_mhi_catalog_code_fall} like '%23' OR {custitem_mhi_catalog_code_xmas} like '%23' then '1' else '0' END