Working with QueryAndQueryBySQL

The QueryAndQueryBySQL project contains a process that shows how to use ActiveMatrix BusinessWorks Plug-in for ActiveSpaces to query the rows and compare the result.

The process is designed with the following activities:



The following table describes the activities in this process:

Activity Description
Put Stores a batch of rows into the table.
QueryBySQL Queries rows in the table with the SQL sentence select * from querytable where id>0.
Query Queries rows in the table with filter id>0.
Map Data-1 Changes the format of result data 1.
Map Data Changes the format of result data.
Render XML Changes the result data to XML.
Render XML-1 Changes the result data to XML 1.
Java Code Compares the two XML strings.