[resolved] Search and filter query sintax

mertez — Sat, 16 Nov 2024 10:48:09 GMT

Hi,

from the documentation I can hardly see how to use this operator. When trying different scenarios I could see that for text search Talend automatically narrows down columns based on the written word and suggests the IN operator. Is there any option how to filter rows with a regular expression?

Other thing that I noticed is that inserting a new filter is possible just by clicking on the drop-down suggestion. When typing the same suggestion word (eg. thething in COMPANY) and pressing enter nothing occurs. Am I using it right?

Re: [resolved] Search and filter query sintax

Anonymous — Mon, 15 Feb 2016 16:39:32 GMT

There is no language at this point, we always run an implicit contains query on whatever you type, in all columns. We then suggest which columns have at least one cell that contains the string you typed, with sentences like "whatever you typed in eligible column".
By contains I mean anywhere in the cell; for instance if you search for "book", it will find "facebook", "bookshelf" and "mybookstore.com".
This search field is like a global search, sort of like a Ctrl + F (or Cmd + F) in your browser. You don't need to know in advance in which column the data is. The flip side being that, indeed, you can't force it to search only within a particular column.
We will probably allow predicates in the future though, such as '>', '<' etc. for numerics, 'and' / 'or' conditions etc.

topic Re: [resolved] Search and filter query sintax in Data Quality

[resolved] Search and filter query sintax

Re: [resolved] Search and filter query sintax