リビジョンのテーブルをカラムを指定してソートできるようにする

[ryu1kn]

No description provided.

[ryu1kn]

ソートはクライアントサイドじゃなくてサーバーサイドだよね？
となると GET /api/captures api を拡張して order を受け取れるようにする必要がある。その情報を findCaptures の sort に渡す。

// TODO: return "meta" and "items"
function findCaptures(skip, limit) {
  return Q.ninvoke(db.captures, 'aggregate', [
    {$match: {checkedAs: 'IS_OK'}},
    {$group: {
      _id: '$capture',
      updatedAt: {$max: '$updatedAt'},
      updatedBy: {$last: '$updatedBy'},
      expectedRevisions: { $push: '$revision' } } },
    {$sort: {_id: -1}},
    {$skip: skip || 0},
    {$limit: limit || DEFAULT_LIMIT}
  ]);
}

[piglovesyou]

yes > サーバーサイド
no > GET /api/captures
Please use a current API endpoint the page you are looking.

[ryu1kn]

Do you mean you don't have to receive order like you do for skip or limit?

[piglovesyou]

no, please use GET /api/revisions/{rid}/captures which already has an ordering functionality.

[ryu1kn]

Ah, I see. I didn't mean to use GET /api/captures as it'll retrieve all the captures from all the revisions. Sorry that I wrote the wrong one.

[piglovesyou]

Yes in that way you are right ask any time

[ryu1kn]

Yeah, what I wanted to say is that I'm going to add a query parameter order for the request of reading captures (for a certain revision).

[piglovesyou]

Yes you are right please use an existing ordering functionality of GET /api/revisions/{rid}/captures

[piglovesyou]

order=id:ascending&order=revisionAt:descending で複数カラムでソートできるようにしました。