<jsp:directive.page pageEncoding="UTF-8" />
<!-- ユーザー：画面クロス集計 -->
<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}">
		select A.USERID,B.NAME_JA,A.GUIKEY
				, sum(A.CNT_ACCESS) as ACC
				, sum(A.CNT_ERROR) AS ERR
				, sum(A.CNT_READ) AS RD
				, sum(A.CNT_WRITE) AS WT
				, sum(A.TM_TOTAL_QUERY) AS TQ
				, max(A.TM_MAX_QUERY) AS MQ
		from GE15 A left outer join GEA10 B
		on      A.SYSTEM_ID = B.SYSTEM_ID
		and     A.USERID    = B.USERID
	<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:where>
--	group by B.NAME_JA,CUBE(A.USERID,A.GUIKEY)
	group by B.NAME_JA,A.USERID,A.GUIKEY
	order by A.USERID,A.GUIKEY
</og:query>

<og:view
	viewFormType = "HTMLCrossTable"
	command    = "{@command}"
	checked    = "{@checked}"
	startNo    = "{@startNo}"
	pageSize   = "{@pageSize}"
	useParam   = "true"
  >
	<og:crossParam
		cubeXColumn    = "USERID"
		cubeYColumn    = "GUIKEY"
		noGroupColumns = "NAME_JA"
		sumNumber      = "6"
		shokeiLabel    = "SHOKEI"
		gokeiLabel     = "GOKEI"
		cubeSortType   = "STRING"
	/>
</og:view>
