希望在10次迭代后结束RTF模板BI Publisher中的循环

Question

我想在10次迭代后结束RTF模板中的for循环。有人能指导我吗？

Answer 1

测试数据

<record_set>
<record>
<rownum>1</rownum>
<transaction_id>111</transaction_id>
<amount>200</amount>
</record>
<record>
<rownum>2</rownum>
<transaction_id>222</transaction_id>
<amount>300</amount>
</record>
<record>
<rownum>3</rownum>
<transaction_id>333</transaction_id>
<amount>400</amount>
</record>
<record>
<rownum>4</rownum>
<transaction_id>444</transaction_id>
<amount>200</amount>
</record>
</record_set>

选项1

可以在if语句中使用变量。

<?for-each:record_set?>
<?xdoxslt:set_variable($_XDOCTX,'row_number',1)?>
<?for-each:record?><?if:xdoxslt:get_variable($_XDOCTX,'row_number')<=2?>
Transaction ID: <?transaction_id?>
Row Number: <?xdoxslt:get_variable($_XDOCTX,'row_number')?>
<?xdoxslt:set_variable($_XDOCTX,'row_number', xdoxslt:get_variable($_XDOCTX,'row_number')+1)?>
Amount:<?amount?>
<?end if?>
<?end for each?> 
<?end for each?>

选项2

您可以将rownum添加到select语句和XML中，然后在for每个条件中使用它。

select rownum, transaction_id, amount from your_table
<?for-each:record_set?>
<?for-each:record[rownum<=2]?>
Transaction ID: <?transaction_id?>
Row Number: <?rownum?>
Amount:<?amount?>
<?end for each?> 
<?end for each?>