<?xml version="1.0" encoding="UTF-8" ?>
<jsp:root
	xmlns:jsp="http://java.sun.com/JSP/Page"
	xmlns:og="hybs-taglib.tld"
	version="2.0">
<jsp:directive.page language="java" contentType="text/html; charset=UTF-8" />

<!-- GE18 検索SQL。 -->
<!-- OPT_NAMES , OPT_JOIN , OPT_WHERE , OPT_ORDER で、それぞれの位置に、SQL文を、追加することが出来ます。 -->
<og:query command="{@command}" debug="{@debug}" maxRowCount="0" quotCheck="false">
		SELECT A.LOC_COL,A.LOC_ROW,A.UNIQ
				{@OPT_NAMES}
		FROM GE18 A {@OPT_JOIN}
	where A.SYSTEM_ID='{@SYS.SYSTEM_ID}' and A.FGJ='1'
	<og:where startKey="and">
		<og:and value="A.LOC_GRP	like '{@LOC_GRP}'"		/>
		<og:and value="A.LOC_KEY	like '{@LOC_KEY}'"		/>
		<og:and value="A.LOC_COL	like '{@LOC_COL}'"		/>
		<og:and value="A.LOC_ROW	like '{@LOC_ROW}'"		/>
		<og:and value="A.NAME_JA	like '{@NAME_JA}'"		/>
		<og:and value="A.LABEL_NAME	like '{@LABEL_NAME}'"	/>
		<og:and value="A.BIKO		like '{@BIKO}'" 		/>
		<og:and value="A.ICON		like '{@ICON}'" 		/>
		<og:and value="A.R_KEY1		like '{@R_KEY1}'"		/>
		<og:and value="A.R_KEY2		like '{@R_KEY2}'"		/>
		<og:and value="A.R_KEY3		like '{@R_KEY3}'"		/>
		{@OPT_WHERE}
	</og:where>
		{@OPT_ORDER}
</og:query>

</jsp:root>
