Query Attribute
Some drivers require special formats for the Query attribute of the Import element.
When the Import element is connecting to a database, the Query attribute must contain a valid SQL statement for the target database.
For other values of the import Type, the drivers may require a specific syntax. These special cases are shown in the table below.
Type (driver) |
Query description |
---|---|
ADSI |
ADSI queries follow the LDAP syntax for a search filter:
|
CSV (text file) |
The syntax is:
Example:
Do not include the path to
the file in the query (the path is specified in the connection string
for this Type of import). |
Excel |
The default query (case insensitive) is:
Example: In
addition, Excel supports field enumeration and functions such
MID or ABS . |
WebService |
The query may be either:
|
XML |
No queries are supported. |
FlexNet Manager Suite (On-Premises)
2023 R2