RMX Sender RMX Server id name team email

RMX Sender RMX Server id name team email 1 遠山 wix toyama@ 2 北囿 wix zonop@ 3 佐藤 ssql sato@ Get addresses DB Server parameter Delivery Rule To : wix @group. rmx. keio. jp toyama@ Sending e-mail for wix team member Mail Server zonop@

RMX （How to get addresses? ） rmx. properties RMXサーバー To : wix@group. rmx. keio. jp year. Type = integer year[1] = SELECT s. email FROM student s WHERE s. year = $1 year[2] = SELECT s. email FROM student s WHERE $1 < s. year AND s. year < $2 group execute group. Type = String group[1] = SELECT s. email query FROM student s WHERE s. team = $1 To : aoyama@ To : ishizaki@ To : wake@ student id name team year email 1 aoyama wix 1987 aoyama@ 2 ishizaki wix 1987 ishizaki@ 3 wake wix 1988 wake@ 4 tomonari ssql 1988 tomonari@ 5 zonop speed 1988 zonop@ 4

New RMX１ Create a new mail Sender RMX Server id name grade club 1 鈴木 b 4 soccer 2 田中 b 4 baseball 3 佐藤 m 2 basketball Get Information DB Server 鈴木 parameter 田中 Answer Rule To : b 4 @gradetoname. rmx. keio. jp I want to know the name of the B 4 grade students. Mail Server

情報取得 rmx. properties RMXサーバー 配送ルール club. Type = String club[1] = SELECT email FROM student s 配送ルール WHERE s. club = $1 grade = transfer grade. Type = String grade[1] = SELECT s. email FROM student s 応答ルール WHERE s. grade = $1 情報取得先 gradetoname = answer gradetoname. Type = String gradetoname. Source = db クエリ gradetoname[1] = SELECT s. name 実行 FROM student s WHERE s. grade = $1 To : b 4 @gradetoname. rmx. keio. jp To : 送信者 鈴木 田中 student id name grade club 1 鈴木 b 4 サッカー 2 田中 b 4 野球 3 佐藤 m 2 バスケ 8

使用例 メール本文 member id name DBサーバー grade email 1 zonop 4 zonop@db. . . 2 sample 4 sample@. . . 3 AAA 5 AAA@. . . 4 BBB 6 BBB@. . . 9

情報取得 rmx. properties RMXサーバー club. Type = String club[1] = SELECT email FROM student s WHERE s. club = $1 grade = transfer grade. Type = String grade[1] = SELECT s. email FROM student s WHERE s. grade = $1 weather = answer weather. Type = String weather. Source = api weather[0] = Weather. jar To : tokyo@weather. rmx. keio. jp To : 送信者 ◆東京 天気：晴れ 気温： 27℃ 情報取得plugin 「Weather. jar」 ・APIへ接続 ・メール本文作成 12

ディレクトリ構成 env. properties RMX config subdomain 1. properties domconf subdomain 2. properties ・・ src Weather. jar Gnavi. jar plugins ・・ 14

• LWWS demo 15