WebSphere MQ Workflow 3.4.0 Java Generic API Test / Prototyping Tool

[prev][next][parent][TOC]

Filter / Sort - Example

Testcase
/*
example 23

Demo for FILTER, SORT CRITERIA and THRESHOLD
*/

Agent.Agent
  agentHdl                          1
End

Agent.setLocator
  agentHdl                          1
  locator                           LOC_LOCATOR
End

Agent.setName
  agentHdl                          1
  name                              ""
End

Agent.versionInfo
  agentHdl                          1
End

Agent.locate
  agentHdl                          1
  systemGroup                       "FMCGRP"
  system                            "FMCSYS"
  executionServiceHdl               1
  xpFmcException                    FMC_OK
End

ExecutionService.logon2
  executionServiceHdl               1
  userID                            "ADMIN"
  password                          "password"
  sessionMode                       PRESENT_HERE
  absenceIndicator                  NOT_SET
  xpFmcException                    FMC_OK
End

ExecutionService.queryWorkItems
  executionServiceHdl               1
  filter                            null
  sortCriteria                      null
  threshold                         null
  workitemArrayHdl                  1
  showAllObjectNames                true
  xpFmcException                    FMC_OK
End

ExecutionService.queryWorkItems
  executionServiceHdl               1
  filter                            "OWNER = 'ADMIN'"
  sortCriteria                      null
  threshold                         null
  workitemArrayHdl                  2
  showAllObjectNames                true
  xpFmcException                    FMC_OK
End

ExecutionService.queryWorkItems
  executionServiceHdl               1
  filter                            null
  sortCriteria                      "NAME ASC"
  threshold                         5
  workitemArrayHdl                  3
  showAllObjectNames                true
  xpFmcException                    FMC_OK
End

ExecutionService.queryWorkItems
  executionServiceHdl               1
  filter                            "NAME = 'Container_1'"
  sortCriteria                      "NAME ASC"
  threshold                         null
  workitemArrayHdl                  4
  showAllObjectNames                true
  xpFmcException                    FMC_OK
End

ExecutionService.queryWorkItems
  executionServiceHdl               1
  filter                            "NAME LIKE 'C*'"
  sortCriteria                      "RECEIVED_TIME ASC"
  threshold                         null
  workitemArrayHdl                  5
  showAllObjectNames                true
  xpFmcException                    FMC_OK
End

ExecutionService.queryWorkItems
  executionServiceHdl               1
  filter                            "NAME LIKE '*ect?redit?nf*'"
  sortCriteria                      "NAME ASC"
  threshold                         null
  workitemArrayHdl                  6
  showAllObjectNames                true
  xpFmcException                    FMC_OK
End

ExecutionService.queryWorkItems
  executionServiceHdl               1
  filter                            "NAME < 'C'"
  sortCriteria                      "NAME ASC"
  threshold                         null
  workitemArrayHdl                  7
  showAllObjectNames                true
  xpFmcException                    FMC_OK
End

WorkItem.owner
  workItemArrayHdl                  7
End

WorkItem.state
  workItemArrayHdl                  7
End

WorkItem.description
  workItemArrayHdl                  7
End


Tool.commentToOutput
  comment
"
FDL extract for the data structure variables (Container members) in a 'Description field':
...
STRUCTURE 'PersonInfo'
  'FirstName': STRING;
  'LastName': STRING;
END 'PersonInfo'

STRUCTURE 'CreditInfo'
  'CreditRequestor': 'PersonInfo';
  ...
END 'CreditInfo'
...
  PROGRAM_ACTIVITY 'AssessRisk' ( 'CreditInfo', 'CreditInfo' )
    DESCRIPTION 'Credit request for %CreditRequestor.FirstName% %CreditRequestor.LastName%'
    ...
see filter below
"
  toStandardError            false
End


ExecutionService.queryWorkItems
  executionServiceHdl               1
  filter
  "NAME ='AssessRisk' AND OWNER = 'ADMIN' AND DESCRIPTION LIKE '*Hugo Demoman' AND STATE IN (READY,RUNNING)"
  sortCriteria                      "NAME ASC"
  threshold                         null
  workitemArrayHdl                  8
  showAllObjectNames                true
  xpFmcException                    FMC_OK
End

WorkItem.description
  workItemArrayHdl                  8
End

