Service - Sort Result - Revision history

Praew at 04:15, 18 March 2026

2026-03-18T04:15:55Z

@@ Line 114: / Line 114: @@
 * There is some large scale put into DynamoDB commands in this service, might be improved using BatchWriteItem, or improving async code.
 * SortResults defines its own expiry date (might not match ComplexFilter/Search Result expiry dates), so Search Result service must query Sort Result to see if have active results, if expired Sort Result removes its data, Search Result then checks its data/expiry. More fancy: Sort Result returns date expired but does not delete data until Search Result finishes its tasks, if Search Result fails could return Sort Result's old data, and/or push back Sort Result's expiry date.
 = See also =

Sven the Barbarian at 10:18, 25 December 2022

2022-12-25T10:18:15Z

← Older revision		Revision as of 10:18, 25 December 2022
Line 96:		Line 96:
	* sortResultIdLevelOrdValue: is {sortResultIdLevelOrd}_{value}		* sortResultIdLevelOrdValue: is {sortResultIdLevelOrd}_{value}
	* links multiple dataIds with the same value to their sorted record in TempStringSort/TempNumericSort		* links multiple dataIds with the same value to their sorted record in TempStringSort/TempNumericSort

			= Sorting Data That Has a Currency =

			* We want sortResult service to be able to sort by a converted amount, so client cannot perform conversions
			* Have a find data field that returns the base value and currency, another findData that returns conversion to a set currency, this will allow for sorting etc

	= Notes =		= Notes =

Sven the Barbarian at 13:44, 21 September 2022

2022-09-21T13:44:14Z

← Older revision		Revision as of 13:44, 21 September 2022
Line 10:		Line 10:

	== [[Standard Config Table Per Service]] ==		== [[Standard Config Table Per Service]] ==

	~~== [[Standard WebSocketTask Per Service]] ==~~

	=== Configuration tags ===		=== Configuration tags ===
Line 24:		Line 22:
	},		},
	</syntaxhighlight>		</syntaxhighlight>

			== [[Standard WebSocketTask Per Service]] ==

	== SortResultMain ==		== SortResultMain ==

Sven the Barbarian at 13:43, 21 September 2022

2022-09-21T13:43:55Z

← Older revision		Revision as of 13:43, 21 September 2022
Line 10:		Line 10:

	== [[Standard Config Table Per Service]] ==		== [[Standard Config Table Per Service]] ==

			== [[Standard WebSocketTask Per Service]] ==

	=== Configuration tags ===		=== Configuration tags ===

Sven the Barbarian at 14:25, 25 January 2022

2022-01-25T14:25:50Z

@@ Line 94: / Line 94: @@
 * sortResultIdLevelOrdValue: is {sortResultIdLevelOrd}_{value}
 * links multiple dataIds with the same value to their sorted record in TempStringSort/TempNumericSort
 = Notes =

Sven the Barbarian: /* TempNumericSort */

2022-01-24T00:49:07Z

TempNumericSort

← Older revision		Revision as of 00:49, 24 January 2022
Line 79:		Line 79:
	* partition key: sortResultIdLevelOrd		* partition key: sortResultIdLevelOrd
	* sort key: value		* sort key: value
	* ~~sortResultIdLevel~~: is {sortResultId}_{sortLevel}_{previous sort levels order}		* sortResultIdLevelOrd: is {sortResultId}_{sortLevel}_{previous sort levels order}

	== TempSortDataId ==		== TempSortDataId ==

Sven the Barbarian: /* TempSortValues */

2022-01-23T23:42:03Z

TempSortValues

← Older revision		Revision as of 23:42, 23 January 2022
Line 100:		Line 100:
	{		{
	sortResultIdLevel: "xx",		sortResultIdLevel: "xx",
	xx: "xx"		previousSortResultIdLevel: "xx"
	}		}
	</syntaxhighlight>		</syntaxhighlight>

Sven the Barbarian: /* TempStringSort */

2022-01-23T23:34:15Z

TempStringSort

