Here is the filter, but the expression stops before the siteId condition.
Not sure if I use this correct or not, please be advise. Thanks!
const filterExpr = expressionBuilder.filter([
[["isDeleted", "not_exists"], "OR", ["isDeleted", "=", false]],
"AND",
[["assetReference", "begins_with", "site"], "OR", ["assetReference", "begins_with", "well"]],
"AND",
["siteId", "exists"],
"AND",
[["endTime", "not_exists"], "OR", [["startTime", "<=", ${filterEndTime}], "AND", ["endTime", ">=", ${filterStartTime}]]],
]);
Here is the filter, but the expression stops before the siteId condition.
Not sure if I use this correct or not, please be advise. Thanks!
const filterExpr = expressionBuilder.filter([
[["isDeleted", "not_exists"], "OR", ["isDeleted", "=", false]],
"AND",
[["assetReference", "begins_with", "site"], "OR", ["assetReference", "begins_with", "well"]],
"AND",
["siteId", "exists"],
"AND",
[["endTime", "not_exists"], "OR", [["startTime", "<=",
${filterEndTime}], "AND", ["endTime", ">=",${filterStartTime}]]],]);