DatasheetElement.getCustomQueryInfo (Method)
Returns a structure whose members contain information about a query. For example, a user name, password, the SQL query, and so on.
Returns:
DatasheetElement_GetCustomQueryInfo_Struct (struct)
Each row of the returned query results has the following fields:
| Field Name | Type | Description |
|---|---|---|
| DatasourceName | PlainText_NonNull | The datasource's name. |
| Password | PlainText_Secure | The database password. |
| sqlQuery | ValidSQLSelectStatement | A SQL Select statement. |
| Username | PlainText | The database username. |
Arguments:
| Name | Type | Required | Description |
|---|---|---|---|
| pageID | RealPageID_NonBaseTemplate | Required | A page's ID. |
| elementID | DatasheetElementInstanceID | Required | The datasheet element's control ID. |
| viewName | PlainText_NonNull | Required | The view's name. |
Context:
| License Requirements | Datasheet |
| Permission Requirements | element:Author |
| Deny Context | None |
| Require Context | AuthoringEnabled |
| Author Lock | (not required) |
| Transaction Logging | Transaction logging is disabled for this method |
| Customization | This method may be customized at the site level |
Error Codes:
None
Notes:
None