← Older revision		Revision as of 23:34, 23 January 2022
Line 66:		Line 66:
	* partition key: sortResultIdLevelOrd		* partition key: sortResultIdLevelOrd
	* sort key: value		* sort key: value
	* ~~sortResultIdLevel~~: is {sortResultId}_{sortLevel}_{previous sort levels order}		* sortResultIdLevelOrd: is {sortResultId}_{sortLevel}_{previous sort levels order}

	== TempNumericSort ==		== TempNumericSort ==

Sven the Barbarian at 23:16, 23 January 2022

2022-01-23T23:16:13Z

← Older revision		Revision as of 23:16, 23 January 2022
Line 59:		Line 59:
	<syntaxhighlight lang="JavaScript">		<syntaxhighlight lang="JavaScript">
	{		{
	~~sortResultIdLevel~~: "xx",		sortResultIdLevelOrd: "xx",
	~~stringDataId~~: "xx",		value: "xx",
	~~dataId: "xx"~~
	}		}
	</syntaxhighlight>		</syntaxhighlight>

	* partition key: ~~sortResultIdLevel~~		* partition key: sortResultIdLevelOrd
	* sort key: ~~stringDataId~~		* sort key: value
	* sortResultIdLevel: is {sortResultId}_{sortLevel}_{previous sort levels order}		* sortResultIdLevel: is {sortResultId}_{sortLevel}_{previous sort levels order}
	* stringDataId: is {string being sorted}!!!{dataId}
	* using !!! in stringDataId should ensure sorting does not mix with dataId, because ! is sorted first by dynamodb/ascii

	== TempNumericSort ==		== TempNumericSort ==
Line 75:		Line 72:
	<syntaxhighlight lang="JavaScript">		<syntaxhighlight lang="JavaScript">
	{		{
	~~sortResultIdLevel~~: "xx",		sortResultIdLevelOrd: "xx",
	~~number~~: "xx"		value: "xx"
	}		}
	</syntaxhighlight>		</syntaxhighlight>

	* partition key: ~~sortResultIdLevel~~		* partition key: sortResultIdLevelOrd
	* sort key: ~~number~~		* sort key: value
	* sortResultIdLevel: is {sortResultId}_{sortLevel}_{previous sort levels order}		* sortResultIdLevel: is {sortResultId}_{sortLevel}_{previous sort levels order}
	* number: is the value of the field being ordered by

	== ~~TempNumericDataId~~ ==		== TempSortDataId ==

	<syntaxhighlight lang="JavaScript">		<syntaxhighlight lang="JavaScript">
	{		{
	~~sortResultIdLevelNumber~~: "xx",		sortResultIdLevelOrdValue: "xx",
	dataId: "xx"		dataId: "xx"
	}		}
	</syntaxhighlight>		</syntaxhighlight>

	* partition key: ~~sortResultIdLevelNumber~~		* partition key: sortResultIdLevelOrdValue
	* sort key: dataId		* sort key: dataId
	* ~~sortResultIdLevelNumber~~: is {~~sortResultIdLevel~~}_{~~number~~ value}		* sortResultIdLevelOrdValue: is {sortResultIdLevelOrd}_{value}
	* links multiple dataIds with the same ~~numeric~~ value to their sorted record in TempNumericSort		* links multiple dataIds with the same value to their sorted record in TempStringSort/TempNumericSort

			== TempSortValues ==

			<syntaxhighlight lang="JavaScript">
			{
			sortResultIdLevel: "xx",
			xx: "xx"
			}
			</syntaxhighlight>

			* partition key: sortResultIdLevel
			* sort key: previousSortResultIdLevel
			* sortResultIdLevel: is {sortResultId}_{sortLevel}
			* previousSortResultIdLevel: {previous sort levels order}
			* allows for finding all partition keys for one sort level so can find all TempStringSort/TempNumericSort records for one level

	= Notes =		= Notes =

Sven the Barbarian: /* TempStringSort */

2022-01-23T14:39:21Z

TempStringSort

← Older revision		Revision as of 14:39, 23 January 2022
Line 61:		Line 61:
	sortResultIdLevel: "xx",		sortResultIdLevel: "xx",
	stringDataId: "xx",		stringDataId: "xx",
	dataId~~: "xx",~~		dataId: "xx"
	~~string~~: "xx"
	}		}
	</syntaxhighlight>		</syntaxhighlight>