AUTOCOMPLETEBOX value sorting...possible?

Permanently deleted user

28. August 2019 11:42

Hi,

 

I would like to sort the values displayed in the AUTOCOMPLETEBOX after the user types-in a few characters.

 

I do not see any option to do it in AUTOCOMPLETEBOX properties as well.

 

 

Any ideas how it can be done?

 

 

Regards

 

 

0

• 

  Nico Burgerhart

  28. August 2019 12:04

  As far as I know they are sorted?

  0
• 

  Permanently deleted user

  29. August 2019 06:43

  Okay, so this is the issue.

   

  Say I type 'S12' in the autocomplete box and it populates it with results.

   

  I get the following (sample) response:

  • S12056734 (Wood Pole)
  • S12287453 (Wood Pole)
  • S12598263 (Wood Pole)
  • S12109452 (Wood Pole) and so on...

  There are results which never make it to the autocomplete suggestions, like 'S12 (Wood Pole)'.

   

   

  I've figured it out that if I specify an ORDER BY ASC in the request being sent to AGS, the result will contain the values currently missing. However, the query the autocomplete box fires, does not have an ORDER BY inherently, and there seems to be no way to specify that in the request the autocomplete box sends back to AGS.

   

   

  Any ideas around it?

  0
• 

  Nico Burgerhart

  29. August 2019 14:26

  What is the number of records in your table and what is the maximum number of records ArcGIS Server returns? Try to increase the maximum number of records (default value is 1000).

  0
• 

  Permanently deleted user

  30. August 2019 09:06

  The maximum number of records AGS returns is default i.e. 1000, but the Autocomplete box can take only 80. Why should that affect the result...the Autocomplete box does not apply any ordering while fetching the results...it may be doing once results are received from AGS

  0
• 

  Nico Burgerhart

  30. August 2019 09:21

  What is the Where Clause configured for the AutoCompleteBox in the display form?

  0
• 

  Tom Neer

  30. August 2019 15:12

  Are you using a LIKE in your query (e.g. SELECT * FROM table WHERE name LIKE '{0}%' ORDER BY name ASC"

  0
• 

  Permanently deleted user

  4. September 2019 05:09

  Sorry for the delayed response guys...

   

   

  Nico: Where clause is "UPPER(SEARCH_FIELD) Like UPPER('{0}%')"

   

  Tom: I tried using the ORDER BY in the AUTOCOMPLETEBOX where clause, but it did not help.

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.