Start line:  
End line:  

Snippet Preview

Snippet HTML Code

Stack Overflow Questions
<?xml version="1.0" encoding="UTF-8"?>
<entity-mappings xmlns="http://java.sun.com/xml/ns/persistence/orm"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://java.sun.com/xml/ns/persistence/orm http://java.sun.com/xml/ns/persistence/orm_2_0.xsd" version="2.0">


    <named-query name="BC_READ_SEARCH_URL" >
 		<query>SELECT page
               FROM org.broadleafcommerce.core.search.redirect.domain.SearchRedirect page
               WHERE
                 upper(page.searchTerm) = upper(:searchTerm)  and (page.activeStartDate is null or page.activeStartDate &lt;= :now) and (page.activeEndDate is null or :now &lt;= page.activeEndDate   )
               order by page.searchPriority
		</query>
	</named-query>

</entity-mappings>
New to GrepCode? Check out our FAQ X