Simplest example
Simple create process query. This one is likely never going to be used, because 99% of the time, we are manipulating data into a database (entity). But is possible to do it on a process as well.Simple request
Updating data on a Database (Entity)
Simplest request for referencing an entity. In this scenario, someone from the HR deparment has the permission to add a new user, and the HR Manager has to approve that new user before it gets added to the Users databaseSimple request with entity_update
Entity connection example.
In this example, as the two steps on the process manipulate the same entity, the default logic is to connect these two steps into the same line being manipulated. This means that when the second step comes around, it will edit columns D and E for the line step 1 created on the Users database. If none of these variables are sent, all columns will be shownSimple request with autoFillEntityRelation
VIEW Entity Operation Example
If you want to view some data on the Entity, use the “VIEW” entityOperation. In this example, user is viewing all data from the Users entity, but only for columns “Name”, “Surname” and “Birthdate” He also has another entity update param on the same step that allows him to EDIT columns “Role” and “Experience” of any user.Simple request with autoFillEntityRelation
Simple request with autoFillEntityRelation
showColumns and hideColumns Example.
If a database is too big, you might want to hide or select some columns to be manipulated in each step. You can either set variableshowColumns or hideColumns which is an array of strings - each string being the columns of the entity you are manipulating.
If both showColumns and hideColumns are sent, only the hideColumns variable will be considered.
Simple request with autoFillEntityRelation
Advanced Entity connection example.
In this example, as the first two steps create new lines on the Users database, you might want to connect to one or the other on the third step. To define which step you would like step 3 to be connected to, simpliy send theautoFillEntityRelation variable with the step name you would like to connect to.
Advanced request with multiple entity manipulations
Required Variables for Step Deadlines
To define a deadline for the step, you need to send the following variables:Frequency Date Values
ThefrequencyDate parameter varies based on the selected frequency:
In this example, the Manager has 2 days to validate the work of the manager. And this is a process that repeats every week.
Define step deadline