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); } );