我的数据集中有以下XML结构:
<DATA_DS>
<G_1>
<INVOICE_NUMber>20005</INVOICE_NUMber>
<BATCH_SOURCE_NAME>MIGRATION</BATCH_SOURCE_NAME>
<CT_REFERENCE/>
</G_1>
<G_1>
<INVOICE_NUMber>454162</INVOICE_NUMber>
<BATCH_SOURCE_NAME>FM Source Number</BATCH_SOURCE_NAME>
<CT_REFERENCE>454162</CT_REFERENCE>
</G_1>
<G_1>
<INVOICE_NUMber>455920</INVOICE_NUMber>
<BATCH_SOURCE_NAME>FM Source Number</BATCH_SOURCE_NAME>
<CT_REFERENCE>455920</CT_REFERENCE>
</G_1>
</DATA_DS>
我在表格的FOR-EACH内的RTF模板中放置了以下逻辑:
<?choose:?>
<?when://BATCH_SOURCE_NAME='FreightMaster'?><?CT_REFERENCE?><?end when?>
<?when://BATCH_SOURCE_NAME='FreightMaster-deactivated'?><?CT_REFERENCE?><?end when?>
<?when://BATCH_SOURCE_NAME='FM Source Number'?><?CT_REFERENCE?><?end when?>
<?otherwise:?><?INVOICE_NUMber?><?end otherwise?>
<?end choose?>
但是,我的数据不能正确显示。显示为:
Invoice Number
-----------------
<null>
454162
455920
应该如下所示:
Invoice Number
-----------------
20005
454162
455920
当我尝试将MIGRATION
定义为选项时,它会起作用:
<?choose:?>
<?when://BATCH_SOURCE_NAME='MIGRATION'?><?INVOICE_NUMber?><?end when?>
<?when://BATCH_SOURCE_NAME='FreightMaster'?><?CT_REFERENCE?><?end when?>
<?when://BATCH_SOURCE_NAME='FreightMaster-deactivated'?><?CT_REFERENCE?><?end when?>
<?when://BATCH_SOURCE_NAME='FM Source Number'?><?CT_REFERENCE?><?end when?>
<?otherwise:?><?INVOICE_NUMber?><?end otherwise?>
<?end choose?>
实际输出与预期输出匹配:
Invoice Number
-----------------
20005
454162
455920
我知道我可以在WHEN
子句中指定源名称,但是有20多个源名称,我想简化代码。
知道为什么它不起作用吗?