Introduction
New search operators are now supported. This enhancement offers greater flexibility
and accuracy when searching for data in Dialfire.
Explanation of the search operators
1. =*: Searches for entries where the expression is at the end.
Example: =*a searches for entries that end with "a".
2. *=: Searches for entries where the expression is at the beginning.
Example: *a= searches for entries beginning with "a".
3. *=*: Searches for entries where the expression occurs anywhere in the text.
Example: *a* searches for entries that contain "a" anywhere.
4. *!=: Searches for entries that do not begin with the expression.
Example: *!=a searches for entries that do not begin with "a".
5. !=*: Searches for entries that do not end with the expression.
Example: !=*a searches for entries that do not end with "a".
6. *!=*: Searches for entries where the expression does not appear anywhere in the
text. Example: *!=a* searches for entries that do not contain "a" anywhere.
7. <: Searches for entries that are smaller than the specified value.
Example: <100 searches for entries that are smaller than 100..
8. >: Searches for entries that are greater than the specified value.
Example: >100 searches for entries that are greater than 100.
9. <=: Searches for entries that are less than or equal to the specified value.
Example: <=100 searches for entries that are less than or equal to 100.
10. >=: Searches for entries that are greater than or equal to the specified value.
Example: >=100 searches for entries that are greater than or equal to 100.
11. !<: Searches for entries that are not smaller than the specified value.
Example: !<100 searches for entries that are not less than 100.
12. !>: Searches for entries that are not greater than the specified value.
Example: !>100 searches for entries that are not greater than 100.
13. !<=: Searches for entries that are not less than or equal to the specified value.
Example: !<=100 searches for entries that are not less than or equal to 100.
14. !>=: Searches for entries that are not greater than or equal to the specified value.
Example: !>=100 searches for entries that are not greater than or equal to 100.
Important note on previous search expressions
Previously, an expression such as =*a was interpreted as *a. With the new operator, this
expression now has a different meaning, namely a*. If this expression was used via the API,
it must be adapted. This problem does not occur with the explicit form.
Search for non-indexed fields
It is not possible to search for empty fields if they are not indexed. Without an index, the
system searches a $undefined field. In this field, all contents are separated by commas,
which are then searched. However, empty content is not added.
Addition:
Only if an additional indexed field is included in the search will the system also search a
non-indexed field, even if it is empty.
Examples:
● Search for Email="": No hits are displayed because the Email field has no index
in this case and there are no empty values in $undefined.
● Search for Email="" AND $id>: Results are displayed because the system
searches each individual ID and also checks whether the Email field is empty..
Optimizing the search
It is therefore better to carry out the search with two indices if there is no index on the field
being searched for or if it is empty.
For example:
● A search for +491* in the $phone field will come up higher than +499.
● It can happen that the search for +499* returns an error because the search is too
imprecise.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article