hi,
I want to query pageids of all the pages in a space. Could you please let me know which table stores this info?
Thanks in advance!
Chintu
You would need to join the content table on the spaces table, based on the spaceid in both columns, something like this:
SELECT title, contentid FROM content WHERE spaceid = (SELECT spaceid FROM spaces WHERE spacekey = 'yourspacename') ORDER BY 1;
or
SELECT C.title, C.contentid FROM content C INNER JOIN spaces S ON C.spaceid = S.spaceid ORDER BY title;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.