No. 744. December 20, 2024
ebroker: Search patterns
ebroker, it allows you perform dynamic searches using different search patterns.
You have a Wide range of patterns that make your searches easier in the different modules that make up the system. There are two types of patterns: general patterns and patterns for dates.
General patterns:
- < Smaller than
- <= less than or equal to
- > Greater than
- >= Greater than or equal
- = Like
- <> Different from
- = NULL Empty field
- <> NULL Field with value
- : Range. Minimum and maximum value separated by :
- | Concatenated. To search for different values within the same field, these are separated by |
Patterns for dates:
- @ AA @ Current year. Finds those records that match the current year
- @MD@ Same day. Finds those records that match the current day, regardless of the year and month.
- @TODAY@ Today. Find those records that match the current date
- @ MDM @ Same day and month. Finds those records that match the current day and month, regardless of the year.
- @DDxD@ Within x days. Finds those records whose date is within x days from the current day
- @HxD@ x days ago. Finds those records whose date is x days ago from the current day
You just have to go to ...
Help > Help > Offprints > Search patterns
Share