source: code/Pentaho grafieken/simple_chart_line.xaction@ 7887

<?xml version="1.0" encoding="UTF-8"?>
<action-sequence> 
  <name>Simple Line Chart Example</name>
  <title>Simple Line Chart Example</title>
  <version>1</version>
  <logging-level>DEBUG</logging-level>
  <documentation> 
    <author>Jake Cornelius</author>  
    <description>This demonstrates generating a simple bar chart types using the OpenFlashChartComponent in an action sequence</description>  
    <icon/>  
    <help/>  
    <result-type/> 
  </documentation>

  <inputs> 
    <chart_width type="string"> 
      <sources> 
        <request>chart_width</request> 
      </sources>  
      <default-value><![CDATA[650]]></default-value> 
    </chart_width>  
    <chart_height type="string"> 
      <sources> 
        <request>chart_height</request> 
      </sources>  
      <default-value><![CDATA[400]]></default-value> 
    </chart_height> 
  </inputs>

  <outputs> 
    <image-tag type="string"/> 
  </outputs>

  <resources> 
    <!-- use this section to identify any files that the component needs to execute the report -->  
    <bar> 
      <solution-file> 
        <location>flash_linechart.xml</location>  
        <mime-type>text/xml</mime-type> 
      </solution-file> 
    </bar> 
  </resources>
  
  <actions> 
    <action-definition> 
      <component-name>SQLLookupRule</component-name>
      <action-type>Chart Data Query</action-type>
      <action-outputs> 
        <query-result type="result-set" mapping="query_result"/> 
      </action-outputs>
      <component-definition> 
        <live><![CDATA[true]]></live>  
        <connection><![CDATA[jdbc:mysql://127.0.0.1:3306/save_energy]]></connection>
        <query><![CDATA[
                
                SELECT TIME(tuples.start) AS time, tuples.value
                FROM tuples 
                INNER JOIN sensors ON tuples.sensorID=sensors.sensorID 
                WHERE (end IS NULL) AND (sensors.roomID=1) ORDER BY start limit 10
        
        ]]></query>
        <password><![CDATA[dennis]]></password>
        <user-id><![CDATA[root]]></user-id>
        <driver><![CDATA[com.mysql.jdbc.Driver]]></driver>
      </component-definition> 
    </action-definition>
  
    <action-definition> 
      <component-name>OpenFlashChartComponent</component-name>
      <action-type>Open Flash Chart</action-type>
      <action-inputs> 
        <chart-data type="string" mapping="query_result"/>  
        <width type="string" mapping="chart_width"/>  
        <height type="string" mapping="chart_height"/> 
      </action-inputs>
      <action-resources> 
        <chart-attributes type="resource" mapping="bar"/> 
      </action-resources>
      <action-outputs> 
        <image-tag type="string"/> 
      </action-outputs>
      <component-definition/> 
    </action-definition>
 
  </actions> 
</action-sequence>