BAQ Dropdown

Kinetic ERP
1

I have Multi dropdown first one get the data from BAQ with non epicor tables.
The first dropdown get data from this BAQ :

select 
	[Epicor_Lookup_Insurance_Vendor_View].[VendorNum] as [Epicor_Lookup_Insurance_Vendor_View_VendorNum],
	[Epicor_Lookup_Insurance_Vendor_View].[Name] as [Epicor_Lookup_Insurance_Vendor_View_Name]
from dev.Epicor_Lookup_Insurance_Vendor_View as Epicor_Lookup_Insurance_Vendor_View

and it bind on OrderHed : OrderHed.VendorNum_c
and this is the BAQ of this dropdown:
BAQ Query : InsVendor
TextField : Epicor_Lookup_Insurance_Vendor_View_Name
ValueField : Epicor_Lookup_Insurance_Vendor_View_VendorNum

And the other dropdown get data from this BAQ:

select 
	[Epicor_Insurance_Types_View].[Id] as [Epicor_Insurance_Types_View_Id],
	[Epicor_Insurance_Types_View].[Insurance_Category_Desc] as [Epicor_Insurance_Types_View_Insurance_Category_Desc],
	[Epicor_Insurance_Types_View].[Insurance_Companies_ID] as [Epicor_Insurance_Types_View_Insurance_Companies_ID]
from dev.Epicor_Insurance_Types_View as Epicor_Insurance_Types_View
inner join dev.Epicor_Lookup_Insurance_Vendor_View as Epicor_Lookup_Insurance_Vendor_View on 
	Epicor_Insurance_Types_View.Insurance_Companies_ID = Epicor_Lookup_Insurance_Vendor_View.VendorNum

and it bind on OrderHed also: OrderHed.Insurance_Types_ID_c

and this is the BAQ of this dropdown:

BAQ Query : InsTypeForCom
TextField : Epicor_Insurance_Types_View_Insurance_Category_Desc
ValueField : Epicor_Insurance_Types_View_Id

I need to filter the second dropdown with VendorNum equal to Companies_ID after choosing from the first dropdown.
So i have tried to filter it with RowFilter but it get all data not filtered.

There is a method to accomplish this??

2

Are you using Classic screens or Kinetic (App Studio)?

3

Kinetic App Studio.

4

If you look at the component reference in the help it shows how to do this. It’s funny because I have to go back and look at the instructions every single time. Not sure why it is so convoluted to do something so simple. And why the intellisense on the fields is just wrong.

5

I’ve found a solution. After adding the parameter for the second baq, the event on the first drop-down column changes, and the second drop-down in the reusable combo adds the view name for the second baq.