find undeleted files

[Thomas Richter]

I try to find undeleted directories named .settings:

select revisions 
from dir "/" 
where (is head and 
path like "**/.settings" and
path like "**/trunk/**") 
order by date  desc  
group by directory 
return path

But I find also deleted dirs ...

[Sergey Svishchev]

Add "not is deleted" clause, like this:

select revisions 
from dir "/"
where (is head and
path like "**/trunk/**/.settings" and
not is deleted) 
order by date desc 
group by directory 
return path, date, isDeleted