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.
.png)
.png)
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)0