Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Need Help with SQL

Benedikt Kayko
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 24, 2024

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

1 answer

0 votes
Florian Bonniec
Community Champion
January 24, 2024

Hi @Benedikt Kayko 

 

This may work.

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

Regards

Benedikt Kayko
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 24, 2024

Thanks

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events