mw_object_query_limit
- Last UpdatedJan 14, 2025
- 1 minute read
The mw_object_query_limit table contains the user configured query limit categories assigned to queries on specific MES middleware objects. Only exceptions should be added to this table. Custom tables added to the MES database can also be added to this table when accessed through the MES middleware.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
mw_object_name |
string128 |
Y |
N |
The name of the MES middleware object that the query limit applies to. At installation, limit_type values of 1 are defined by default for the MES language, characteristic, util_reason, and util_reason_grp objects. Queries on MES middleware objects not specified in the mw_object_query_limit table return a maximum of 5,000 records by default. |
|
limit_type |
int32 |
N |
N |
Specifies the query limit category (0, 1, or 2) for the object. The query limit categories define the maximum number records that can be retrieved for the MES middleware object. The limit_types are defined in the mw_query_limits table. |
|
last_edit_comment |
string254 |
N |
Y |
The reason the record was changed. |
|
last_edit_by |
string40 |
N |
Y |
The last user to change the record. |
|
last_edit_at |
tdatetime |
N |
N |
When the record was last changed. |