Googlier.com News Article Search
Googlier.com Precious Metals Exchange Smart Contracts
Googlier.com Document Services





          Autocomplete, Sort, Source List Over 1,000…      
https://spjsblog.com/forums/topic/autocomplete-sort-source-list-over-1000/#post-27256

Alexander,

Using Autocomplete, I have found that sort of results (orderBy) fails when the source list is over 1,000 items. I am sorting by ID, descending. I have attached two screenshots – one with less than 1,000 items in the source list, and one with more than 1,000 items.

As always, I sincerely appreciate your support and efforts!

R’grds – Ben.
Reference:
Version information
DFFS Loader: v2
DFFS frontend: 4.4.4.10 – September 20, 2019
DFFS frontend CSS: 4.51 / 4.51
Autocomplete: 1.6.37 – September 04, 2019
Cascading dropdowns: 3.7.30 – July 21, 2019
jQuery: 1.12.4
Lookup: 1.1.17 – July 21, 2019
Resource management: 2.4.5 – August 29, 2019
SPJS-Utility: 1.337 – September 04, 2019
vLookup: 2.2.138 – September 04, 2019


spjs.ac.textField({
 "applyTo": "TransPipeLookup",
 "helpText": "Key Transaction ID, LOB, or Name...",
 "loadText": "",
 "listGuid": "TransPipeDevX",
 "listBaseUrl": "/sites/spptdgsl/TransPipeDev/",
 "showField": "TransPipeLookup",
 "searchFields": [],
 "filterCAML": "<Where><Eq><FieldRef Name='CommodityType'/><Value Type='Text'>Tech</Value></Eq></Where>",
 "useREST": false,
 "preloadData":false,
 "filterREST": "",
 "optionDetailFields": [],
 "optionDetailPrefix": [],
 "enforceUniqueValues": true,
 "rowLimit": 15,
 "listOptionsOnFocus": false,
 "minLengthBeforeSearch": 2,
 "reValidateOnLoad": false,
 "allowAddNew": false,
 "isLookupInSelf": false,
 "addNewAdditionalFields": [],
 "multiselect": false,
 "multiselectSeparator": "; ",
 "orderBy": [
	{
		"fin":"ID",
		"ascending":false
	}
 ],
 "clearSetFieldsOnInvalidSelection": false,
 "setFields": [	
	{
		"fromFIN":"ID",
		"toFIN":"KeyTransID"
	},
	{
		"fromFIN":"Title",
		"toFIN":"Title"
	},
	{
		"fromFIN":"LOB",
		"toFIN":"LOB"
	},
	{
		"fromFIN":"SubLOB",
		"toFIN":"SubLOB"
	},
	{
		"fromFIN":"TechCommodities",
		"toFIN":"TechCommodities"
	}
],
 "debug": false
});



© Googlier LLC, 2019