Two DISPLAY FIELDS in AUTOCOMPLETE box

Permanently deleted user

June 17, 2014 22:22

We have a rest service exposing 250,000 records.  We have configured an autocompletebox with users able to search on one field (not primary key).  Our issue derives from that fact that the search field is not the primary key and therefore there are duplicate values that represent different spatial features.  The autocompletebox auto filters the results to only show one record when duplicates are returned.  This is an issue for us.

Q1 - Can we override the autocompletebox default approach to not show duplicate features.

If we can get a positive answer for Q1 then that is progress, but for improved usability we want to display the two fields that represent the combined key.

Q2 - Can you display two fields within the autocompletebox DISPLAY FIELD?

Research of the current support forum suggests we can solve the problem by either

a) Create a combined field in the data of the two fields - this is not ideal for us.

b) Create a featureset at runtime combining the two fields for all records; query this featureset in the autocomplete box - again with the volume of data this is not ideal.

Any help appreciated.

Yours,

Colin Banno

 

 

0

• 

  Permanently deleted user

  June 18, 2014 03:58

  Hi Colin

  so is there something bad about making a SQL view of the data that has a combined field as a third option?

  Regards

  Ralph

  0

Please sign in to leave a comment.