Created
May 17, 2018 21:33
-
-
Save greggnakamura/7d5207d74510dc3f18a16b218a539a1d to your computer and use it in GitHub Desktop.
Kentico: QueryRepeater JOINS
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT 0 AS TableID -- IFDA_Event Identifier | |
| ,EventTitle AS Title | |
| ,EventSummary AS EventSummary | |
| ,AlignContent AS AlignContent | |
| ,EventLocation AS LocationTopic | |
| ,EventDate AS ItemDate | |
| ,EventDateEnd AS ItemDateEnd | |
| ,FeaturedEvent AS Featured | |
| ,EventBannerImage AS BannerImage | |
| ,EventFacility AS Facility | |
| ,DocumentURLPath | |
| ,NodeAliasPath | |
| FROM IFDA_Event INNER JOIN View_CMS_Tree_Joined ON EventID = DocumentForeignKeyValue | |
| WHERE FeaturedEvent = 1 AND ClassName = 'IFDA.Event' | |
| UNION | |
| SELECT 1 AS TableID -- IFDA_News Identifier | |
| ,ArticleTitle AS Title | |
| ,ArticleTeaserText AS EventSummary | |
| ,AlignContent AS AlignContent | |
| ,ArticleTopic AS LocationTopic | |
| ,ArticleDate AS ItemDate | |
| ,ArticleDate AS ItemDateEnd --dummy field | |
| ,FeaturedArticle AS Featured | |
| ,FeaturedArticleImage AS BannerImage | |
| ,ArticleDetails AS Facility --dummy field | |
| ,DocumentURLPath | |
| ,NodeAliasPath | |
| FROM IFDA_News INNER JOIN View_CMS_Tree_Joined ON NewsID = DocumentForeignKeyValue | |
| WHERE FeaturedArticle = 1 AND ClassName = 'IFDA.News' |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment