Global business rules – ready-to-use examples

Several ready-to-use examples of global business rules that you can create once and use in everyday work with WEBCON BPS when creating and developing business processes.

Count attachments

The rule returns number of attachments of given category (all category if ‘ALL’ parameter is passed).

SELECT Count(1) 
FROM   wfdataattachmets 
WHERE  att_wfdid = {WFD_ID} 
       AND att_isdeleted = 0 
       AND ( dbo.Clearwfelemid(att_attribute1) = '{BRP:18}' 
              OR '{BRP:18}' = 'ALL' )

Count item list rows

The rule returns number of rows of given item list form field.

SELECT Count(1) 
FROM   wfelementdetails 
WHERE  det_wfdid = {WFD_ID} 
       AND det_wfconid = '{BRP:17}'

Instance was in step

The rule returns information whether the instance was in the given step or not.

Caution: Note that in my business rule, the current step is not treated as a step where the instance has already been. If you want it to be treated as such, you must remove the restriction from the SQL query.

Path was used

The rule returns whether the instance has passed the given path.

IF '{BRP:15}' IN (SELECT item 
                  FROM   dbo.Splittotable((SELECT wfd_historypaths 
                                           FROM   wfelements 
                                           WHERE  wfd_id = {WFD_ID}), ';')) 
  SELECT 1 
ELSE 
  SELECT 0