anchor.diff:  		
   		<cfif outStruct.statuscode neq getStatus.final_status and outStruct.statuscode does not contain "open" >
   			<cfquery datasource="cah" name="getStatus">
  -			UPDATE cah.asset 
  +			UPDATE asset 
   				SET final_status = "#LCase(outStruct.statuscode)#"
   			WHERE 	uuid = '#arguments.assetid#'
   			</cfquery>
  
positive.code: 	</cfsavecontent>
  
  	<cfreturn rtn >
  </cffunction>
  
  <cffunction name="getPageUrl" output="no" returntype="string">
  
negative.code: 	<cfargument name="type" type="string" required="true" default="NA"/>
  	<cfargument name="filter" type="string" required="false" default=""/>
  
  	<cftry>
  		<cfquery datasource="cah" name="qryAssets">
  		<cfif arguments.type eq "user" >
  			SELECT * FROM asset 
  			WHERE 	submitter = '#arguments.filter#'
  		<cfelseif arguments.type eq "open" >
  			SELECT 	*
  			FROM	asset 
  			WHERE	(final_status IS NULL or
  					final_status = '')
  					and convert_status = 1
  		<cfelseif arguments.type eq "rejected" >
  			SELECT 	*
  			FROM	asset 
  			WHERE	final_status = 'rejected'
  		<cfelseif arguments.type eq "accepted" >
  			SELECT 	*
  			FROM	asset 
  			WHERE	final_status = 'accepted'
  		<cfelseif arguments.type eq "all" >
  			SELECT * FROM asset 
  			WHERE 	convert_status = 1
  		<cfelseif arguments.type eq "unconverted" >
  			SELECT * FROM asset 
  			WHERE 	convert_status = 0
  		<cfelse>
  			SELECT a.* FROM asset a LEFT JOIN approval b ON a.uuid = b.assetid
  			WHERE	(	a.final_status IS NULL or
  						a.final_status = '') AND 
  					a.submitter <> '#session.mura.userid#' 
  					and convert_status = 1
  				<cfif $.currentUser().isInGroup("Reviewer") >
  					AND a.uuid NOT IN  (	SELECT c.assetid FROM approval c
  											WHERE 	c.assetid = a.uuid AND
  													c.reviewtype = 'peer' AND 
  													c.approver = '#session.mura.userid#')
  				<cfelseif $.currentUser().isInGroup("Developer") >
  		 			AND (	SELECT Count(*) FROM approval c
  							WHERE 	c.assetid = a.uuid AND
  									c.reviewtype = 'peer') > 1 
  					GROUP BY a.uuid
  				</cfif>
  		</cfif>
  		
  		</cfquery>
  
  		<cfcatch><cfrethrow><cfset qryAssets = QueryNew("none") /></cfcatch>		
  	</cftry>
  
  	<cfreturn qryAssets />
  </cffunction>
  
  