nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

SQL Query to find WorkSpaces without Documents

JoelShall

I've been requested to create a report to find all WorkSpace in our database that currently do not contain documents. I'm wondering if someone already has this built-out that I can use as a starting point or reference tool?

Find more posts tagged with

Comments

Migrateduser

You'll have to do an outer join on the project_items table and projects using the tree-id of the WorkSpace to find WorkSpaces (prj_id = tree_id) where there are no project_items records for documents (item_type = d).

JoelShall

I tried your suggestion but was unable to get the query to provide the results I want. Can you provide more in detail the sql needed to get Workspaces without documents?