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; } } }

Need Help with SQL

Benedikt Kayko_vtd5fw

I need support in creating a SQL that shows me all pages that are assigned to a Space (Spaceid available)

Accepted answers

All comments

Florian Bonniec

Hi @Benedikt Kayko

This may work.

<span>SELECT</span> title, contentid 
<span>FROM</span> content 
<span>WHERE</span> contenttype <span>=</span> <span>'PAGE'</span> 
<span>AND</span> content_status <span>=</span> <span>'current'</span> 
<span>AND</span> spaceid <span>=</span> <span><</span>YourSpaceId<span>></span>;

Regards

Benedikt Kayko_vtd5fw

Thanks

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server