You are viewing limited content. For full access, please sign in.

Question

Question

Retrieving duplicate rows using database lookup in Quick Fields

asked on May 6, 2015

Is it possible to retrieve duplicate rows during database lookup within Quick Fields and have it populate other fields with the all returned data?

 

Example:

 

Table:

001, A Group, A, Z

002, B Group, B, Y

003, C Group, C, X

004, AB Group, A, L

005, C Group, C, M

006, ABC Group, A, N

 

Laserfiche Fields:

 

Field 1 (Used to perform lookup):

A

 

Field 2 (Retrieved values from lookup table):

A Group

AB Group

ABC Group

 

Field 3 (Retrieved values from lookup table):

001

004

006

 

Field 4 (Retrieved values from lookup table):

Z

L

N

 

The customer wants to have an option where they can select the correct row of returned values from the loopup table. If we can provide a list of retrieved rows and the indexer can select correct row from the list.

 

Thanks!

0 0

Replies

replied on May 8, 2015

Quick Fields database lookup will just return the first hit. First, I would suggest that you pick a unique identifier that is not duplicated to ensure the correct values are returned.

 

If picking a different identifier is not an option, you can check out these links for potential workarounds:

  1. Check out this presentation from Empower 2012 on Advanced Quick Fields, specifically from slide 14 – on, to check out creating a custom query.
  2. Check out the Quick Fields Scripting White Paper to pop up messages to the user with scripting.  
1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.