# Sorting contained data

**URL:** <https://discourse.cakephp.org/t/sorting-contained-data/8429>\
**Category:** Uncategorized\
**Created:** [September 27, 2020, 1:21pm UTC](https://discourse.cakephp.org/t/sorting-contained-data/8429 "2020-09-27T13:21:22Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![shadowx.jb](https://avatars.discourse-cdn.com/v4/letter/s/a88e4f/32.png) [@shadowx.jb](https://discourse.cakephp.org/u/shadowx.jb)\
**Post date:** [September 27, 2020, 1:21pm UTC](https://discourse.cakephp.org/t/sorting-contained-data/8429/1 "2020-09-27T13:21:22Z")

</div>

Please how to setup `$this->paginate` if query contained data?

```
    $Query = $this->Users->find()
        ->contain([
            'UsersDocuments' => function (\Cake\ORM\Query $q) {
                return $q
                    ->contain([
                        'Orders'
                    ])
                    ->order(['UsersDocuments.date' => 'DESC'])
                    ->limit(1);
            }
        ]);

    $Content = $this->paginate($Query, []);

```

I would like to sort by the column that is in the Orders model