Sorting todos by priority's value

Hello,

I’m making a todo application and I cannot get bubble to sort my todos by priority.
Here is the situation: I have a database of all the todos, with duedate and priorityname.
I have a different database where I store the priorities, all of them has a name and a rank, so I can add later priorities.

How do I make my repeating group sort the todos by the priority’s value?
I tried to sort by the priority’s value and it should work but it doesn’t.
Did anyone managed to make a sorting like this?

Right, currently our sorting functionality has to be on the current thing. So if you have, let’s say, a number ‘priority’ attached to a thing of type ToDo, you can do it. Can you modify your data structure so that the priority is attached to the ToDo item directly?

Sure, Thanks Emmanuel.