Filter rows

 

images\filterrows.jpg

It is possible to enter a SQL Where clause to limit the records in the result set.

Where clause can be a static SQL Statement (example: CountryCODE= ‘US’)

or dynamic parameter can be used.

Select the parameter in the combo box and click the Insert button, the parameter will be inserted in the edit field.
During the synchronization, GeniusConnect will replace the parameter tag with current system values:

{DB_LOGIN_USER} runtime value:
Login used to connect to the database (NT User if NT security used)

{DB_USER_NAME} runtime value:
Username returned by the database

{WINDOWS_USER} runtime value:
Current windows (NT) user

Example runtime value: John

{WINDOWS_NT_USER} runtime value:
Current windows (NT) user, (domain included)
Example runtime value: mydomain\John

{OUTLOOK_USER} runtime value:
Current Outlook user (only Outlook 2003 or higher)

{OUTLOOK_USER_EMAIL} runtime value:
The email address of the currently logged-on user

{OUTLOOK_FOLDER_FULL} runtime value:
Current Outlook folder full path and name
Example runtime value Outlook 2000: Calendar

Example runtime value Outlook 2002 or higher: \\Personal Folders\Calendar

{OUTLOOK_FOLDER_NAME} runtime value:
Current Outlook folder name
Example runtime value: Calendar (same
us {OUTLOOK_FOLDER_FULL} in Outlook 2000)

{EXCHANGE_FOLDER_OWNER} runtime value:
Exchange only! Name of a Mailbox Folder Owner. (Not for Public Folders)
Example runtime: John Smith

{EXCHANGE_FOLDER_OWNER_EMAIL} runtime value:
Exchange/Office 365 only! The email address of the exhange folder owner. (Not for Public Folders)
Example runtime: user@domain.com

{EXCHANGE_FOLDER_OWNER_ENTRYID} runtime value:
Exchange/Office 365 only! MAPI EntryID (unique identifier used by Outlook/Exchange) of a Mailbox Folder Owner. (Not for Public Folders)
Example runtime: 000000001A447390AA6611CD9BC800AA002FC45A03001C29EC2B445D7C4297…

{EXCHANGE_FOLDER_USER_NAME} runtime value:
Exchange only! Name of a Mailbox Folder user.
Example runtime: John Smith

 

{COMPUTER_NAME} runtime value:
Current NetBIOS name of the local computer

 

Use the “Test Query” button to check if your statement is correct!

 

Ignore Filter for record Update

Check this option to ignore filter during the updates, if not checked the filter is applied also during the database updates.

Ignore Filter for record Delete

Check this option to ignore filter during the deletes, if not checked the filter is applied also during the database deletes.

 

It is recommended to use “view” in the database instead of GeniusConnect filters.

If your database supports view, please see our support forum for more info: http://forum.geniusconnect.com/

 

 

See also:

Assign fields

Configuration - Database

Conversion

Create a data source

Field information

Mandatory keys