Hi @Marco_Greco, Please find the below code snippets and console responses for Local Dev and AWS.
Snippet Code for Named Parameters:
readCostAlertDoc: async (inputData, cb) => {
try{
console.log(“InputData >>”, inputData);
const { companyID, upc, type } = inputData;
// const q = SELECT ba.*,meta(ba).id from \${bucket}` ba WHERE companyID=‘${companyID}’ AND type=‘${type}’ AND upc=‘${upc}’`;
const q = ‘SELECT ba.*, meta(ba).id from costalerts ba WHERE companyID=$companyID AND type=$type AND upc=$upc’;
console.log(“Plain Query String >>”, q);
let cluster = new couchbase.Cluster(‘couchbase://ipaddress:8091/’);
cluster.authenticate(‘user’, ‘password’);
let bucketCluster = cluster.openBucket(‘costalerts’);
let query = couchbase.N1qlQuery.fromString(q);
console.log(“N1qlQuery String >>”, query);
bucketCluster.query(query, inputData, function(err, rows) {
if(err){
console.log(“Query Error >>”, err.toString());
return cb(err.toString(), null);
}
console.log(“Query Success >>”, rows);
cb(null, rows);
});
}catch(e){
cb(e.toString(), null);
}
}
AWS Console:
Local Dev Console:
Snippet Code for Positional Parameters:
readCostAlertDoc: async (inputData, cb) => {
try{
console.log(“InputData >>”, inputData);
const { companyID, upc, type } = inputData;
// const q = SELECT ba.*,meta(ba).id from \${bucket}` ba WHERE companyID=‘${companyID}’ AND type=‘${type}’ AND upc=‘${upc}’`;
const q = ‘SELECT ba.*, meta(ba).id from costalerts ba WHERE companyID=$1 AND type=$2 AND upc=$3’;
console.log(“Plain Query String >>”, q);
let cluster = new couchbase.Cluster(‘couchbase://ipaddress:8091/’);
cluster.authenticate(‘user’, ‘password’);
let bucketCluster = cluster.openBucket(‘costalerts’);
let query = couchbase.N1qlQuery.fromString(q);
console.log(“N1qlQuery String >>”, query);
bucketCluster.query(query, [companyID, type, upc], function(err, rows) {
if(err){
console.log(“Query Error >>”, err.toString());
return cb(err.toString(), null);
}
console.log(“Query Success >>”, rows);
cb(null, rows);
});
}catch(e){
cb(e.toString(), null);
}
}
AWS Console:
Local Dev Console:
We are getting success from the Local Dev machine but same code not working in the AWS Server. Please let us know if there any additional information require to closure ?