November Happy Hour will be moved to Thursday December 5th.

AI OnAI Off

Query page record in the database

Jan Montano
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
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
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
* 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.