TopRows Property
General info
Label |
Top Rows |
Description |
The number of rows which will be inserted into the diagnostic table. Please note that any value above zero will result in two queries being executed and thus adding significant load to the object function and the database server. Also limits the number of lines returned for queries which are to be processed by the Lua script hosted by the Final Script property. |
Data type |
Int32 |
Default value |
1000 |
Min value |
0 |
Max value |
10000 |
Type |
Regular |
Code |
6446 |
Symbolic name |
MODEL_PROP_TOPROWS |
Lua access code |
syslib.model.properties.TopRows |
Available since |
1.52 |
- Parent properties
Attributes
| Name | Tooltip |
|---|---|
| PROP_CONFIGURABLE | The property is configurable and can be changed with DataStudio and the various inmation APIs. |
| PROP_VISIBLE | The property is visible in DataStudio and can be read by the inmation APIs. |
| PROP_HAS_DEFAULT | The property has a default value as standard. |
| PROP_HAS_LOLIMIT | The property has a low limit. |
| PROP_HAS_HILIMIT | The property has a high limit. |
Examples
Read from or write to the TopRows property.
-- Read from the TopRows
syslib.getvalue("<OBJECT FULL PATH>.ODBCDiagnostics.TopRows")
-- Write to the TopRows
syslib.setvalue("<OBJECT FULL PATH>.ODBCDiagnostics.TopRows", 1000)TcpConfig tcpcfg = new TcpConfig() { HostNameOrIp = "localhost", Port = 6512 };
SecurityCredentials sc = new SecurityCredentials() { ProfileName = "<username>", Password = "<password>" };
StatelessInterface sli = new StatelessInterface(tcpcfg);
// Read from the TopRows
Result result = sli.ReadValue(sc, new ReadItem("<OBJECT FULL PATH>.ODBCDiagnostics.TopRows"));
// Write to the TopRows
Result result = sli.WriteValue(sc, new WriteItem(1000, "<OBJECT FULL PATH>.ODBCDiagnostics.TopRows"));