MENU
Contents x
Fetch Distinct Values
  • 31 Oct 2023
  • 1 Minute to read
  • Print
  • Dark
Contents

Have Questions?  Need Expert Answers?  JOIN LUNCH N' LEARNS!

Fetch Distinct Values

  • Updated on 31 Oct 2023
  • 1 Minute to read
Article summary

Step Details

Introduced in Version4.0.0
Last Modified in Version5.12.0
LocationIntegration > Entity Framework 

The Fetch Distinct Values step will get the distinct values in a Data Structure.


Properties

Inputs

PropertyDescriptionData Type
Type NameDefine which Type is being fetched by the step.     ---
Fetch Deleted EntitiesWill fetch entities that were deleted    ---
Show Path For One ResultWill add an outcome path for a single result    ---
Combine Filters Using ANDThis setting will combine the filters set up in the Fetch Criteria section using AND---
Selected FieldThe desired field to get values from---
Sort Order FieldDefines how the values are sorted---
Fetch CriteriaAllows the user to add new Fetch Criteria by using the Field Name to construct a query-like statement for Decisions to interpret automatically within the step. More than one Fetch Criteria can be configured.     ---
Read uncommitted dataEnabling this feature allows Decisions to read entities in a database that have been changed but not saved.     ---
Respect PermissionsIf enabled, the step will not fetch entities until the user has the minimum 'CanUse' permission for that folder.---

Outputs

PropertyDescriptionData Type
Field ResultsValues fetched from the Data StructureList of [Data Type]

Example Inputs and Outputs

Type NameSelected FieldOutput
Transaction _Category"Expenses", "Finance"
NullEmptyEXCEPTION MESSAGE

Common Errors

Value cannot be null

If the Selected FIeld value is not selected, an error will occur.

To correct this, ensure that a field from the data type is selected.

Exception Message:

Exception Stack Trace: DecisionsFramework.Design.Flow.ErrorRunningFlowStep: Error running step Fetch Distinct Values 1[FetchDistinctValues] in flow [Flow 10]: not found, please fix the mapping.
 ---> DecisionsFramework.LoggedException: not found, please fix the mapping. at DecisionsFramework.Design.Flow.CoreSteps.DataBase.AbstractTypeStep.GetFieldName(String ormFieldName
 at DecisionsFramework.Design.Flow.CoreSteps.DataBase.FetchDistinctValues.Run(StepStartData data
 at DecisionsFramework.Design.Flow.FlowStep.RunStepInternal(String flowTrackingID, String stepTrackingID, KeyValuePairDataStructure[] stepRunDataValues, AbstractFlowTrackingData trackingData
 at DecisionsFramework.Design.Flow.FlowStep.Start(String flowTrackingID, String stepTrackingID, FlowStateData data, AbstractFlowTrackingData trackingData, RunningStepData currentStepData)
   --- End of inner exception stack trace ---
C#

Step Changes

DescriptionVersionDeveloper Task
Added the "Respect Permissions" setting to the Fetch Entities, Get Count, Fetch Distinct Values, Delete Entities, and Update Entities steps. 8.16[DT-033517]
Was this article helpful?
What's Next
Decisions
Resources
Organization
Connect