source: code/chartbeans_line.xaction

<?xml version="1.0" encoding="UTF-8"?>
<action-sequence>
  <name>Simple Line Chart Example</name>
  <title>Chartbeans Line Chart</title>
  <version>1</version>
  <logging-level>debug</logging-level>
  <documentation> 
    <author>Gretchen Moran</author>  
    <description/>  
    <help/>
  </documentation>

  <inputs>
    <series-column type="string">
      <sources>
        <request>series-column</request>
      </sources>
      <default-value>YEAR</default-value>
    </series-column>
    <category-column type="string">
      <sources>
        <request>category-column</request>
      </sources>
      <default-value>LINE</default-value>
    </category-column>
    <value-column type="string">
      <sources>
        <request>value-column</request>
      </sources>
      <default-value>PRICE</default-value>
    </value-column>
  </inputs>

  <outputs>
    <outputstream type="string"> 
      <destinations> 
        <response>content</response> 
      </destinations> 
    </outputstream> 
  </outputs>

  <resources> 
    <line> 
      <solution-file> 
        <location>chartbeans_linechart.xml</location>  
        <mime-type>text/xml</mime-type> 
      </solution-file> 
    </line>  
  </resources> 


  <actions> 

    <action-definition> 
      <component-name>SQLLookupRule</component-name>
      <action-type>New Chart Data Query</action-type>
      <action-outputs> 
        <query-result type="result-set" mapping="new_result"/> 
      </action-outputs>
      <component-definition> 
        <live><![CDATA[true]]></live>  
        <driver><![CDATA[com.mysql.jdbc.Driver]]></driver>
        <connection><![CDATA[jdbc:mysql://localhost:3306/database]]></connection>
        <user-id><![CDATA[username]]></user-id>
        <password><![CDATA[wachtwoord]]></password>
        <query><![CDATA[SELECT start AS LINE,
                                roomID AS "YEAR",
                        MAX(value) AS "PRICE"
                        FROM
                                dennis_test.tuples 
                                WHERE end IS NULL
                                GROUP BY LINE, YEAR
                                ORDER BY LINE ASC
                                LIMIT 50]]></query> 
      </component-definition> 
    </action-definition>

    
    <action-definition>
      <component-name>ChartBeansComponent</component-name>
      <action-inputs>
          <value-column type="string"/> 
          <category-column type="string"/> 
          <series-column type="string"/> 
          <chartdata type="result-set" mapping="new_result"/>
      </action-inputs>
      <action-resources> 
        <chart-model-xml type="resource" mapping="line"/>
      </action-resources>
      <action-outputs>
        <outputstream/>
      </action-outputs>
      <component-definition/> 
      <action-name>ChartBeans Line Chart</action-name>  
      <logging-level>DEBUG</logging-level> 
    </action-definition>

  </actions> 
</action-sequence>