mw_query_limits

limit_type

int32

Y

N

Specifies the query limit category. Each category defines the maximum number records that can be retrieved for the MES middleware object.

Specifying large limits may impact the performance of the query.

Allowed limit type values are:

0 - Default

1 - Custom

2 - Unlimited

limit_desc

string40

N

N

Describes the query limit category (Default, Custom, or Unlimited) for each limit_type.

limit_value

int32

N

Y

Specifies the user configured maximum number of records that can be retrieved for the limit_type.

If the limit_type is 0, the initial limit_value specified is 5,000. The user configured limit_value must be less than or equal to 10,000.

If the limit_type is 1, the initial limit_value specified is 100,000. The user configured limit_value must be greater than 10,000.

If the limit_type 2, the limit_value specified is 0. The number of records returned for the object is not constrained. Note that the limit_value for limit_type 2 cannot be customized.

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.