Hi!

I'am wonder if someone could help me with my problem.

I created an xactionm definition, to fetch a list of clients from jndi defined for a MySQL DB.
This action would be used for the ServiceAction to make the list available to 3rd party apps via SOAP.

Now what I'am trying to do is to create a filter, so the results can be filtered by zip, product type,...
I have successfully created the action to take a zip parameter and to query the data accordingly.

My problems is, when a zip number is not passed, the query should igonore this parameter and return all results.
This is what I can't define so it would work.

This is my current xaction definition:
HTML Code:
<?xml version="1.0" encoding="UTF-8"?>
<action-sequence>
  <inputs>
        <postnaStevilka type="string">
      <sources>
        <request>postna_stevilka</request>
      </sources>
      <default-value></default-value>
    </postnaStevilka>
  </inputs>
  <outputs>
    <content type="content">
      <destinations>
        <response>content</response>
      </destinations>
    </content>
        <rule-result type="result-set"/>
  </outputs>
  <resources>
    <report-definition>
      <solution-file>
        <location>SifrantKomitent.xml</location>
        <mime-type>text/xml</mime-type>
      </solution-file>
    </report-definition>
  </resources>
  <actions>
    <action-definition>
      <component-name>SecureFilterComponent</component-name>
      <component-definition>
        <selections>
          <postnaStevilka filter="none" style="text-box">
            <title>Select ZIP</title>
          </postnaStevilka>
        </selections>
      </component-definition>
      <action-type>Filter param</action-type>
      <action-inputs>
                <postnaStevilka type="string"/>
      </action-inputs>
    </action-definition>
    <action-definition>
            <action-inputs> 
        <postnaStevilka type="string"/>  
      </action-inputs>
      <component-name>SQLLookupRule</component-name>
      <component-definition>
        <jndi><![CDATA[Banka]]></jndi>
        <query><![CDATA[SELECT * FROM ko_obcani WHERE N_PTT=CAST({postnaStevilka} AS UNSIGNED)]]></query>
        <live><![CDATA[true]]></live>
      </component-definition>
      <action-outputs>
        <!--<query-result type="result-set" mapping="query_result"/>-->
                <query-results type="result-set" mapping="rule-result"/> 
      </action-outputs>
    </action-definition>
  </actions>
  <title>SifrantKomitent</title>
  <version>1</version>
  <documentation>
    <author>Report Designer</author>
    <description/>
    <icon>PentahoReporting.png</icon>
    <help>Choose Report Output Format.</help>
    <result-type>report</result-type>
  </documentation>
</action-sequence>
Thanks for any help!

Primoz