Try our conversational search powered by Generative AI!

Query page record in the database


I have pages with pagetype CoursePage.

This coursepage pagetype has a property of courseID (e.g. L01, C05, X03) and courseName (e.g. Parasites, Flea worms).

Is there a way to query these records directly from MSSQL? Just want to get all coursepages with their courseid and coursename details.

From what tables are these details stored?



Oct 31, 2011 3:40

Hi Jan

Instead of querying the DB directly I would use FindPagesWithCriteria instead.

Hope this helps.


Oct 31, 2011 9:48

If you know some SQL it should be fairly easy for you to write a SELECT...JOIN for the following tables:

tblPageType, tblPageDefinition and tblProperty

Using the relations:

tblPageDefinition.fkPageTypeID = tblPageType.pkID


tblProperty.fkPageDefinitionID = tblPageDefinition.pkID

Dec 02, 2011 1:34
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.