Need to sort a Data type by a list of another Data type it contains

Need help Database
1

I have a data type: compliance task. This type contains a field, employees, which is a list of Users. Does anyone know how I can sort Compliance tasks by employees list of users count in a Repeating Group?

2

Hi @vansokip,

Add a new field to Compliance Task called “Employee Count” (or something) and make it a number. Any time a new employee is added, you’ll update this field to update the count. Best way is to do “This compliance Task’s Employees :count” (instead of This tasks count + 1). Yes, it’s another field to manage, but it instantly solves your sorting issue.

1 Like
3

Thank you! This worked!

1 Like