Macros

For users with access to the Admin/Macros submodule, we have provided a new mechanism that allows for executing a series of operations in the database based on three main SQL commands: update, insert, and delete. For example, macros can be used to deactivate users who have not logged into the application for the past three months or delete open inspection tickets from selected definitions. Previously, such operations were not possible. With macros, we can modify tables in the database without any obstacles, therefore modifying values visible in the application interface.