Page tree
Skip to end of metadata
Go to start of metadata
<Request method="GET">
		<Sql id="user" type="query" when="$authType eq 'normal'"> 
          	SELECT * FROM account WHERE emailUsers=$email
      	</Sql>
      	<Sql id="googleUser" type="query" when="$authType eq 'google'"> 
          	SELECT * FROM account WHERE emailUsers=$email
      	</Sql>
      	<Sql id="linkedInUser" type="query" when="$authType eq 'linkedin'"> 
          	SELECT * FROM account WHERE emailUsers=$email
      	</Sql>
      	<Sql id="twitterUser" type="query" when="$authType eq 'twitter'"> 
          	SELECT * FROM account WHERE emailUsers=$email
      	</Sql>
      	<Sql id="facebookUser" type="query" when="$authType eq 'facebook'"> 
          	SELECT * FROM account WHERE emailUsers=$email
      	</Sql>
	</Request>


The above request can be written as


<Request method="GET">
		<Sql id="user" type="query" when="$authType eq 'normal'"> 
          	SELECT * FROM account WHERE emailUsers=$email
      	</Sql>
	</Request>
  • No labels