Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more
AI OnAI Off
Query page record in the database
Hi Jan
Instead of querying the DB directly I would use FindPagesWithCriteria instead.
Hope this helps.
Frederik
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
and
tblProperty.fkPageDefinitionID = tblPageDefinition.pkID
Dec 02, 2011 1:34
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.