I have a view, which lists the content. On the view I am using a pager, so that only 10 contents are displayed per page. At the same time I have a sorting filter, which is changing the order of the content. (The sorting is based on the field with values either 1 or 0, and sorts DESC).
The issue for me is that when I apply the sorting, the order of the content is changed. But when I go to page 2 and then return to page 1. I see that the order of the content is changed (within the values 0 or 1).
But it looks pretty inconsistent from the user's point of view. It is not a caching problem. But how can I keep the order of the content always the same?