Just replace the <spacename> below with the name of the particular space you want:
SELECT contentid,title FROM content WHERE prevver IS NULL AND content_status='current' AND spaceid=(SELECT spaceid FROM spaces WHERE spacename='<spacename>');
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG