Sort List Based on Field's Location in Another List

ryaavr25 · 2025-01-27T06:03:19.896Z

Hey everyone.
I’m really stuck here and could use some help! I’m working on a CAD/MDT and my goal is for the system to recommend units to attach to a call based on the call type and the defined unit types (and quantity per unit type) for that call type. I have a data type of Venue (which is essentially the city, borough, town, whatever you want to call it) and 2 of its data fields are PrimaryDepts (a list of departments, but only one department per agency (Police, Fire, EMS)) and SecondaryDepts (a list of departments, they are added to this list in the order that they’re supposed to be attached to the call if unit types are not available from the primary department). So for example, if the unit type required for a certain call type is a supervisor, and there are no available supervisors from the PrimaryDepts field Police department, it will select a supervisor from the first Police department in the list of SecondaryDepts, and continue down the list until it finds one. The issue is, I want to merge a list of units (Do a search for units where department is in venue’s PrimaryDept) with a list of units (Do a search for units where department is in SecondaryDepts), but I want those units to be sorted by their department’s position in the SecondaryDepts list.

system · 2025-04-07T06:04:02.279Z

This topic was automatically closed after 70 days. New replies are no longer allowed.