<jsp:directive.page pageEncoding="UTF-8" />
<!-- 一覧明細検索 -->
<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}">
		select A.USERID,A.GUIKEY,B.NAME_JA,A.USED_TIME,A.CNT_ACCESS,A.CNT_ERROR,A.CNT_READ,A.CNT_WRITE
				,A.TM_TOTAL_QUERY AS SUM_TOTAL_QUERY
				,A.TM_MAX_QUERY,A.USERADRS,A.HOSTADRS,A.DYLOGIN,A.DYLOGOUT,A.MAX_QUERY
		from GE15 A left outer join GEA11 B
		on      A.SYSTEM_ID = B.SYSTEM_ID
		and     A.GUIKEY    = B.GUIKEY
	<og:where>
		<og:and value = "A.SYSTEM_ID	= 	 '{@SYSTEM_ID}'"	/>
		<og:and value = "A.GUIKEY		like '{@GUIKEY}'"		/>
		<og:and value = "A.USERID		=	 '{@USERID}'"		/>
		<og:and value = "A.DYLOGIN		like '{@DATE}'"			/>
		<og:and value = "A.TM_MAX_QUERY = '{@TM_MAX_QUERY}'"	/>
	</og:where>
	order by A.SYSTEM_ID,{@SORT} A.USERID,A.GUIKEY
</og:query>

<og:viewLink command="{@command}">
	<og:link column="GUIKEY" gamenId="GE0002" href="index.jsp" target="CONTENTS"
		keys="command,SYSTEM_ID,GUIKEY,LANG"
		vals="NEW,{@SYSTEM_ID},[GUIKEY],ja" />
	<og:link column="USERID" gamenId="GE0001" href="index.jsp" target="CONTENTS"
		keys="command,SYSTEM_ID,USERID"
		vals="NEW,{@SYSTEM_ID},[USERID]" />
<!--
	<og:link column="MAX_QUERY" gamenId="ORA06" href="index.jsp" target="CONTENTS"
		keys="command,SQL"
		vals="NEW,[MAX_QUERY]" />
	<og:link column="MAX_QUERY" gamenId="03_DBSEARCH" href="index.jsp" target="CONTENTS"
		keys="command,SQL_TEXT"
		vals="NEW,[MAX_QUERY]" />
-->
</og:viewLink>

<og:view
	viewFormType = "HTMLTable"
	command      = "{@command}"
	checked      = "{@checked}"
	startNo      = "{@startNo}"
	pageSize     = "{@pageSize}" />
