const RQdb = ccFactory.CreateDatabaseRemoteQuery("ZuF-mV7_wk6sLIRYrYawXQ",`"SELECT * FROM Customers Where City = :Feldname"`,{"Feldname": "Berlin"});
db.ExecAsync().pipe(mergeMap(success=>{
if(success){
db.Reset();
db.SourceId = "lwyRzgyLEe-vV0qTCulcew",;
db.Query = `"SELECT * FROM Orders" );
RQ.SourceID = "GHCjrA0BEe-NxIo6m1CQ0A"; Inventory Where Customer = :Customer"`;
db.QueryFields = {"Customer":db.Response.Rows[0]["Id"]};
return db.ExecAsync();
}
return of(false);
})).subscribe(success=>{
if(success)
{
const rowcount = db.Response.Rows.length;
if(rowcount > 0)
ccFields.SetState("h_inventory", "ccFS_Okay");
else
ccFields.SetState("h_inventory", "ccFS_Error", "No inventory found");
}
}) |