Hi list,
I have a following definition in my dbforms-config.xml:
<query name="documents"
from="HC_DOCUMENT, HC_DOCUMENT_TO_CATEGORY"
where="HC_DOCUMENT.ID = HC_DOCUMENT_TO_CATEGORY.DOCUMENT_ID" >
<field name="ID" fieldType="number" expression="HC_DOCUMENT.ID"/>
<field name="TITLE" fieldType="varchar2" expression="HC_DOCUMENT.TITLE"/>
<search name="CATEGORY_ID" fieldType="number" isKey="true" expression="HC_DOCUMENT_TO_CATEGORY.CATEGORY_ID"/>
</query>
I would like to use gotoPrefix in order to filter rows with given CATEGORY_ID:
<db:dbform autoUpdate="false" followUp="/documents_list.jsp" maxRows="10" tableName="documents" gotoPrefix="fv_">
However, accessing /documents_list.jsp?fv_CATEGORY_ID=123 does not change the query:
80059430 [http-8080-Processor3] DEBUG org.dbforms.taglib.DbFormTag - fieldName=CATEGORY_ID
80059430 [http-8080-Processor3] DEBUG org.dbforms.taglib.DbFormTag - fieldValue=123
...
80059470 [http-8080-Processor3] INFO org.dbforms.config.Query - doSelect:SELECT HC_DOCUMENT.ID ID, HC_DOCUMENT.TITLE TITLE FROM HC_DOCUMENT, HC_DOCUMENT_TO_CATEGORY WHERE ( HC_DOCUMENT.ID = HC_DOCUMENT_TO_CATEGORY.DOCUMENT_ID )
What am I doing wrong? Are there some other ways to get the expected behaviour?
regards, Dziugas Baltrunas
------------------------------------------------------- This SF.Net email is sponsored by OSTG. Have you noticed the changes on Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now, one more big change to announce. We are now OSTG- Open Source Technology Group. Come see the changes on the new OSTG site. www.ostg.com _______________________________________________ DbForms Mailing List
http://www.wap-force.net/dbforms
