Forms Builder dropdown value

bujji

Hi,

I have two dropdown values in eform, one is department and another is direct manager name.

so whenever  user selects the department name in first dropdown,based on this direct manager list should  populate.

Now i am using the datasource adaptor to retreive values from first dropdown to secondone.

I am using department_name as input parameter in my dql query for second dropdown.

It is showing error while executing the form. below is my query###########################

Ex: 

select distinct(direct_manager) from dm_dbo.kac_wf_approvers_tbl where department_name='${department_name}';





please share your suggestion

aflowers001

could it be

select distinct(direct_manager) as direct_manage

which is not direct_manager

Miller-zzMST

Hi!

First, please post the error message.

Second, please make sure you got only one value in the first query.

bujji

Hi,

Below is the query where i am fetching direct and sector manager names based on department name.

sector manager name is displaying but direct manager name is not displaying and showing the error

Error executing adaptor. Please check the adaptor setup and requirements. [No value for xpath: instance('instanceOfmodel2')/./Group/direct_manager]

adaptor configuration details.

class name:idocbase data source adaptor

input parameter: dql

query :select distinct(direct_manager) as direct_manage,sector_manager from dm_dbo.kac_wf_approvers_tbl where department_name='${department_name}';

input:department_name

output type: output_type-->group-->direct_manager,sector_manager(added two items)

And also let me know when to apply adaptor in special and data & storage tab?

aflowers001

could it be

select distinct(direct_manager) as direct_manage

which is not direct_manager

Miller-zzMST

Agree with Andy.

bujji

Thanks Andy and konstantin!!!

Now its displaying the results in the text filed.

I have applied same adaptor to dropdown,results are coming but i have to select manually from the list.

By default it is showing blank.How can i show the results directly in dropdown when i select department name.

Please suggest what will be the problem?

Miller-zzMST

Sorry for late answer.

bujji wrote:And also let me know when to apply adaptor in special and data & storage tab?

Adaptor configured on 'Data & storage' tab will provides the possible values for the control. Adaptor on 'Special' tab will fill the data attribute with some value.

bujji wrote:By default it is showing blank.How can i show the results directly in dropdown when i select department name.

To select some value configure adaptor on 'Special' tab and there are must be suitable input parameters to select some value form possible.

BTW,

if you find Andy's answer helpful please mark it

bujji

I have configured adaptor  (special and data & storage when input value changes ) for direct manager dropdown list.

Now results are displaying directly in dropdown when i select the department name. Any impact will be there when i apply same adaptor in two tabs please let me know?

Miller-zzMST

I am not sure for 100% nut IMHO it will increase the load in 2 times. But I don't think there is any alternative. Just make sure your adaptor is optimized.