Product DocumentationJavaScript Properties
The following JavaScript properties are supported for scripting conditions and actions in WLM rules. For more details, see Rule Conditions; each property is linked to a description on that page.
The read-only column indicates whether the JavaScript property is settable. Yes means that it is not settable; it can only be read from (that is, used in a filter to make decisions).
| Name | Type | Read-only |
|---|---|---|
| w.SQLText | String | Yes |
| w.resourcePool | String | No |
| w.priority | String | No |
| w.command | String | Yes |
| w.user | String | Yes |
| w.roles | String | Yes |
| w.application | String | No |
| w.database | String | Yes |
| w.namespace | String | Yes |
| w.superUser | Boolean | Yes |
| w.explainAnalyze | Boolean | Yes |
| w.referencedTables | List<String> | Yes |
| w.singleWorker | Boolean | Yes |
| w.transactionId | Number | Yes |
| w.maximumWaitLimit | Number | No |
| w.maximumRowLimit | Number | No |
| w.maximumExecTimeLimit | Number | No |
| w.memoryEstimate | Number | No |
| w.memoryEstimateConfidence | String | Yes |
| w.memoryRequired | Number | Yes |
| w.allowSQB | Boolean | No |
| w.abort(String) | Method | No |
| w.duration | Number | Yes |
| w.executionDuration | Number | Yes |
| w.submitTime | Date | Yes |
| w.createTime | Date | Yes |
| w.enqueueTime | Date | Yes |
| w.prepareTime | Date | Yes |
| w.executionTime | Date | Yes |
| w.completionTime | Date | Yes |
| w.stats.bytesRead | Number | Yes |
| w.stats.readIOs | Number | Yes |
| w.stats.readTime | Number | Yes |
| w.stats.bytesWritten | Number | Yes |
| w.stats.writeIOs | Number | Yes |
| w.stats.writeTime | Number | Yes |
| w.stats.maxMemory | Number | Yes |
| w.stats.currentMemory | Number | Yes |
| w.stats.totalMemory | Number | Yes |
| w.stats.rowsReturned | Number | Yes |
| w.stats.rowsInserted | Number | Yes |
| w.stats.rowsDeleted | Number | Yes |
| w.stats.bytesReadSpill | Number | Yes |
| w.stats.bytesWrittenSpill | Number | Yes |
| w.stats.bytesNetwork | Number | Yes |
Parent topic:Creating Rules