sort the queryView results by different attribute

[gayancharith]

When using the queryView method, I want filter the documents by one attribute and sort by another attribute. Currently I can sort the result only by emitting attributes.

[jamesnocentini]

Can you give an example of what the filter and sort attributes might be?

[gayancharith]

    person_name_view: {
      "map": function (doc) {
        if(doc.type === 'person') {
          emit(doc.firstname.toLowerCase(), null);
        }
      }.toString()
    },

here I want to filter persons from first name but I want sort them by their age.

[npomfret]

I think what you need to do is add the age to the index. Something like:

person_name_view: {
      "map": function (doc) {
        if(doc.type === 'person') {
          emit([doc.firstname.toLowerCase(), doc.age], null);
        }
      }.toString()
    },

They will be ordered naturally, so you can use the name in your key parameter and I understand they will come out in ascending age order.

[gayancharith]

@npomfret it is working perfeclty. But I am kind of confused since if I want to emit more keys (including more integer attributes) but I want sort from only one specific key, how should I do it ?

[gayancharith]

@jamiltz I think it is nice to have an option to tell whether which attribute I need to sort by.