The preload is uhhhh preloaded with these values. I left them in place because they seem to match what I want. But the BAQ is clearly not being filtered by these values.
"PartNum='{InvTrans.PartNum}' AND WhseCode = '{InvTrans.ToWarehouseCode}' AND LotNumber = '{InvTrans.ToLotNumber}' AND DimCode = '{InvTrans.TransferQtyUOM}' AND AttributeSetID = {InvTrans.AttributeSetID}"
I believe you will need to change the columns to match the BAQ.
EG: PartNum becomes PartBin_PartNum (or whatever is in your BAQ).
Ah, you know what? This looks pretty similar to an issue I was having with the Quick Search. I couldnāt get it to load the filters. 
I have updated my BAQ to the following:
select
[PartBin].[PartNum] as [PartBin_PartNum],
[PartBin].[BinNum] as [PartBin_BinNum],
[WhseBin].[Fullness_c] as [WhseBin_Fullness_c],
[PartBin].[OnhandQty] as [PartBin_OnhandQty],
[PartBin].[LotNum] as [PartBin_LotNum],
[PartBin].[WarehouseCode] as [PartBin_WarehouseCode]
from Erp.PartBin as PartBin
left outer join Erp.WhseBin as WhseBin on
WhseBin.Company = PartBin.Company
and WhseBin.WarehouseCode = PartBin.WarehouseCode
and WhseBin.BinNum = PartBin.BinNum
where (PartBin.OnhandQty is not null and PartBin.PartNum = @Part)
and (WhseBin.Fullness_c is not null)
I setup by BAQ with a parameter to filter the PartBin table.
I changed my BAQ Search Like field to PartBin_PartNum.
I set the search-show event Like field to PartBin.PartNum.
I removed all the JSON text from the PreLoad Search Filter.
I set my search type to BAQ and entered the name of my BAQ, BinList.
I separated my bin search to a unique button to not confuse it with clicking the search icon in the ToBin field.
This kind of works! The only problem with this approach is that I have to enter my part number twice. Once on the main Inventory Transfer Form. Then again for my BAQ parameter once I click the bin search button.
I played around with the Pre load filter field and nothing I typed in there ever made any difference to the returned BAQ results. So I just deleted it altogether.
Is there any other way to get Kinetic to pickup my part number and accept it as a BAQ parameter, without me having to type it in again?
Thanks!
Nate
I was trying to play with the same thing last night as well.
Itās been an issue for some time where you cannot pass data to a BAQ parameter.
Looks like they still have not done anything about it.
That is awesome!!! (Glad Iām on-prem!)
Can callContectBpmData be used for this somehow?
You can play with it, but I donāt think thereās any way to prevent that BAQ parameter screen from popping up regardless.
I have a working solution. Although it does not involve the search box like I wanted.
In this case I wanted to look at the Inventory Transfer screen, type in a part number, and see a list of all the bins that part is sitting in, as well as how full that bin is. The Fullness is a UD decimal field I added to WhseBin.
To get a working solution, I added a panel grid card to the Inventory Transfer screen. I put it right under the detail screen. I called the panel Bin Fullness. Under Grid Model, I entered my EP Binding as MyBinList (will make later).
My BAQ that lists all the bins and their respective fullness looks like this. Note I didnāt use any parameters.
select
[PartBin].[PartNum] as [PartBin_PartNum],
[PartBin].[BinNum] as [PartBin_BinNum],
[WhseBin].[Fullness_c] as [WhseBin_Fullness_c],
[PartBin].[OnhandQty] as [PartBin_OnhandQty],
[PartBin].[LotNum] as [PartBin_LotNum],
[PartBin].[WarehouseCode] as [PartBin_WarehouseCode],
(str(WhseBin.Fullness_c * 100) + '%') as [Calculated_RealFullness]
from Erp.PartBin as PartBin
left outer join Erp.WhseBin as WhseBin on
WhseBin.Company = PartBin.Company
and WhseBin.WarehouseCode = PartBin.WarehouseCode
and WhseBin.BinNum = PartBin.BinNum
where (PartBin.OnhandQty is not null)
and (WhseBin.Fullness_c is not null)
Next I created a data view called MyBinList. I set the server schema to BAQ and choose my BAQ called BinList. I also setup a parent child relationship with the parent being InvTrans. I linked on PartNum.
Finally I added an event to trigger loading the grid with my data. I created a new event after columnchanged_partNum. To this I added a ERP BAQ widget with the following settings. BAQID: BinList, ViewName: MyBinList, no BAQ options.
This seems to do the trick. Now, in Inventory Transfer, when I type in a part number and tab, the grid I added is populated with the list of bins that contain that part, as well as a value for the bins fullness. Now users can tell if they are transferring inventory into a bin that is already set to full, or choose another bin that is not full.
Let me know if you have any questions or suggestions about this approach.
I hope this helps someone! Thank you all for your input.
Nate
Hi @hmwillett , how can I create Quick Search use BAQ
and How can I put preload search filter in Appstudio use tool Search Show
Hi @hmwillett, I tried this but nothing happen. Is there any next step? I have already added the field and run the conversion 191. My current version 2021.20
