Hi,
I am looking for an N1ql query for the following, but it is not working. Any one please help me.
select *, meta().id from dbName where type = ‘office’ and (firstname, lastname) IN [ VALUES (‘Setve’, ‘Jobs’), (‘tom’, ‘cruise’)]
Hi,
I am looking for an N1ql query for the following, but it is not working. Any one please help me.
select *, meta().id from dbName where type = ‘office’ and (firstname, lastname) IN [ VALUES (‘Setve’, ‘Jobs’), (‘tom’, ‘cruise’)]
SELECT *, META().id
FROM dbName
WHERE type = "Office" AND
[firstname,lastname] IN [ ["Steve", "Jobs"], ["tom","cruise"] ];
It is working, Thank you so much.