Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Appendix A Provided Services : Daily Transaction Reports Summary Based on User’s Criteria

Daily Transaction Reports Summary Based on User’s Criteria
The Daily Transaction Reports Summary example service accepts an input SQL query and returns the results in the form of a generic output structure.
This example service is used for the tutorial. To learn more, see Chapter 2, Tutorial — Getting Started.
What Is the Service Used For
The Daily Transaction Reports Summary example service allows users to modify the handlers and the schema at their own risk. It can be used for executing arbitrary SQL queries against the TIBCO BusinessConnect audit tables and building reports out of them.
How the Service Works
There are two TIBCO ActiveMatrix BusinessWorks processes shipped with this service for two usage scenarios: to get a list of distinct trading partners transacted between certain dates; or to get a list of transactions for a particular trading partner for the X12 protocol between certain dates (a list of summary rows).
To provide a mechanism for executing queries against the TIBCO BusinessConnect audit tables, the input SQL statement can be specified using the select and where arguments in the input schema. The query output is returned in a generic tabular structure defined by the response schema.
The top level result set element is a sequence of rows, where each row contains a set of column/value pairs:
The column is the column name in the SQL query
The value is the actual value for that column for that particular row

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved