Id: | 18096 |
Product: | finPOWER Connect |
Type: | NEW |
Version: | 3.04.00 |
Opened: | 19/01/2021 |
Closed: | 28/05/2021 |
Released: | 30/06/2021 |
Job: | J025787 |
Accounts; Search0-4 fields added for Scripts to update and Quick Search to use on non-MS Access databases
The Account database table (and the corresponding finAccount object) now has Search0-Search4 fields which, like the Client table (and finClient object) can be updated via Scripts.
These fields are only intended for use on SQL Server databases since, in MS Access databases, these fields are not indexed.
For SQL Server, the following indexes will be created:
- XX_AccountSearch0
- XX_AccountSearch1
- XX_AccountSearch2
- XX_AccountSearch3
- XX_AccountSearch4
NOTE: Unlike the Client table where Search0 is system use only and 100 characters in length, all five of the Account Search fields are 50 characters in length and not system use only.
These fields are not included when exporting and importing an Account to XML.
Like the various Client Search fields, Quick Search utilises these fields for a medium level search (i.e., not whilst typing). However, these fields are NOT searched on MS Access databases.