Method substring

sdk/src/CloudQuery.js:645–686

(columnName, value, isCaseInsensitive)

    }

    substring(columnName, value, isCaseInsensitive) {

        if (typeof columnName === "string") {
            columnName = [columnName];
        }

        for (var j = 0; j < columnName.length; j++) {
            if (Object.prototype.toString.call(value) === '[object Array]' && value.length > 0) {
                if (!this.query["$or"])
                    this.query["$or"] = [];
                for (var i = 0; i < value.length; i++) {
                    var obj = {};
                    obj[columnName[j]] = {};
                    obj[columnName[j]]["$regex"] = ".*" + value[i] + ".*";

                    if (isCaseInsensitive) {
                        obj[columnName[j]]["$options"] = "i";
                    }

                    this.query["$or"].push(obj);
                }
            } else {
                if (columnName.length === 1) {
                    this.regex(columnName[j], ".*" + value + ".*", isCaseInsensitive);
                } else {
                    if (!this.query["$or"])
                        this.query["$or"] = [];
                    var obj = {};
                    obj[columnName[j]] = {};
                    obj[columnName[j]]["$regex"] = ".*" + value + ".*";

                    if (isCaseInsensitive) {
                        obj[columnName[j]]["$options"] = "i";
                    }

                    this.query["$or"].push(obj);
                }
            }
        }

        return this;
    }

    //GeoPoint near query
    near(columnName, geoPoint, maxDistance, minDistance) {