4.3 Salesware .INI Settings Reference : Sales32c.INI [UpdateFilters] section
 
Sales32c.INI [UpdateFilters] section
 
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].