Data Entry Form in Kinetic - Kinetic ERP - Epicor User Help Forum (epiusers.help)
I went back to this post to figure out how to use Kinetic BAQ combo boxes where the filter value comes from a user text box. According to the post I had worked with some friendly folks and got it nearly working. I am back at this again, and lost all my previous work. I am at the very first step where I need to take the PartNum from txtPartNum, and use that to filter my BAQ that lists the part revisions. That BAQ is supposed to populate the revision combo box to allow the user to choose a revision for the part number they entered.
I have a BAQ called getPartRevs. It is super simple, just returning every revision.
select
[PartRev].[RevisionNum] as [PartRev_RevisionNum],
[PartRev].[RevShortDesc] as [PartRev_RevShortDesc]
from Erp.PartRev as [PartRev]
I created a dashboard with a blank tracker view in Kinetic. To that I added a text box for part number and a combo box for revision. Here is the setup: (I have tried this with and without the TransVeiw EpBindings.)
erp-text-box ID: txtPartNum
EpBinding: TransView.txtPartNum
erp-combo-xo ID: cmbRev
EpBinding: TransView.cmbRev
Reusable Combo > Hidden Columns Append: PartRev_PartNum
Reusable Combo > Filters: PartRev_PartNum=‘?{PartNumCol}’
Reusable Combo > Filters Params: PartNumCol=?[txtPartNum]
Advanced > BAQ Query: getPartRevs
Advanced > Text Field (and Value Field): PartRev_RevShortDesc
Advanced > Columns > Added PartRev_RevShortDesc, and PartRev_PartNum
When I run this in preview mode, and use F12 for dev tools, Ctrl + Alt + 8 for logging, and Ctrl + Alt + V to peek the dataviews, I can see that TransView.txtPartNum has my part number in it. But the combo box never populates with anything. In the response for ExecuteByID I get the error text, bad SQL statement. My BAQ runs fine wide open, returning all the revs.
I think that the filtering is supposed to be done by these lines:
Reusable Combo > Filters: PartRev_PartNum=‘?{PartNumCol}’
Reusable Combo > Filters Params: PartNumCol=?[txtPartNum]
But it seems like my parameter is not being applied to the BAQ properly. It is hard to tell what the SQL server error is. I can’t review server logs on cloud.
Questions:
Should my BAQ getPartRev contain any parameters? I have gone back and forth with this.
If a BAQ does have parameters, how do I populate them from user supplied values, like from text boxes or combo boxes?
@hmwillett I hate dataviews. You always confuse and complicate things with dataviews. Can I do this without messing with dvs?
I was on the right path in the last thread, but I can’t reproduce it now. I wonder if something has changed in the years since.
