RE: [dbforms] Problem with filter tag

Giannandrea Castaldi Mon, 20 Sep 2004 06:46:34 -0700

Title: RE: [dbforms] Problem with filter tag

Hi,
I'm using dbform 2.3 (20040329), below there is the log when I try to set my filter selecting the number 27720203529. In the log there is this line:

64047 [http8080-Processor3] INFO taglib.QueryData - about to execute user defined query:select distinct MOBILE_DESTINATION as n1, MOBILE_DESTINATION as n2 from CC_MESSAGE

but there is no trace of the number I have selected. This is my current filter:

<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>

Thanks for the help.

Giannandrea

***************** LOG *****************
63875 [http8080-Processor3] INFO event.EventEngine - ::getImageButtonAction - action = ""> 63875 [http8080-Processor3] INFO eventtype.DbFormsEventTypeStrategy - ::getEventGroup - using [DatabaseEventTypeStrategy] strategy
63891 [http8080-Processor3] INFO eventtype.DbFormsEventTypeStrategy - ::getEventGroup - using [NavigationEventTypeStrategy] strategy
63891 [http8080-Processor3] INFO event.EventEngine - ::generatePrimaryEvent - generating a navigation event
63891 [http8080-Processor3] INFO eventtype.DbFormsEventTypeStrategy - ::getEventType - using [DatabaseEventTypeStrategy] strategy
63891 [http8080-Processor3] INFO eventtype.DbFormsEventTypeStrategy - ::getEventType - using [NavigationEventTypeStrategy] strategy
63891 [http8080-Processor3] INFO eventtype.DbFormsEventTypeStrategy - ::getEventType - returned the event type [navReload] from [ac_reload_0_11]
63891 [http8080-Processor3] INFO event.EventFactory - ::getEventIdFromDestinationTable - eventId = [navReload]
63891 [http8080-Processor3] INFO event.EventFactory - ::createEvent - got event [event: id = navReload; type = navReload; className = org.dbforms.event.datalist.ReloadEvent] from action [ac_reload_0_11]
63891 [http8080-Processor3] INFO event.EventEngine - setting follow up to:/MESSAGE_list.jsp
63891 [http8080-Processor3] INFO event.EventEngine - setting follow up on Error to:/MESSAGE_list.jsp
*** e = [EMAIL PROTECTED]
*** e.getFollowUp() = /MESSAGE_list.jsp
63906 [http8080-Processor3] INFO taglib.DbFormTag - servlet path = /MESSAGE_list.jsp
63906 [http8080-Processor3] INFO taglib.DbFormTag - servlet getPathInfo = null
63906 [http8080-Processor3] INFO taglib.DbFormTag - servlet getContextPath = /zero9-cc
63906 [http8080-Processor3] INFO taglib.DbFormTag - resetting values of tag
63906 [http8080-Processor3] INFO taglib.DbFormTag - !comparing page /zero9-cc/MESSAGE_list.jsp TO /zero9-cc/MESSAGE_list.jsp
63906 [http8080-Processor3] INFO config.Table - token = REQUEST_DATE desc
63906 [http8080-Processor3] INFO config.Table - Field 'REQUEST_DATE' is ordered in mode:1
63906 [http8080-Processor3] INFO config.Table - token = TRANSACTION_ID desc
63922 [http8080-Processor3] INFO config.Table - Field 'TRANSACTION_ID' is ordered in mode:1
63937 [http8080-Processor3] INFO taglib.DbFormTag - using OverrulingOrder (dbform tag attribute)
63937 [http8080-Processor3] INFO taglib.DbFormTag - firstposition 0:4:1326-3:21:2004-09-05 10:32:05.0-4:2:MT
63937 [http8080-Processor3] INFO taglib.DbFormTag - lastPosition 0:4:1307-3:21:2004-09-04 16:26:46.0-4:2:MO
63937 [http8080-Processor3] INFO taglib.DbFormTag - §§§ NAV/I §§§
63937 [http8080-Processor3] INFO taglib.DbFormTag - about to process nav event:org.dbforms.event.datalist.ReloadEvent
63937 [http8080-Processor3] INFO datalist.ReloadEvent - ==>NavCurrentEvent.processEvent
64047 [http8080-Processor3] INFO taglib.EmbeddedData - generating Embeddeddata q1
64047 [http8080-Processor3] INFO taglib.QueryData - about to execute user defined query:select distinct MOBILE_DESTINATION as n1, MOBILE_DESTINATION as n2 from CC_MESSAGE
64109 [http8080-Processor3] INFO taglib.DbFooterTag - we are talking about=CC_MESSAGE
64109 [http8080-Processor3] INFO taglib.DbFooterTag - pcount=20
64109 [http8080-Processor3] INFO taglib.DbFooterTag - pcurrent=1
64109 [http8080-Processor3] INFO taglib.DbFooterTag - we are talking about=CC_MESSAGE
64109 [http8080-Processor3] INFO taglib.DbFooterTag - pcount=20
64109 [http8080-Processor3] INFO taglib.DbFooterTag - pcurrent=2
64125 [http8080-Processor3] INFO taglib.DbFooterTag - we are talking about=CC_MESSAGE
64125 [http8080-Processor3] INFO taglib.DbFooterTag - pcount=20
64125 [http8080-Processor3] INFO taglib.DbFooterTag - pcurrent=3
64141 [http8080-Processor3] INFO taglib.DbFooterTag - we are talking about=CC_MESSAGE
64141 [http8080-Processor3] INFO taglib.DbFooterTag - pcount=20
64141 [http8080-Processor3] INFO taglib.DbFooterTag - pcurrent=4
64141 [http8080-Processor3] INFO taglib.DbFooterTag - we are talking about=CC_MESSAGE
64156 [http8080-Processor3] INFO taglib.DbFooterTag - pcount=20
64156 [http8080-Processor3] INFO taglib.DbFooterTag - pcurrent=5
64187 [http8080-Processor3] INFO taglib.DbFooterTag - we are talking about=CC_MESSAGE
64203 [http8080-Processor3] INFO taglib.DbFooterTag - pcount=20
64203 [http8080-Processor3] INFO taglib.DbFooterTag - pcurrent=6
64203 [http8080-Processor3] INFO taglib.DbFooterTag - we are talking about=CC_MESSAGE
64203 [http8080-Processor3] INFO taglib.DbFooterTag - pcount=20
64203 [http8080-Processor3] INFO taglib.DbFooterTag - pcurrent=7
64219 [http8080-Processor3] INFO taglib.DbFooterTag - we are talking about=CC_MESSAGE
64219 [http8080-Processor3] INFO taglib.DbFooterTag - pcount=20
64234 [http8080-Processor3] INFO taglib.DbFooterTag - pcurrent=8
64234 [http8080-Processor3] INFO taglib.DbFooterTag - we are talking about=CC_MESSAGE
64234 [http8080-Processor3] INFO taglib.DbFooterTag - pcount=20
64234 [http8080-Processor3] INFO taglib.DbFooterTag - pcurrent=9
64234 [http8080-Processor3] INFO taglib.DbFooterTag - we are talking about=CC_MESSAGE
64234 [http8080-Processor3] INFO taglib.DbFooterTag - pcount=20
64234 [http8080-Processor3] INFO taglib.DbFooterTag - pcurrent=10
64250 [http8080-Processor3] INFO taglib.DbFooterTag - we are talking about=CC_MESSAGE
64250 [http8080-Processor3] INFO taglib.DbFooterTag - pcount=20
64250 [http8080-Processor3] INFO taglib.DbFooterTag - pcurrent=11
64266 [http8080-Processor3] INFO taglib.DbFooterTag - we are talking about=CC_MESSAGE
64266 [http8080-Processor3] INFO taglib.DbFooterTag - pcount=20
64266 [http8080-Processor3] INFO taglib.DbFooterTag - pcurrent=12
64266 [http8080-Processor3] INFO taglib.DbFooterTag - we are talking about=CC_MESSAGE
64266 [http8080-Processor3] INFO taglib.DbFooterTag - pcount=20
64266 [http8080-Processor3] INFO taglib.DbFooterTag - pcurrent=13
64312 [http8080-Processor3] INFO taglib.DbFooterTag - we are talking about=CC_MESSAGE
64312 [http8080-Processor3] INFO taglib.DbFooterTag - pcount=20
64312 [http8080-Processor3] INFO taglib.DbFooterTag - pcurrent=14
64312 [http8080-Processor3] INFO taglib.DbFooterTag - we are talking about=CC_MESSAGE
64312 [http8080-Processor3] INFO taglib.DbFooterTag - pcount=20
64312 [http8080-Processor3] INFO taglib.DbFooterTag - pcurrent=15
64344 [http8080-Processor3] INFO taglib.DbFooterTag - we are talking about=CC_MESSAGE
64344 [http8080-Processor3] INFO taglib.DbFooterTag - pcount=20
64344 [http8080-Processor3] INFO taglib.DbFooterTag - pcurrent=16
64344 [http8080-Processor3] INFO taglib.DbFooterTag - we are talking about=CC_MESSAGE
64344 [http8080-Processor3] INFO taglib.DbFooterTag - pcount=20
64344 [http8080-Processor3] INFO taglib.DbFooterTag - pcurrent=17
64359 [http8080-Processor3] INFO taglib.DbFooterTag - we are talking about=CC_MESSAGE
64359 [http8080-Processor3] INFO taglib.DbFooterTag - pcount=20
64359 [http8080-Processor3] INFO taglib.DbFooterTag - pcurrent=18
64375 [http8080-Processor3] INFO taglib.DbFooterTag - we are talking about=CC_MESSAGE
64375 [http8080-Processor3] INFO taglib.DbFooterTag - pcount=20
64375 [http8080-Processor3] INFO taglib.DbFooterTag - pcurrent=19
64375 [http8080-Processor3] INFO taglib.DbFooterTag - we are talking about=CC_MESSAGE
64375 [http8080-Processor3] INFO taglib.DbFooterTag - pcount=20
64375 [http8080-Processor3] INFO taglib.DbFooterTag - pcurrent=20
64375 [http8080-Processor3] INFO taglib.DbFooterTag - setting footerreached to true
64375 [http8080-Processor3] INFO taglib.DbFormTag - end reached of CC_MESSAGE
64375 [http8080-Processor3] INFO taglib.DbFormTag - doFinally called

-----Original Message-----
From: [EMAIL PROTECTED] on behalf of Henner Kollmann
Sent: Mon 9/20/2004 1:48 PM
To: Giannandrea Castaldi
Cc: [EMAIL PROTECTED]
Subject: AW: [dbforms] Problem with filter tag

Could you give us a little bit more information what's not working? e.g. the generated sql query? Some logging output?

Which version do you use?

Thanks
Henner Kollmann

-----Ursprüngliche Nachricht-----
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Im Auftrag von Giannandrea
Castaldi
Gesendet: Montag, 20. September 2004 10:59
An: [EMAIL PROTECTED]
Betreff: [dbforms] Problem with filter tag

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="<< First" />
<db:navPrevButton caption="< Previous" />
<db:navNextButton caption="Next >" />
<db:navLastButton caption="Last >>" />
</center>
</db:footer>
</db:hasRecords>
</db:dbform>
</body>
</html>

RE: [dbforms] Problem with filter tag

Reply via email to