Sales 32c.INI | Module | .INI Setting | Valid values | Default | Description | See also |
[UpdateFilters] | <TableName> Note: Any valid update table can be specified. | Any valid SQL statement WHERE clause | No filtering occurs | Activates the ability to filter all update or refresh files. The default is no filtering occurs. A filter is a part of an SQL statement WHERE clause. Each table can have an entry. Example: Accounts=(GETDATE()-date_time)<365 Invoices=account<>'*GUESTS*' AND account<>'*TABLES*' In this example, the accounts table would only retrieve accounts that were less than 365 days old and any invoices from the *GUESTS* and *TABLES* accounts would be ignored. This would only apply to updates performed following the insertion of the setting. Note: System account names (those which begin with '*') cannot be filtered out when the accounts table is filtered using the .INI setting [UpdateFilters]. |