Hi,
I am using Forms Builder 6.6.I want to create a search form with two drop-down list.
According to the input value of dropdown listbox1,I want to populate the values in the drop down listbox2
using the inbuilt data source adaptor.
The steps I followed are to configure this are:
Adaptor 1
With the form open ,selected File>Adaptors>Template adaptors>add new adaptor.
Name:Documenttype Adaptor
Adaptor Type :Data Source.
Class Name:datasource.docbase.IDocbaseDataSourceAdaptorService
Type:SBO
Initial Parameter:dql
Value:select DISTINCT(documenttype) from testadaptor
Note:testadaptor is the object type,and custom attributes are documenttype and process.
Output type>Output_Type>
Name:Output_type
Add Group>
Name:row
Add item>
Name:documenttype
Type:String
Click OK.
Adaptor 2
With the form open ,selected File>Adaptors>Template adaptors>add new adaptor.
Name:Process Adaptor
Adaptor Type :Data Source.
Class Name:datasource.docbase.IDocbaseDataSourceAdaptorService
Type:SBO
Initial Parameter:dql
Value: Select DISTINCT(process) from testadaptor where documenttype='${documenttype}'
Input:documenttype
Output type>Output_Type>
Name:process_List
Add Group>
Name:row
Add item>
Name:Process
Type:String
Click OK.
Now in the Forms template>
The dropdownlist1 data binding:/FormName/documenttype
In data and storage tab>
Data Name:documenttype
External Data source: .Documenttype Adaptor
Possible Value List Selection
Row Selection:/Output_Type/row
Value:/Output_Type/row/documenttype
Display:/Output_Type/row/documenttype
Similarly for the dropdownlist2
The dropdownlist1 data binding:/FormName/documenttype
In data and storage tab>
Data Name:process
External Data source: .Documenttype Adaptor
Possible Value List Selection
Row Selection:/process_List/row
Value:/process_List/row/process
Display:/process_List/row/process
The form gets validated,and i installed it.
But when I add the form to a Tab,a blank screen appears.
Actually when I use the dropdownlist1 with the associated adaptor ,I am able to install the adaptor and assign to the tab in taskspace correctly.
Can you direct where I went wrong in configuring the dropwonlist2 and adaptor2 ?
Thanks in Advance
Sneha
