How to relate custom page type to View_CMS_Tree_Joined?

Rananjay Singh asked on December 14, 2022 15:27

I have find the solution of my question.

SELECT DocumentName,NodeAliasPath,name,Link,custom_property.region,Photo from View_CMS_Tree_Joined

JOIN CONTENT_Article on DocumentForeignKeyValue = ArticleID and ClassName ='custom.property'

where ##where## Order by ##orderby##

Recent Answers

Rananjay Singh answered on December 14, 2022 15:28

Use below statement, its working fine for me.

SELECT DocumentName,NodeAliasPath,name,Link,custom_property.region,Photo from View_CMS_Tree_Joined

JOIN CONTENT_Article on DocumentForeignKeyValue = ArticleID and ClassName ='custom.property'

where ##where## Order by ##orderby##

0 votesVote for this answer Mark as a Correct answer

Trevor Fayas answered on December 19, 2022 16:57

You got it Rananjay, keep in mind that if you use the IPageRetriever<Article>() (generate your Article class) then this does the join automatically for you.

0 votesVote for this answer Mark as a Correct answer