X-Git-Url: https://git.arvados.org/arvados-workbench2.git/blobdiff_plain/48ae17a520d11173e2ae96fb7c78aa4a411a489a..54805dd83a984d4e34bb35146d2505bac12bc1d0:/src/services/api/filter-builder.ts diff --git a/src/services/api/filter-builder.ts b/src/services/api/filter-builder.ts index d5903c56..da67935a 100644 --- a/src/services/api/filter-builder.ts +++ b/src/services/api/filter-builder.ts @@ -2,17 +2,21 @@ // // SPDX-License-Identifier: AGPL-3.0 -export function joinFilters(filters0?: string, filters1?: string) { - return [filters0, filters1].filter(s => s).join(","); +export function joinFilters(...filters: string[]) { + return filters.filter(s => s).join(","); } export class FilterBuilder { constructor(private filters = "") { } - public addEqual(field: string, value?: string | boolean | null, resourcePrefix?: string) { + public addEqual(field: string, value?: string | string[] | boolean | null, resourcePrefix?: string) { return this.addCondition(field, "=", value, "", "", resourcePrefix); } + public addDistinct(field: string, value?: string | boolean | null, resourcePrefix?: string) { + return this.addCondition(field, "!=", value, "", "", resourcePrefix); + } + public addLike(field: string, value?: string, resourcePrefix?: string) { return this.addCondition(field, "like", value, "%", "%", resourcePrefix); } @@ -21,6 +25,10 @@ export class FilterBuilder { return this.addCondition(field, "ilike", value, "%", "%", resourcePrefix); } + public addContains(field: string, value?: string, resourcePrefix?: string) { + return this.addCondition(field, "contains", value, "", "", resourcePrefix); + } + public addIsA(field: string, value?: string | string[], resourcePrefix?: string) { return this.addCondition(field, "is_a", value, "", "", resourcePrefix); } @@ -52,9 +60,23 @@ export class FilterBuilder { public addExists(value?: string, resourcePrefix?: string) { return this.addCondition("properties", "exists", value, "", "", resourcePrefix); } + public addDoesNotExist(field: string, resourcePrefix?: string) { + return this.addCondition("properties." + field, "exists", false, "", "", resourcePrefix); + } public addFullTextSearch(value: string) { - const terms = value.trim().split(/(\s+)/); + const regex = /"[^"]*"/; + const matches: any[] = []; + + let match = value.match(regex); + + while (match) { + value = value.replace(match[0], ""); + matches.push(match[0].replace(/"/g, '')); + match = value.match(regex); + } + + const terms = value.trim().split(/(\s+)/).concat(matches); terms.forEach(term => { if (term !== " ") { this.addCondition("any", "ilike", term, "%", "%");