Hello Team,
I am working on Kinetic 2023.2. I added a combobox and link to baq. but i need pass ordernum to the baq. i tried put condition OrderHed.OrderNum=‘?{OrderHed.OrderNum}’ in the filter, filter params, row filter. nothing working.
for filter, it returns Bad sql statement when I open developer console in F12.
so, anyone can help me on that.
thanks,
Lucy
in the second part, what dataview is actually in your form?
Hello Klincecum,
dataview is orderhed in the order entry.
thanks,
Lucy
look like only grid can do that. i made a dataview and bind with the baq with filter and it works in grid. but it looks weird. in kinetic 2023, the combo box only can support static list or the list from epicor native. it is very frustrate
Cheers,
Lucy
You should be able to use Filters or Filters Append… both work for me.
These are the ONLY settings I use in this particular ComboBox:
For Filters / Filters Append… set yours to OrderHed_OrderNum = '?{OrderNum}'
OrderHed_OrderNum should be the name/alias of the column used in your BAQ.
NOTE: The right side of the expression needs square brackets.
The combobox needs to be bound to the same dataview the value is coming from. So, if you’re using OrderHed.OrderNum, make sure your combobox is bound to OrderHed.MyCombo (or whatever you want to call it). That’s where the combobox gets the dataview to use… and then it looks for the [OrderNum] column.
Hi again,
thanks so much for the reply. i am using 2023.2 and even though i put exactly Filters or Filters Append, i still get Bad SQL Statement.
Thanks a lot.
Lucy
you have brackets […] instead of braces {…}
Thanks klincecum. i used curly braces { } in either Filters or Filters Append, neither of them worked. they have same results as before.
Lucy
Can you show that my approach above didn’t work.
@klincecum edited my post and changed it to curly braces, but that didn’t work for me:
Using Curly Braces:
Preview
Using Square brackets and only referencing the column… DON’T Include the dataview.
Preview:
Now… that all being said, you’re getting a Bad SQL statement error. Even when my combo wasn’t populating (when I used curly braces) I didn’t have a Bad SQL statement error. So, there could be something else going on. If the square brackets don’t work, I would chase down the CorrelationID in the server logs and see if it provides any additional details.
Sorry, I was half asleep.
Thanks guys so much for all your help 
i finally have to use view pointing to BAQ. in the Reusable Combo, Type DataView and put in View Name. No filters Append or Params. In the Advanced, put TextFiled, Value Field with the name of the display field from the view, and finally works 
Really appreciate 
Lucy
