Instead of querying the DB directly I would use FindPagesWithCriteria instead.
Hope this helps.
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
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?