We are wanting to get the contents of a wiki page from the db but do not know the query for this. There's only two table in the database schema, wiki and wiki_stream_event. Are there any others we are missing?
you should perform the query to the COURSE_CONTENTS table where the CNTHNDLR_HANDLE is equal to 'resource/x-bb-wiki"
The comments on a wiki page are in the cms_doc_BBLEARN Schema in XYF_comments table.
Hope that helps.
For just the entries:
FROM WIKI_STREAM_EVENT wse
INNER JOIN users u ON WSE.ACTOR_PK1 = u.pk1
LEFT JOIN course_main cm ON WSE.CRSMAIN_PK1 = cm.pk1
AND (cm.COURSE_ID like '1183-THEUA%' or cm.COURSE_ID like 'MASTER-1183%')
ORDER BY EVENT_DATE
Thanks Andrew and Chris. That has been helpful. Too bad we cannot locate the contents of a wiki page.
Retrieving data ...