[image] Let’s say on sales order entry I want to select a particular project + phase (if any). Display BAQ results Select 1 row Return both Project ID and Project Phase (or null in case of no phase) What would be the best way forward to select 1 row from a grid and return more than 1 field value…

This should help [image] Multi Field Bindings - Search-Value-Set Kinetic ERP Ooo, I got it! I was way off, lol. For anyone else looking for this: [image] [image] [image] Update for Quick/BAQ Searches The search-value-set widget does not seem to work w…

search-show does not return the required information. Because “Like” is set to Project.ProjectID the selected Project record is returned and not the content of the selected BAQ row. The BAQ is for display purposes only to select a particular Project record. [image] What I need is the content of t…

[image] PHNR: select 1 row from a grid and return more than 1 field value? Bind the grid to a dataview. Then you can use multiple fields as you please. BAQView.Field1 BAQView.Field2 etc.

How do I bind my search-show BAQ search type to a dataview? [image]

You have conflicting information here. You say: [image] PHNR: select 1 row from a grid and also [image] PHNR: bind my search-show BAQ Which is it?

I have a search-show that displays a BAQ search type grid from which I select one row as a search result.

Read through this. The thread is about a Quick Search, but the same principle applies to a BAQ search. Multi-Value Quick Search - Search-Value-Set - Kinetic 202X - Epicor User Help Forum (epiusers.help)

Read that thread, but does not bring a solution for this particular instance. There is no working “Like” for ProjectPhase. As the BAQ displays related data that cannot be connected to only the Project record there is no reliable lookup. If there would be a selected row indicator for ErpSearchResult…

[image] PHNR: If there would be a selected row indicator for ErpSearchResults that would solve it, but that does not exist as fas as I can see. Would be nice, wouldn’t it? @bconner why isn’t that a thing? We have to jump through tons of hoops to return selected values from Quick and BAQ sear…

Search-show multiple field result

Kinetic ERP

tkoch (TK) January 5, 2024, 12:52pm 2

This should help

Topic		Replies	Views
Multi-Value Quick Search - Search-Value-Set Kinetic ERP application-studio	10	3929	June 15, 2023
Search-value-set when using BAQ search type Kinetic ERP e10	17	9326	October 20, 2022
Using Search Results in Dialog Box Kinetic ERP application-studio	2	2505	July 18, 2023
Multi Field Bindings - Search-Value-Set Kinetic ERP application-studio	4	8115	April 16, 2026
Quick Search that Returns Two Values Epicor ERP 10 e10 , customization , baq	6	2251	June 30, 2021

Search-show multiple field result

Related topics