No. 478 1 March 2019

ebroker: Search patterns / empty records.

ebroker allows to find records in the different modules of the system using search patterns, these are written in the different fields of the forms of the modules in order to generate a search condition.

Today, we will see the search pattern that allows searching for records taking into account whether the field to consult is empty or not empty:

  • = NULL for empty content fields
  • <> NULL for fields with some type of content

 You just have to go to ...

For example, if we want to search for physical clients who do not have the date of birth informed, we write "= NULL" in the corresponding field

Share