I have a strange problem where on some pages my content row component is sorting according to my order by clause and on others it is not. I've identified what I think is the cause and am looking for an explanation from someone about the behavior and maybe I've discovered a bug.
If any of my columns use a list of values then the order by clause in the main query is ignored. When I take the list of values out, the sort is applied correctly.
Here is an example of my query:
SELECT SC_SAID,
COURSE_ID,
ROOM,
PERIOD,
START_TIME,
END_TIME
FROM atnd_classes
WHERE teacher_said = :P100_ID
ORDER BY PERIOD
The COURSE_ID column was set to get its value from a list of values. In this case the ORDER BY PERIOD seems to be ignored. When I turn off the list of values the sort is applied correctly.