OmniGroupServer 12.12

# SQLStatement

The SQL statement to use to retrieve information from the database.

When you use the parameter ExecuteSectionN to construct multiple levels of queries, you can use placeholders in the statement. The placeholders are replaced by the output from previous queries.

The placeholder `@(ColumnName)` is replaced by the value of the column from the query one level up.

The placeholder `@@(ColumnName)` is replaced by the value of the column from the query two levels up.

NOTE: The column names returned by queries to some types of database are converted to uppercase or lowercase. The column name used in the placeholder is case sensitive so must match the output from the database - even if this does not match the case of the column names used in the `SQLStatement`.

Type: | String
Default: |
Required: | Yes
Configuration Section: | Database Repository or Execute
Example: | `SQLStatement=SELECT DISTINCT Username FROM Groups`
See Also: | ExecuteSectionN

© Copyright 2022 Micro Focus or one of its affiliates
Version 12.12 | Last updated June 2022

Send documentation feedback

Close

Send documentation feedback

To send feedback using your default email client, open an email window.

Otherwise, send your feedback and the information below to swpdl.idoldocsfeedback@microfocus.com.

We appreciate your feedback!

Product: IDOL OmniGroupServer 12.12

Topic Title: SQLStatement