ExecutionService.logoff
  executionServiceHdl               1
  xpFmcException                    FMC_OK
End


Result

MQSeries Workflow 3.2.2 Java Generic API Test Tool (JGATT),
Driver v322, Hotfix <2>
Test case: example23.dat
2000-10-19 18:04:15.86 Europe/Berlin
============================================================================
Operating system:              Windows NT
Operating system version:      4.0
Operating system architecture: x86
Java version:                  1.2.2
User account name:             kurtfle
============================================================================
Command Line Arguments:
-i=example23.dat (TestCase)
-o=example23.log (Result)
-d
============================================================================
+++> 
============================================================================
===> 
Parsing the input file ...
===> 1182 msec
============================================================================
Agent.Agent
parameter: agentHdl                                = 1
============================================================================
Agent.setLocator
parameter: agentHdl                                = 1
parameter: locator                                 = LOC_LOCATOR = 4
============================================================================
Agent.setName
parameter: agentHdl                                = 1
parameter: name                                    = ""
============================================================================
Agent.versionInfo
parameter: agentHdl                                = 1
..........Report............................................................
version  = 3
release  = 2
modlevel = 2
build    = @(#)MQSeries Workflow 3.2.2 Java core library, Driver v322
============================================================================
Agent.locate
parameter: agentHdl                                = 1
parameter: systemGroup                             = "FMCGRP"
parameter: system                                  = "FMCSYS"
parameter: executionServiceHdl                     = 1
..........RC Report.........................................................
AcException = none = 0
XpException = none
+++OK+++
============================================================================
ExecutionService.logon2
parameter: executionServiceHdl                     = 1
parameter: userID                                  = "ADMIN"
parameter: password                                = "password"
parameter: sessionMode                             = PRESENT_HERE
parameter: absenceIndicator                        = NOT_SET
..........RC Report.........................................................
AcException = none = 0
XpException = none
+++OK+++
============================================================================
ExecutionService.queryWorkItems
parameter: executionServiceHdl                     = 1
parameter: filter                                  = null
parameter: sortCriteria                            = null
parameter: threshold                               = null
parameter: workitemArrayHdl                        = 1
..........RC Report.........................................................
AcException = none = 0
XpException = none
+++OK+++
..........Object Names Report...............................................
array size = 32
0) CollectCreditInformation
1) AssessRisk
2) AssessRisk
3) AssessRisk
4) Mapping_CICS
5) Process
6) Program_2
7) Container_1
8) Mapping_CICS
9) Process
10) Program_2
11) Container_1
12) Mapping_CICS
13) Process
14) Program_2
15) Container_1
16) Mapping_CICS
17) Process
18) Program_2
19) Container_1
20) Mapping_CICS
21) Process
22) Program_2
23) Container_1
24) Mapping_CICS
25) Process
26) Program_2
27) Container_1
28) Container_1
29) Mapping_CICS
30) Process
31) Program_2
============================================================================
ExecutionService.queryWorkItems
parameter: executionServiceHdl                     = 1
parameter: filter                                  = "OWNER = 'ADMIN'"
parameter: sortCriteria                            = null
parameter: threshold                               = null
parameter: workitemArrayHdl                        = 2
..........RC Report.........................................................
AcException = none = 0
XpException = none
+++OK+++
..........Object Names Report...............................................
array size = 7
0) CollectCreditInformation
1) AssessRisk
2) AssessRisk
3) AssessRisk
4) Mapping_CICS
5) Process
6) Program_2
============================================================================
ExecutionService.queryWorkItems
parameter: executionServiceHdl                     = 1
parameter: filter                                  = null
parameter: sortCriteria                            = "NAME ASC"
parameter: threshold                               = 5
parameter: workitemArrayHdl                        = 3
..........RC Report.........................................................
AcException = none = 0
XpException = none
+++OK+++
..........Object Names Report...............................................
array size = 5
0) AssessRisk
1) AssessRisk
2) AssessRisk
3) CollectCreditInformation
4) Container_1
============================================================================
ExecutionService.queryWorkItems
parameter: executionServiceHdl                     = 1
parameter: filter                                  = "NAME = 'Container_1'"
parameter: sortCriteria                            = "NAME ASC"
parameter: threshold                               = null
parameter: workitemArrayHdl                        = 4
..........RC Report.........................................................
AcException = none = 0
XpException = none
+++OK+++
..........Object Names Report...............................................
array size = 7
0) Container_1
1) Container_1
2) Container_1
3) Container_1
4) Container_1
5) Container_1
6) Container_1
============================================================================
ExecutionService.queryWorkItems
parameter: executionServiceHdl                     = 1
parameter: filter                                  = "NAME LIKE 'C*'"
parameter: sortCriteria                            = "RECEIVED_TIME ASC"
parameter: threshold                               = null
parameter: workitemArrayHdl                        = 5
..........RC Report.........................................................
AcException = none = 0
XpException = none
+++OK+++
..........Object Names Report...............................................
array size = 8
0) Container_1
1) Container_1
2) Container_1
3) Container_1
4) Container_1
5) Container_1
6) Container_1
7) CollectCreditInformation
============================================================================
ExecutionService.queryWorkItems
parameter: executionServiceHdl                     = 1
parameter: filter                                  = "NAME LIKE '*ect?redit?nf*'"
parameter: sortCriteria                            = "NAME ASC"
parameter: threshold                               = null
parameter: workitemArrayHdl                        = 6
..........RC Report.........................................................
AcException = none = 0
XpException = none
+++OK+++
..........Object Names Report...............................................
array size = 1
0) CollectCreditInformation
============================================================================
ExecutionService.queryWorkItems
parameter: executionServiceHdl                     = 1
parameter: filter                                  = "NAME < 'C'"
parameter: sortCriteria                            = "NAME ASC"
parameter: threshold                               = null
parameter: workitemArrayHdl                        = 7
..........RC Report.........................................................
AcException = none = 0
XpException = none
+++OK+++
..........Object Names Report...............................................
array size = 3
0) AssessRisk
1) AssessRisk
2) AssessRisk
============================================================================
WorkItem.owner
parameter: workitemArrayHdl                        = 7
..........ValueReport.......................................................
A ...Refresh() will be applied to each object.
0) AcValue = "ADMIN"
1) AcValue = "ADMIN"
2) AcValue = "ADMIN"
============================================================================
WorkItem.state
parameter: workitemArrayHdl                        = 7
..........ValueReport.......................................................
A ...Refresh() will be applied to each object.
0) AcValue = CHECKED_OUT
1) AcValue = READY
2) AcValue = READY
============================================================================
WorkItem.description
parameter: workitemArrayHdl                        = 7
..........ValueReport.......................................................
A ...Refresh() will be applied to each object.
0) AcValue = "Credit request for Hans Mueller"
1) AcValue = "Credit request for Hugo Demoman"
2) AcValue = "Credit request for Renate Boss"
============================================================================
Tool.commentToOutput

