Mobile Website

SUMMARY

The Mobile website is fed using the Skimmer Sections. To add content to the Skimmer Sections and the Mobile website refer to the Skimmer Documentation. Additional configurations are made in the console using the Mobile Config controller.  

VIDEOS

Summary

Configuration

Configure Feature

FEATURE IMAGES

Uses skimmer queries. To add the image in a feature the skimmer query must include an image value with the column name Img. 

Example:
SELECT     TOP (6) oWeblog_Entries_ID AS ID, Title, Summary AS Lead, Body, CONVERT(Varchar, Date_Written, 101) AS PubDate, '/blogs/detail/' + CONVERT(varchar,
                     oWeblog_Entries_ID) AS Link, '/mypathtoimage/' + Image AS Img
FROM         oWeblog_Entries
WHERE     (ISNULL(Turn_this_off, 0) <> 1)
ORDER BY CONVERT(Varchar, Date_Written, 112) DESC, Title 

FEATURE QUERY

This query is for Website Features. Use it if you want to create a mobile feature from any of the Zones in your Website Features.

SELECT     TOP (4) oZone_Objects_XNCYVE_ID AS ID, Headline_GJNMK6 AS Title,
isnull(Mobile_Body, Lead_NTYHMX) AS Body, NULL AS Lead,           
            CONVERT(Varchar, Start_Date_PHKVQC, 101) AS PubDate,
            ISNULL(ISNULL(ISNULL(External_link_KR6FDG,
            '/pages/detail/' + CONVERT(varchar,Related_Page_HSSWJM)),
            '/events/detail/' + CONVERT(varchar,Event_6CXTAM)),
            '/news/detail/' + CONVERT(varchar,Article_RIX7S7)) AS Link,
            '/console/files/oZone_Objects_XNCYVE/' + Mobile_Image AS Img
FROM         oZone_Objects_XNCYVE INNER JOIN oWebsite_Zones_BXQYPF ON oWebsite_Zones_BXQYPF_ID = Zone_IZMHMU
WHERE ISNULL(Archive_RXVQMG, 0) <> 1
            AND (Start_Date_PHKVQC <= GETDATE() OR Start_Date_PHKVQC IS NULL)
            AND (End_Date_MRXWM2 > GETDATE() OR End_Date_MRXWM2 IS NULL)
            AND Zone_XF3LZV = 'Homepage Main Feature Area'
            ORDER BY Sort_Order_KAMDBZ

PEOPLE QUERY

Required Fields:
Person, Title, Address, Email, Phone, Cell

Example:
Select Distinct People_First_Name + ' ' + People_Last_Name as Person, ISNULL(Pastor_1_Title, Pastor_2_Title) as Title,
Churches_Name_Full + '<br>' + isnull(Churches_Address_1, '') + ' ' + isnull(Churches_Address_2, '') + '<br >' +  
isnull(Churches_City, '') + ', ' + ISNULL(Churches_State, '') + ' ' + ISNULL(Churches_Zip_Code, '') as Address,
People_Email AS Email, Churches_Church_Phone as Phone, '' as Cell
From oPeople INNER JOIN oChurches on oChurches.Pastor_KXK8MQ = oPeople.People_ID or oChurches.Pastor_2 = oPeople.People_ID
Where ((People_Deceased is null or People_Deceased = 0) AND people_last_name is not null AND  isnull(Clergy_6GSXAK, 0) = 1)

Note:
Must contain a WHERE clause
MUST NOT Contain ORDER BY