Epicor UD Field Custom Search

Hi , I am trying to add a Quick Search on a UD 25 Table. After adding the Quick Search, What I notice is that Quick Search Filters well with the parameters, however, the result set that loads in the Grid is based on the Return Column Field (for my case Key1).
For Example, Key1 = EmployeeID = 1 and there are 10 Transactions for 10 different dates for this EmployeeID. When Quick Search, I can filter out EmployeeID = 1 and for Date01 = 2022-08-01, however the result loads in the Grid are entire 10 rows.

Note: I would keep the standard list view grid, because of keeping the std. actions (Paste Insert etc) intact.

Please suggest …

You need to change the quick search to return the UD.SysRowID instead of key1

1 Like

At the risk of hijacking the thread:

I’ve not been able to make this work with a parent/child UD table:

The result is that the Kinetic form asks if this is a new record. It works in the Classic form. Reckon what I’m doing wrong?

Thanks,

Joe