Subversion Repositories SmartDukaan

Rev

Rev 5156 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5156 Rev 5466
Line 109... Line 109...
109 
				<Table name="source">
 109 
				<Table name="source">
110 
				</Table>
 110 
				</Table>
111 
				<Level name="First Source" column="id" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 111 
				<Level name="First Source" column="id" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
112 
					<KeyExpression>
 112 
					<KeyExpression>
113 
						<SQL dialect="generic">
 113 
						<SQL dialect="generic">
114 
							case when source.is_paid = 1 then &#39;Paid&#39; when source.url like &#39;saholic.com%&#39; then &#39;Direct&#39; when source.url like &#39;google.co%&#39; then &#39;Search&#39; else &#39;Referer&#39; end						</SQL>
 114 
							case when source.is_paid = 1 then &#39;Paid&#39; when source.url like &#39;saholic.com%&#39; then &#39;Direct&#39; when source.url like &#39;google.co%&#39; then &#39;Search&#39; when source.url like &#39;email%&#39; then &#39;Newsletter&#39; else &#39;Referer&#39; end						</SQL>
115 
					</KeyExpression>
 115 
					</KeyExpression>
116 
					<NameExpression>
 116 
					<NameExpression>
117 
						<SQL dialect="generic">
 117 
						<SQL dialect="generic">
118 
							case when source.is_paid = 1 then &#39;Paid&#39; when source.url like &#39;saholic.com%&#39; then &#39;Direct&#39; when source.url like &#39;google.co%&#39; then &#39;Search&#39; else &#39;Referer&#39; end						</SQL>
 118 
							case when source.is_paid = 1 then &#39;Paid&#39; when source.url like &#39;saholic.com%&#39; then &#39;Direct&#39; when source.url like &#39;google.co%&#39; then &#39;Search&#39; else &#39;Referer&#39; end						</SQL>
119 
					</NameExpression>
 119 
					</NameExpression>