Skip to content

Create a new search operator that matches on all text fields #7527

@corcom

Description

@corcom

Support guidelines

Description

I think it would be great if when using the search there was an operator that matched on all possible text fields.
For example if we have a few transactions like this:

Desc, src, dst, date, amnt, famnt, bdgt, cat, tag, bill, notes
Test, a, b, 1/1/1900, 10, 0, c, d, e, f, g
a, test, b, 1/1/1900, 10, 0, c, d, e, f, g
b, a, test, 1/1/1900, 10, 0, c, d, e, f, g
c, a, b, 1/1/1900, 10, 0, test, d, e, f, g
d, a, b, 1/1/1900, 10, 0, c, test, e, f, g
e, a, b, 1/1/1900, 10, 0, c, d, test, f, g
f, a, b, 1/1/1900, 10, 0, c, d, e, test, g
g, a, b, 1/1/1900, 10, 0, c, d, e, f, test

Ideally I could search for "any_text_contains:test" and i would get all of them.
Currently I would have to build a query that would use operators for each field which would be very long.

Solution

Create new operators that can look something like this:

any_text_starts:query
any_text_ends:query
any_text_is:query
any_text_contains:query

What are alternatives?

Currently you since it seems that you can't OR operators I don't think there is a possible way but if you could OR operators it would look like this:

account_contains:test OR description_contains:test OR category_contains:test OR budget_contains:test OR bill_contains:test OR tag_contains:test OR notes_contain:test OR attachment_name_contains:test

Additional context

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    Status

    To do

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions