Batch Filter Conditions Using Column Names - Runtime Server - Foundation 23.1 - Foundation 23.1 - Brainware - external

Batch

You can filter for a list of batches with a specific Batch identifier.

Data type

Number or Text

Filter condition

BatchId

Example

BatchId=5

Shows batches with a Batch ID equal to 5.

State

You filter for a list of batches that have a state equal to a value you specify in the query syntax. You can use equal, greater than, or less than operators.

Data type

Number

Filter condition

State

Example

State=550

Shows batches with State 550 in the batch list.

Priority

You can filter for the batch priority to return a list of batches that have a priority equal to a value you specify. You can combine the state column name and priority column name in the same query using the AND operator.

Data type

Number

Filter condition

Priority

Examples

Priority = 2

Shows a list of batches with Priority 2.

Priority <= 3

Shows a list of batches with Priority 0, 1, 2 and 3.

Priority = 2 AND State = 700

Shows a list of batches with Priority 2 and State 700.

Batch Name

You can filter for the batch name to return a list of batches with a name containing a specific string based on the like condition. The % symbol represents a wildcard for characters that precede and follow the defined string.

Data type

Text

Filter condition

Batch.Name

Example

batch.name like '%AP%'

Shows a list of batches with a name containing the specific string ‘AP’.

Folders

You can filter for a specific folder count value. You can use the equal operator and the greater than and less than operators.

Data type

Number

Filter condition

FolderCount

Example

foldercount = 1

Shows a list of batches having folder count equal 1.

Document

You can filter for a specific document count value. You can use the equal operator and the greater than and less than operators.

Data type

Number

Filter condition

DocumentCount

Example

documentcount >= 3

Shows a list of the batches having document count 3 or more than 3.

Last User

You can filter for the Last User value to return a list of batches based on the LastUserId value of 1, 2, or 3 where 1 = Application Administrator (RTS), 2 = Application Administrator (WVC), and 3 = Application Administrator (Designer).

Additionally, you can use the LastUserId filter condition to return a list of batches with a specific user name in the User database table.

Data type

Number or Text

Filter condition

LastUserId

Example

LastUserId = 1

Shows the batches with Last User of “Application Runtime Server”.

Last Module

You can filter for the Last Module value to return a list of batches with a specific name in the Module database table.

Data type

Number

Filter condition

LastModuleId

Example

LastModuleId in (select Id from Module where Name = 'SLW_Demo')

Shows the batches with ‘SLW_Demo’ in the Last Module column.

User Group

You can filter for the User Group value to return a list of batches that have an ExternalGroupId equal to the User Group ID assigned to the Windows Authentication User. The ID values are 111, 222, or 333 where 111 = ADM, 222 = VER, and 333 = VER/SET.

Data type

Number

Filter condition

ExternalGroupID

Batch Group

You can filter for the Batch Group value to return a list of batches in a specific Batch Group.

Data type

Number

Filter condition

ExternalBatchId

Example

ExternalBatchId = 2

Shows batches with Batch Group 2 in the batch list.

Transaction

You can filter for the Transaction ID to return a list of batches with a specific Transaction ID.

Data type

Number

Filter condition

TransactionID

Example

TransactionId = 2002

Shows batches with Transaction ID 2002 in the batch view.

Transaction Type

You can filter for the Transaction Type to return a list of batches with a specific Transaction Type.

Data type

Number

Filter condition

Transaction Type

Example

TransactionType = 3003

Shows batches with Transaction Type 3003 in the batch view.