gistfile1.txt

SELECT id, "order" FROM plain_note WHERE archived = :archived AND trashed = :trashed ORDER BY  "order" ASC

to

private func getUpdateOrdersBasedOnX(context: NSManagedObjectContext, sortDescriptors: [NSSortDescriptor], archived: Bool, trashed: Bool) -> [UpdateOrder] {
    let predicate = NSPredicate(format: "archived == %i AND trashed == %i", (archived ? 1 : 0), (trashed ? 1 : 0))
    
    // https://stackoverflow.com/a/64964284/72437
    let objectIDExpression = NSExpressionDescription()
    objectIDExpression.name = "objectID"
    objectIDExpression.expression = NSExpression.expressionForEvaluatedObject()
    objectIDExpression.expressionResultType = .objectIDAttributeType
    
    let fetchRequest: NSFetchRequest<NSFetchRequestResult> = NSFetchRequest()
    fetchRequest.entity = NSEntityDescription.entity(forEntityName: "NSPlainNote", in: context)
    fetchRequest.resultType = .dictionaryResultType
    fetchRequest.propertiesToFetch = [objectIDExpression, "order"]
    fetchRequest.predicate = predicate
    fetchRequest.sortDescriptors = sortDescriptors
    
    var updateOrders: [UpdateOrder] = []
    
    do {
        let resultTypes = try fetchRequest.execute()
        
        for resultType in resultTypes {
            if let dict = resultType as? [String : Any] {
                let objectID = dict["objectID"] as! NSManagedObjectID
                let order = dict["order"] as! Int64
                let updateOrder = UpdateOrder(objectID: objectID, order: order)
                updateOrders.append(updateOrder)
            }
        }

        return updateOrders
    } catch {
        //backgroundContext.rollback()
        
        error_log(error)
    }
    
    return updateOrders
}