FDL extract for the data structure variables (Container members) in a 'Description field':
STRUCTURE 'PersonInfo'
  'FirstName': STRING;
  'LastName': STRING;
END 'PersonInfo'

STRUCTURE 'CreditInfo'
  'CreditRequestor': 'PersonInfo';
  ...
END 'CreditInfo'
...
  PROGRAM_ACTIVITY 'AssessRisk' ( 'CreditInfo', 'CreditInfo' )
    DESCRIPTION 'Credit request for %CreditRequestor.FirstName% %CreditRequestor.LastName%'
    ...
see filter below

============================================================================
ExecutionService.queryWorkItems
parameter: executionServiceHdl                     = 1
parameter: filter                                  = "NAME ='AssessRisk' AND OWNER = 'ADMIN' AND DESCRIPTION LIKE '*Hugo Demoman' AND STATE IN (READY,RUNNING)"
parameter: sortCriteria                            = "NAME ASC"
parameter: threshold                               = null
parameter: workitemArrayHdl                        = 8
..........RC Report.........................................................
AcException = none = 0
XpException = none
+++OK+++
..........Object Names Report...............................................
array size = 1
0) AssessRisk
============================================================================
WorkItem.description
parameter: workitemArrayHdl                        = 8
..........ValueReport.......................................................
A ...Refresh() will be applied to each object.
0) AcValue = "Credit request for Hugo Demoman"
============================================================================
ExecutionService.logoff
parameter: executionServiceHdl                     = 1
..........RC Report.........................................................
AcException = none = 0
XpException = none
+++OK+++
============================================================================
====== Test case ended normally ============================================