Query Parameter Examples

This topic provides query examples.

Using boolean types: 

   SELECT * FROM process WHERE (isBalanceFull = TRUE );
   SELECT * FROM process WHERE (isBalanceFull = FALSE );

Using numeric types: 

   SELECT * FROM process WHERE (Payment > 3.569 );
   SELECT * FROM process WHERE (Payment < 50 );

Using complex conditions: 

   SELECT * FROM process WHERE (DEFINITION.NAME = ‘Process1’ OR
   DEFINITION.NAME = ‘Process2’ ) ORDER BY name DESC;
   SELECT * FROM process WHERE (DEFINITION.NAME = ‘Process1’ OR
   DEFINITION. NAME = ‘Process2’) ORDER BY DEFINITION. NAME ASC;
   SELECT * FROM process WHERE (INSTANCE.ID > 20 AND MODULE.NAME
   = ‘ModuleA’ AND order_amount > 10000) ORDER BY INSTANCE.ID DESC;
   SELECT * FROM process WHERE (INSTANCE.ID > 20 AND INSTANCE.ID
   < 100 ORDER BY INSTANCE.ID DESC;
   SELECT * FROM process WHERE (MODULE.NAME like 'module%');
   SELECT * FROM process WHERE INSTANCE.START_DATE BETWEEN TS
   '2008-06-20T10:30:20Z' AND TS '2008-06-20T10:52:20Z';
   SELECT MODULE.NAME, INSTANCE.VERSION, INSTANCE.NAME,
   INSTANCE.DESCRIPTION FROM process WHERE (MODULE.NAME
   = 'module_1' OR MODULE.NAME = 'module_2') ORDER BY MODULE.NAME
   DESC;
   SELECT * FROM process WHERE (isBalanceZero = TRUE) ORDER BY
   INSTANCE.ID DESC;