orWhere method
Add an "or where" clause to the query.
If operator is not null, then value becomes operator and the operator becomes value.
queryBuilder.where('id', 1).orWhere('name', 'Cals');
queryBuilder.where('id', '=', 1).orWhere('name', '=', 'Cals');
When operator is null means the default operator is equal.
Implementation
QueryBuilder orWhere(String column, dynamic value, [dynamic operator]) {
String clause = '$column = $value';
if (value.runtimeType == String) {
clause = "$column = '$value'";
}
if (operator != null) {
clause = "$column $value $operator";
if (operator.runtimeType == String) {
clause = "$column $value '$operator'";
}
}
if (_where == "") {
_where = clause;
} else {
_where = "$_where OR $clause";
}
return this;
}