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 ...
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
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.