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.
Query
Queries rows in the table with filter
id>0.
Query by SQL
Queries rows in the table with the SQL sentence
select * from querytable where id>0.
