Question
· Oct 13

Sorting by number field type in FDN

I have a custom defined priority field that is being stored as a number type

<record name="LocalClinicalMeSHTerms" type="serial">
<field name="LocalClinicalExpertiseCodedValue" type="{CODETYPE}" codeFamily="HSPD" codeTable="LocalClinicalExpertise" codeScheme="{MASTER}"/>
<field name="LocalCliniclDisplayOrder" type="number"/>
</record>

However, within the overviewIndividual.cls form

				{
					"type": "HSPD.collection",
					"key": "LocalClinicalMeSHTerms",
					"hideExpression": "formState.lib.hideField(formState) && model.LocalClinicalMeSHTerms==''",
					"templateOptions": {
						"label": "LocalClinicalMeSHTerms"
					},
					"data": {
						"collections": {
							"editAs": "inline",
							"pager": {
								"suppressPaging": true
							}
						},
						"pd": {
							"corrections": {
								"display": "formState.lib.getCorrectionsDisplayForArray(model[options.key], 'row.CodedValue.Description', this)"
							}
						},
						"embeddedLabel": "MeSHTerm",
						"embeddedFields": [
							{
								"type": "HSPD.select",
								"key": "LocalClinicalExpertiseCodedValue",
								"templateOptions": {
									"label": "Type",
									"options": [
										{
											"Description": "",
											"_class": "HS.DataManager.Datatype.CodeItem"
										}
									]
								},
								"data": {
									"codeTable": "HSPD.LocalClinicalExpertise",
									"orderField": "Description"
								}
							},
							{
								"type": "input",
								"key": "LocalCliniclDisplayOrder",
								"templateOptions": {
									"type": "number",
									"label": "Priority",
									"model":[
										{
											"minSize":1
										}
									]								}
							}
						]
					}
				}

 

when I first return results from by search it is sorting by highest value so if an Individual had 11 fields, it would display starting with 11.

If I click the sorting function at the top of the column it is not sorting by numeric value.

Anyone have an idea on how I can return the results in the correct "Priority" order and then properly sort the order correctly?

Product version: IRIS 2024.2
$ZV: HealthShare Provider Directory 2024.2.0 Build: 1009 [HealthShare Modules: Core:28.0 + Provider Directory:28.0] - IRIS for UNIX (Red Hat Enterprise Linux 8 for x86-64) 2024.1 (Build 267_2_24113U) Wed Jul 2 2025 16:36:55 EDT [Core:28.0|Provider Directory:28
Discussion (0)2
Log in or sign up to continue