Date and age-based alerts: SugarBPM or scheduled job?

Damien Pochon said:

Develop a daily scheduled job that loops through the records and sets a flag if the criteria are met

Can a BPM be configured to set the flag instead of a scheduled job?

Damien Pochon said:

Develop a daily scheduled job that loops through the records and sets a flag if the criteria are met

Can a BPM be configured to set the flag instead of a scheduled job?

Here is the one example from our Sugar implementation experience:

1. Create a Note with the subject "Perpetual daily scan"
a) setup  start operator for Process definition to run on that note is created
b) add call LB Service in the Process Definition
c) add with the Wait element workflow, set it to wait for 1 day (hour, month, whatever cycle is needed) and make an infinite loop, so that the Process became perpetual and run according to the cycle 

2. Draw a Logic Builder flowchart as the implementation of the LB Service was mentioned in the Process Definition
 a) set criterion, e.g. "Check all accounts that have related meetings held within timeframe" - literally express the criteria 
 b) implement data transformation along with data manipulation/external calls etc e.g. "for each account found according to the criteria, calculate smth, make external API call, send Email,  or create related or non-related records"
 c) deploy flowchart implementation zip into Sugar with Module Loader

This allows to benefit from the perpetual daily/monthly/hourly/ect data scan performed by SugarBPM for processing let's say thousands of accounts in a single operation instead of creating thousands of processes per each account - and that all is achievable no code 

I'll make an example on ootb sandbox

Okay here is an example:

The Task is -  to provide a single regular perpetual Process that would check for New leads that were not updated to Assigned within t X minutes from registering in Sugar and assign them all to Jim

Step 1
Declare LB Service for Criteria check and data processing, provide X as a parameter (minutes_passed)

Step 2
Setup simple Process Definition and enable it

Step 3
Draw criterion and data processing for running Assignment Logic.
pls don't lower your expectations in Sugar automation, since there is no-code access to all the out-of-the-box and custom modules.
E.g. lets 
 - 0. Start processing, read parameter
 - 1. Set the Criterion for scanning data: Find all Leads in the New status
 - 2. Process them all: go through the list of leads found
 - 3. Transform data: if the Lead was created more than minutes_passed ago, then assign it to Jim and set the status to Assigned, then increment the counter of assigned Leads  
 - 4. Note statistics: Create Note record with a number of Leads automatically assigned

Folow the white line to read:



Step 4
Generate Sugar package in a click and install it via Module Loader.

Done!

Now, if you create a new note with subject "START PERPETUAL ASSIGNEMENT", that will run Process Definition and you will get a single instance of the perpetual Process



Whenever the process runs, it  checks the criterion, process leads, then creates the Note record with statistics:

 

That approach is a common Solution Architectural approach that we use while implementing Sugar and suggest it for Sugar Admins with no coding skills  - approach leverages SugarBPM capabilities along with core Sugar platform configurability without writing a line of custom code or involving costly developers for programming and supporting custom jobs

I hope this makes sense

Have a nice weekend!