Folder field default

When you provide a default value for a folder field that is mapped to an application group field that contains database and displayed values, the default value must be one of the database values. If the database value that is selected as the default value contains a % (percent; wildcard), the database query that is performed by the Windows client uses the LIKE search operator in the query rather than the EQUAL search operator, which is the default search operator.

For example, assume that the following database and displayed value mapping pairs have been defined for an application group ID field named appl_id.

Database Value      Displayed Value

BBBLET            Company Letters for Baxter Bay Bank

ABTLET            Letters for Acme Bank & Trust

BBBREP            Reports for Baxter Bay Bank

ABTREP            Reports for Acme Bank & Trust

ABT%            Acme Bank & Trust Documents

BBB%            Baxter Bay Bank Documents

Assume that a folder field named Document is mapped to the application group ID field (appl_id) and has a default value of ABT%.

When the folder is opened from the Windows client, the default value for the folder field (Document) is set to Acme Bank & Trust Documents. When the query is performed, the document list contains documents that belong to the Letters for Acme Bank & Trust (ABTLET) and Reports for Acme Bank & Trust (ABTREP) applications.