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