N1QL request so that the key and values documents

SQL++
1

Hi
How do I make a N1QL request so that the key and values documents are present? Like as the result of View:

View:

function (doc, meta) {
    if (meta.type == "json"
        && doc.title
        && doc.date
        && doc.type == "article"
        && doc.status == "published") {
        // Check if doc is JSON
        emit(doc.date, {
            'createdAt': doc.createdAt,
            'updatedAt': doc.updatedAt,
            'title': doc.title,
            'userDisplayName': doc.userDisplayName,
        });
    } else {
        // do something with binary value
    }
}

Result:

[
        {"id":"groundwork-now","value":{"createdAt":1503615662,"updatedAt":1503615662,"title":"groundwork now","userDisplayName":"Henrique Rossi"}},
        {"id":"week-left","value":{"createdAt":1503586823,"updatedAt":1503586823,"title":"week left","userDisplayName":"Luis Leleux"}},
        {"id":"one-that","value":{"createdAt":1503601238,"updatedAt":1503601238,"title":"one that","userDisplayName":"Luis Leleux"}}
]

N1QL:

SELECT t.title, t.createdAt, t.updatedAt, t.userDisplayName, t.`cover`, t.category
FROM `article` t
WHERE type="article"
AND status="published"
AND ANY v IN body SATISFIES v.text LIKE '%home%' END 
LIMIT 3;

Result:

[
        {"createdAt":1472241342,"title":"January 2010.","updatedAt":1472241342,"userDisplayName":"Aida Atwater"},       {"category":"digest","createdAt":1498899635,"title":"methodology is","updatedAt":1498899635,"userDisplayName":"Juliano Ferreira"},
        {"category":"digest","createdAt":1487775322,"title":"and had","updatedAt":1487775322,"userDisplayName":"Gerald Gressett"}
]

Thank you.

2 
SELECT META(t).id AS id, 
{t.title, t.createdAt, t.updatedAt, t.userDisplayName, t.`cover`, t.category} AS `value`
FROM `article` t
WHERE type="article"
AND status="published"
AND ANY v IN body SATISFIES v.text LIKE '%home%' END 
LIMIT 3;

NOTE: value is reserved word include in back ticks

OR

SELECT RAW { "id":META(t).id, "value":
      {t.title, t.createdAt, t.updatedAt, t.userDisplayName, t.`cover`, t.category} }
FROM `article` t
WHERE type="article"
AND status="published"
AND ANY v IN body SATISFIES v.text LIKE '%home%' END 
LIMIT 3;
3

Hello @vsr1

Thanks again!