1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
<?xml version="1.0" encoding="UTF-8"?>
<action-sequence>
<title/>
<version>1</version>
<logging-level>ERROR</logging-level>
<documentation>
<author/>
<description>Empty blank action sequence document</description>
<help/>
<icon/>
</documentation>
<inputs>
<TERRITORY type="string">
<sources>
<request>TERRITORY</request>
</sources>
<default-value>NA</default-value>
</TERRITORY>
<PRODUCTLINE type="string">
<sources>
<request>PRODUCTLINE</request>
</sources>
<default-value>NULL</default-value>
</PRODUCTLINE>
</inputs>
<outputs>
<swresult type="result-set"/>
</outputs>
<resources/>
<actions>
<actions>
<condition><![CDATA[PRODUCTLINE != "NULL"]]></condition>
<action-definition>
<component-name>SQLLookupRule</component-name>
<action-type>SQL Query</action-type>
<action-inputs>
<territory type="string"/>
<productline type="string"/>
<PRODUCTLINE type="string"/>
<TERRITORY type="string"/>
</action-inputs>
<action-outputs>
<query-result type="result-set" mapping="swresult"/>
</action-outputs>
<component-definition>
<jndi>SampleData</jndi>
<query><![CDATA[SELECT CONCAT(CONCAT( YEAR(ORDERS.ORDERDATE),'-' ),MONTH(ORDERS.ORDERDATE)) AS TIME, SUM(ORDERDETAILS.QUANTITYORDERED*ORDERDETAILS.PRICEEACH) SOLD_PRICE
FROM ORDERS
INNER JOIN ORDERDETAILS ON ORDERS.ORDERNUMBER = ORDERDETAILS.ORDERNUMBER
INNER JOIN PRODUCTS ON ORDERDETAILS.PRODUCTCODE =PRODUCTS.PRODUCTCODE
INNER JOIN CUSTOMERS ON ORDERS.CUSTOMERNUMBER =CUSTOMERS.CUSTOMERNUMBER
INNER JOIN EMPLOYEES ON CUSTOMERS.SALESREPEMPLOYEENUMBER = EMPLOYEES.EMPLOYEENUMBER
INNER JOIN OFFICES ON EMPLOYEES.OFFICECODE=OFFICES.OFFICECODE
WHERE PRODUCTS.PRODUCTLINE={PREPARE:PRODUCTLINE} AND OFFICES.TERRITORY={PREPARE:TERRITORY}
GROUP BY
CONCAT( MONTH(ORDERS.ORDERDATE), YEAR(ORDERS.ORDERDATE))]]></query>
</component-definition>
</action-definition>
</actions>
<actions>
<condition><![CDATA[PRODUCTLINE == "NULL"]]></condition>
<action-definition>
<component-name>SQLLookupRule</component-name>
<action-type>SQL Query</action-type>
<action-inputs>
<TERRITORY type="string"/>
</action-inputs>
<action-outputs>
<query-result type="result-set" mapping="swresult"/>
</action-outputs>
<component-definition>
<jndi>SampleData</jndi>
<query><![CDATA[SELECT CONCAT(CONCAT( YEAR(ORDERS.ORDERDATE),'-' ),MONTH(ORDERS.ORDERDATE)) AS TIME, SUM(ORDERDETAILS.QUANTITYORDERED*ORDERDETAILS.PRICEEACH) SOLD_PRICE
FROM ORDERS
INNER JOIN ORDERDETAILS ON ORDERS.ORDERNUMBER = ORDERDETAILS.ORDERNUMBER
INNER JOIN PRODUCTS ON ORDERDETAILS.PRODUCTCODE =PRODUCTS.PRODUCTCODE
INNER JOIN CUSTOMERS ON ORDERS.CUSTOMERNUMBER =CUSTOMERS.CUSTOMERNUMBER
INNER JOIN EMPLOYEES ON CUSTOMERS.SALESREPEMPLOYEENUMBER = EMPLOYEES.EMPLOYEENUMBER
INNER JOIN OFFICES ON EMPLOYEES.OFFICECODE=OFFICES.OFFICECODE
WHERE OFFICE.TERRITORY='{TERRITORY}'
GROUP BY
CONCAT( MONTH(ORDERS.ORDERDATE), YEAR(ORDERS.ORDERDATE))]]></query>
</component-definition>
</action-definition>
</actions>
</actions>
</action-sequence>