let criterias = [
{
Field: "IDF",
Operator: ">=",
Value: "HIGH",
Compound: "AND"
},
{
Field: "Persediaan",
Operator: "=",
Value: "Sedikit",
Compound: "AND"
}
];
dbcontext.tableName.Join("Address, Profile b").Where("b.Name=? and Address.Id=?", varname, variid)
.OrderBy("Name DESC, Id").Fuzzy(criterias).List("b.Name, Address.PostCode, Id")
.Send(function(results} {
handler(results);
}
);