<?xml version="1.0" encoding="UTF-8"?>
<action-sequence>
  <name>session-region-list.xaction</name>
  <title>%title</title>
  <version>1</version>
  <logging-level>debug</logging-level>
  <documentation>
    <author>Brandon Jackson</author>
    <description>%description</description>
    <help/>
  </documentation>

  <inputs>
    <user type="string">
      <sources>
        <session>name</session>
      </sources>
    </user>
    <REGION_list_msg type="string">
      <sources/>
      <default-value>REGION-list has been set.</default-value>
    </REGION_list_msg>
  </inputs>

  <outputs>
    <REGION_list_msg type="string">
      <destinations>
        <response>content</response>
      </destinations>
    </REGION_list_msg>
    <regions type="list">
      <destinations>
        <session>region_list</session>
        <session>REGION_FILTER</session>
      </destinations>
    </regions>
  </outputs>

  <resources/>

  <actions>
    <action-definition>
      <component-name>SQLLookupRule</component-name>
      <action-type>Relational</action-type>
      <action-inputs/>
      <action-outputs>
        <query-result type="result-set" mapping="region_list"/>
        <regions type="list"/>
      </action-outputs>
      <component-definition>
        <live><![CDATA[true]]></live>
        <query><![CDATA[SELECT region
FROM staging.adminlist
WHERE sAMAccountname = '<user>';]]></query>
        <driver><![CDATA[com.mysql.jdbc.Driver]]></driver>
        <connection><![CDATA[jdbc:mysql://172.27.0.204/staging]]></connection>
        <user-id><![CDATA[stonegate]]></user-id>
        <password><![CDATA[nah-jk]]></password>
      </component-definition>
    </action-definition>