[dbforms] Problem with filter tag

Mon, 20 Sep 2004 02:00:18 -0700

Hi all,
I'm trying to use the tag filter but it doesn't work. I've specified a filter of type select and the combo is correctly filled with phone numbers I want to use to apply the filter but when I set a number there are all the rows. The filter should select rows with the specified number, I'm using 'MOBILE_DESTINATION = ?'.
Any suggestions? Here below there is my jsp.
 
Thanks.
 
Giannandrea
 
 
<%@ taglib uri="/WEB-INF/dbforms.tld" prefix="db" %>
<% int i=0; %>
<html xmlns:db="http://www.wap-force.com/dbforms">
<head>
<db:base/>
<title>Customer Care Tool</title>
<link href="" rel="stylesheet"/>
</head>
<body class="clsPageBody">
<table align="center" border="0" width="100%" cellspacing="0" cellpadding="1" class="clsMainMenuTable">
 <tr>
  <td>
   <table border="0" width="100%" cellspacing="0" cellpadding="3" class="clsMainMenuTable">
    <tr class="clsMainMenuTableRow">
     <td align="center">
      <span class="clsMainMenu">Messaggi in ingresso e uscita</span>
     </td>
    </tr>
   </table>
  </td>
 </tr>
</table>
<db:dbform multipart="false" autoUpdate="false" followUp="/MESSAGE_list.jsp" maxRows="20" tableName="CC_MESSAGE"  orderBy="REQUEST_DATE desc, TRANSACTION_ID desc">
 <db:hasNoRecords message="<CENTER>Nessun messaggio trovato con questo numero</CENTER>"></db:hasNoRecords>
 <db:hasRecords>
  <db:header>
   <db:filter>
     <db:filterCondition label="msisdn">
    MOBILE_DESTINATION = ?
    <db:filterValue type="select">
             <db:queryData name="q1" query="select distinct MOBILE_DESTINATION as n1, MOBILE_DESTINATION as n2 from CC_MESSAGE"/>
           </db:filterValue>
     </db:filterCondition>
   </db:filter>
   <db:errors/> 
   
   <table id="transaction_list" align="center" >
   
   <tr class="clsHeaderDataTableRow">
    <td class="clsHeaderDataTableCell">ID</td>
    <td class="clsHeaderDataTableCell">CUSTOMER</td>
    <td class="clsHeaderDataTableCell">SERVICE</td>
    <td class="clsHeaderDataTableCell">REQUEST DATE</td>
    <td class="clsHeaderDataTableCell">MO/MT</td>
    <td class="clsHeaderDataTableCell">MOBILE DESTINATION</td>
    <td class="clsHeaderDataTableCell">OPERATOR</td>
    <td class="clsHeaderDataTableCell">REQUEST BODY</td>
    <td class="clsHeaderDataTableCell">TEXT</td>
    <td class="clsHeaderDataTableCell">CONTENT</td>
    <td class="clsHeaderDataTableCell">DELIVERY STATUS</td>
    <td class="clsHeaderDataTableCell">BILLING STATUS</td>
   </tr>
  </db:header>
  <db:body allowNew="false">
   <tr class="<%= (i++%2==0) ? "clsOddDataTableRow" : "clsEvenDataTableRow" %>">
    <td><%= currentRow_CC_MESSAGE.get("TRANSACTION_ID") %></td>
    <td><%= currentRow_CC_MESSAGE.get("CUSTOMER") %></td>
    <td><%= currentRow_CC_MESSAGE.get("SERVICE") %></td>
    <td><db:dateLabel fieldName="REQUEST_DATE" pattern="dd.MM.yyyy HH:mm:ss"/></td>
    <td><%= currentRow_CC_MESSAGE.get("MT_MO") %></td>
    <td><%= currentRow_CC_MESSAGE.get("MOBILE_DESTINATION") %></td>
    <td><%= currentRow_CC_MESSAGE.get("OPERATOR") %></td>
    <td><%= currentRow_CC_MESSAGE.get("REQUEST_BODY") %></td>
    <td><%= currentRow_CC_MESSAGE.get("TEXT") %></td>
    <td><%= currentRow_CC_MESSAGE.get("CONTENT") %></td>
    <td><%= currentRow_CC_MESSAGE.get("DELIVERY_STATUS") %></td>
    <td><%= currentRow_CC_MESSAGE.get("BILLING_STATUS") %></td>
   </tr>
  </db:body>
  <db:footer></table>    
 <center>
  <db:navFirstButton caption="&lt;&lt; First" />
  <db:navPrevButton caption="&lt; Previous" />
  <db:navNextButton caption="Next &gt;" />
  <db:navLastButton caption="Last &gt;&gt;" />
 </center>
  </db:footer>
 </db:hasRecords>
</db:dbform>
</body>
</html>
 
 
 

Reply via email to