table skills
from #job_search and -"Templates"S
where skills AND (skills!=list()) AND (!contains(skills,list())) AND (length(skills)>0) AND (!contains(skills, null)) AND (skills != null)
What I’m trying to do
I want to exclude files with “skills” variable containing an empty list.
What does the following display for you? I think it should work for everything except excluding a file with a skills list with only one or more empty strings in it (i.e. skills: [''] won’t be excluded).
table skills
from #job_search and -"Templates"S
where skills