Page Content in Database

Ecem Kanıyılmaz

Hi,

We try to access page content from database. The content of the page is too long. We wrote a query using BODYCONTENT and CONTENT tables. However, we were able to access only a part of the page content with this query. We could not find where in the database the rest of the page content is stored.

Why can we only see part of the page content in database?

Where can we find the rest of the page content in the database?

 

Thanks.

Radek Dostál

However, we were able to access only a part of the page content with this query. We could not find where in the database the rest of the page content is stored.

Then you queried wrong pages, or old page histories, but not the current version. As we don't know the SQL you used, hard to tell.

 

To get up to date content I used this:

SELECT c.contentid, c.contenttype, c.title, s.spacekey 
FROM CONTENT c 
JOIN BODYCONTENT bc 
    ON c.contentid = bc.contentid 
JOIN SPACES s 
    ON c.spaceid = s.spaceid 
WHERE c.prevver IS NULL
    AND c.contenttype IN ('PAGE', 'BLOGPOST')
    AND bc.body LIKE '%STRING YOU SEARCH FOR%';

 

That said, I don't quite see the need to query the db, or the expectation of the content being too long - you're querying the content, you get what you query for.

Whatever it is you're doing, there probably is a better way than sql.