Query page record in the database

Jan Montano

Vote:

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?

Cheers.

#54718

Oct 31, 2011 3:40

Frederik Vig

Vote:

Hi Jan

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

Hope this helps.

Frederik

#54720

Oct 31, 2011 9:48

Johan Book

Vote:

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

and

tblProperty.fkPageDefinitionID = tblPageDefinition.pkID

#55454

Dec 02, 2011 1:34