What is the precedence in which the following sorts get applied and when do they get applied? I have a use-case where I have logic that is loading details in an HD–when debugging the logic block fetch with the sort (it a dynamic sort), and its not sorting the way I expected.
The sort defined in the logic block is always used when present in a logic block fetch. If no sort is defined in the logic block, then it will fall back to the database’s sort preference. This may align with the sort specified on the table index, but that is not guaranteed and should not be relied upon.
Similar fallback happens with an application: we will use the sort defined in the app or fall back to the database’s sort if none is defined.
Does this align with what you’re seeing?
Thank you, @brendan.b! It appears like it started out sorting as I expected, but then it looked like it stopped sorting. I will debug again now that you have confirmed this and see if something else is at play.