Returns records by the values of the given fields. Similar to how users use Filters in Sugar interface, this operator returns records by provided filters. Records can be found only by direct fields’ values, it is not possible to provide ranges (e.g. greater than, after, max), instead of this filter out records after Retrieve Entities by Attributes using conditions and Branch.
inputs:
module – select directly in the operator module from the module list which records are needed.
- Required: yes
in the following dropdown(s) select a field name, by which value you want to filter records. As values you may use Constants or the output from Get Entity Attributes operator. At least one filter must be entered. Use “+” to add another field name. Between all selected fields there is logical AND.
- Required: yes
If it is needed to retrieve all records from some module, use the filter by field Deleted = 0
When records are needed to be filtered out by date using another date from Sugar field, use Get String From Date prior to Retrieve Entities by Attributes:
outputs:
entities – contains all found entities by the provided filters. Usually, this output is linked with input in For Each Entity.
entities number – the number of found records
single entity – contains one random record from the filtered ones. May be used if it is expected for only one record to be retrieved.