I tried using fancy row values for paging, but in the end the only way I could make things work with mixed sort directions was by composing individual compares. See https://github.com/StratoKit/strato-db/blob/master/src/JsonModel/JsonModel.js line 375 Anyway, perhaps you wanted to use ifnull(val, replacement)?