Nathan；

 

開發人員於Event Ruels中加入指定的［資料選擇］(Set User Selection)，
發現無法跟報表上設定的［資料選擇］無法一起生效，
只要套用到開發人員指定的篩選條件。

原因是少了下述這行：
　Set Selection Append flag (Yes)

只要加入之後，報表的篩選條件為：［報表上的資料選擇 + 開發人員設定的資料選擇］。

 

參考文章：

How Event Rule Dataselection Works in JDE Tools
http://www.jdesource.com/enterpriseone/how-event-rule-dataselection-works-in-jde-tools/

引用文章：
Scenario 2
Now, if the UBE already has an External Data selection of DCTO=’SI’,’SO’ our earlier data selection of DRQJ (in processing options) between 7/1/2011 and 7/31/2011.

Set Selection Append flag (Yes)
Set Selection (BC Date - Requested (DRQJ),,'07/01/2011',)
Set Selection (BC Date - Requested (DRQJ),<Less Than and Equal To>,'07/31/2011',<AND>)

Generated SQL  –
SELECT * FROM F4201 WHERE (DCTO IN ('SI','SO')) AND (DRQJ>='07/01/2011' AND DRQJ<='07/31/2011')

Explanation –
The Selection Append Flag specifies if to append the extra data selection after the External Data selection of the UBE. If this is set to NO, only the data select statements after that is applied.