multi value fields using real time look up with quick fields

APPROVED ANSWER

replied on October 5, 2016 • Show version history

Is the lookup using a custom query to return data from multiple rows? If so, slide 18 of this presentation describes a strategy that makes this possible.

2 0

View 2 previous replies

replied on October 5, 2016

It was not using a custom query but not against using that

0 0

replied on October 5, 2016

Can you provide more details about the lookup configuration and the format of the results that you're currently getting?

0 0

replied on October 6, 2016

declare @Invoices varchar(8000)
select @Invoices = ''
select @Invoices = inv_num + ' ' + @Invoices from inv_hdr where inv_hdr.co_num = ?
select substring(@Invoices,1,7998) as ResultColumn

this is the query that we wrote using your example. we get the results all on one line when we use the sql query in sql manager

this is the result

as a sample there could be more invoice numbers or less invoice numbers

797542, 797395,

How do I tie the result into pattern match and what would the regular expression look like

0 0

replied on October 6, 2016

When I was using the table drop downs the test would say it affected two rows but Quick Fields would only populate the first result

0 0

replied on October 6, 2016 • Show version history

You can access your column from a Lookup Process using the token format %(Lookup Process Name_Column Name). Your Pattern Matching Process should then take everything that's not a delimiter (e.g. [^,\s]* if you don't want your spaces either) asking for All Matches (as a multi-value token).

0 0

Question

Question

multi value fields using real time look up with quick fields

Answer

Replies

Sign in to reply to this post.