경로
modules/nstore/queries/getstocksubquery.xml
코드
<query id="getstocksubquery" action="select">
<tables>
<table name="nstore_stock_log" alias="stock" />
</tables>
<columns>
<column name="stock.item_srl" />
<column name="stock.location" />
<query id="getstock1data" alias="stock">
<tables>
<table name="nstore_stock_log" alias="stock_log" />
</tables>
<columns>
<column name="stock" alias="stock" />
</columns>
<conditions>
<condition operation="equal" column="stock_log.item_srl" default="stock.item_srl" />
<condition operation="equal" column="stock_log.location" default="stock.location" pipe="and" />
</conditions>
<navigation>
<index var="sort_index" default="stock_log.stock_log_srl" order="desc" />
<list_count var="list_count" default="1" />
</navigation>
</query>
</columns>
<groups>
<group column="stock.item_srl" />
<group column="stock.location" />
</groups>
</query>설명
댓글 0
댓글작성칸으로