Multi Field Bindings - Search-Value-Set

Kinetic ERP
1

I have a button wired up to show a search which works fine.
It also works fine when I wire the On Success/Search-Value-Set to a single binding.
I’m struggling to figure out how to set it to multiple bindings.
This is what I currently have:

image

image
image1644×727 46.7 KB

I’ve tried a number of different combinations of the data in the JSON editor including:

{
    "{UD34.RelQuote_c}" : "{actionResult.QuoteNum}",
    "{UD34.QuoteDueDate_c}" : "{actionResult.Date10}"
}

{
    "UD34.RelQuote_c" : "{actionResult.QuoteNum}",
    "UD34.QuoteDueDate_c" : "{actionResult.Date10}"
}

{
    "UD34.RelQuote_c" : "actionResult.QuoteNum",
    "UD34.QuoteDueDate_c" : "actionResult.Date10"
}

{
    "RelQuote_c" : "{actionResult.QuoteNum}",
    "QuoteDueDate_c" : "{actionResult.Date10}"
}

{
    "RelQuote_c" : "actionResult.QuoteNum",
    "QuoteDueDate_c" : "actionResult.Date10"
}

{
    "{UD34.RelQuote_c}" : "actionResult.QuoteNum",
    "{UD34.QuoteDueDate_c}" : "actionResult.Date10"
}

I’m sure there’s more combinations I’ve tried, but clearly it’s not working, lol.
Couldn’t find much in the documentation.

@Ishkaran, you’re my new best friend. :slight_smile: What am I missing?

2

One step closer.
I see the data coming back, but it’s not binding it to the field.

{
    "UD34.RelQuote_c" : "{searchResult.QuoteNum}",
    "UD34.QuoteDueDate_c" : "{searchResult.Date10}"
}

image
image905×146 7.3 KB

3

Ooo, I got it! I was way off, lol.
For anyone else looking for this:

image
image416×494 6.03 KB

image
image1264×782 37.2 KB

image
image1197×654 31.9 KB

Update for Quick/BAQ Searches

The search-value-set widget does not seem to work with Quick/BAQ searches. In these instances,
use a dataview-filter-set to filter ErpSearchResults (the full quick/baq result set) on the searchResult key value which is populated automatically by a GetList based on the selected value from the user, then use a row-update and set the value to be "{ErpSearchResults.BAQTable_BAQColumn}".

image
image1920×937 48.9 KB

image
image1920×937 40.1 KB

You will need to use a dataview-condition to loop through the results if you do a multi-select search.

4

Thanks. This worked for me updating a single field too.

9

Hi, I have the same requirement. I am updating UD34 Character01 data using the BAQ search result (JobMtl_Part). Could you please help me understand what I should include in the DataView filter?