Data Service Activities Query Records not by ID

Help Studio
, ,
1

I created a new entity. I am going to put records in then I want to query the data to pull back a specific record to check it’s value. This is in an RPA automation, not a UiPath App.
At the time I want to pull the record back I don’t know the system assigned ID at that point. There doesn’t seem to be an activity where I can search by any column other than the ID. This means I would have to use the query entity records activity to retrieve ALL the records and search by the column I want to search for after this. Also, I can’t even pull back all the records in one go and will have to loop and skip till I have them all. This seems very inefficient way of doing things. Am I missing something?

2

@ewanc1

In query entity records you have a filter which works in any column you need…so whichever column and value you want can be added in the filter and the related records are retrieved

Cheers

3

Ah ok, I see you have to choose the entity before the query box appears, not sure that is intuitive, but solves my problem thanks, will give it a try!!

image
image450×195 3.33 KB

1 Like
4

@ewanc1

Happy Automation

Cheers

5

Getting an error when trying to activate the filter, any ideas?

23.10.9+Branch.support-v23.10.Sha.4085ef6d4161914c53f76268c23847e5401b7ed4

An exception was thrown while activating UiPath.Studio.Plugin.Workflow.Net6Windows.Widgets.FilterWidget.FilterViewModel.

Error: System.Exception: An exception was thrown while activating UiPath.Studio.Plugin.Workflow.Net6Windows.Widgets.FilterWidget.FilterViewModel.
—> System.Exception: An exception was thrown while invoking the constructor ‘Void .ctor(UiPath.Studio.Plugin.Workflow.Presentation.IWidgetViewModel, System.Func4[System.Type,System.Activities.DesignViewModels.DesignFilterCondition,UiPath.Studio.Plugin.Workflow.Presentation.IWidgetViewModel,UiPath.Studio.Plugin.Workflow.Net6Windows.Widgets.FilterWidget.FilterConditionViewModel], System.Func4[UiPath.Studio.Plugin.Workflow.Net6Windows.Widgets.FilterWidget.FilterTypeInformation,System.Activities.DesignViewModels.DesignFilterCondition,UiPath.Studio.Plugin.Workflow.Presentation.IWidgetViewModel,UiPath.Studio.Plugin.Workflow.Net6Windows.Widgets.FilterWidget.DynamicFilterConditionViewModel])’ on type ‘FilterViewModel’.
—> System.Exception: Sequence contains no elements
at System.Linq.ThrowHelper.ThrowNoElementsException()
at System.Linq.Enumerable.First[TSource](IEnumerable1 source) at System.Activities.DesignViewModels.FilterSettings.GetFirstCondition() at System.Activities.DesignViewModels.GenericFilterWidgetBuilder1.<>c__DisplayClass42_0.b__0()
at System.Activities.DesignViewModels.DesignFilterCollection.AddNew()
at UiPath.Studio.Plugin.Workflow.Net6Windows.Widgets.FilterWidget.BaseFilterViewModel.AddNewConditionInternal(Func2 createFilterCondition, DesignFilterCondition condition, String groupId) at UiPath.Studio.Plugin.Workflow.Net6Windows.Widgets.FilterWidget.FilterViewModel.AddNewCondition(DesignFilterCondition condition, String groupId) at UiPath.Studio.Plugin.Workflow.Net6Windows.Widgets.FilterWidget.BaseFilterViewModel..ctor(IWidgetViewModel widgetViewModel, Func4 filterConditionViewModelFactory, Func4 dynamicFilterConditionViewModelFactory) at lambda_method515(Closure , Object[] ) at Autofac.Core.Activators.Reflection.BoundConstructor.Instantiate() --- End of inner exception stack trace --- at Autofac.Core.Activators.Reflection.BoundConstructor.Instantiate() at Autofac.Core.Activators.Reflection.ReflectionActivator.ActivateInstance(IComponentContext context, IEnumerable1 parameters)
at Autofac.Core.Activators.Reflection.ReflectionActivator.b__11_0(ResolveRequestContext ctxt, Action1 next) at Autofac.Core.Resolving.Middleware.ActivatorErrorHandlingMiddleware.Execute(ResolveRequestContext context, Action1 next)
— End of inner exception stack trace —
at Autofac.Core.Resolving.Middleware.ActivatorErrorHandlingMiddleware.Execute(ResolveRequestContext context, Action1 next) at Autofac.Core.Resolving.Middleware.SharingMiddleware.Execute(ResolveRequestContext context, Action1 next)
at Autofac.Core.Resolving.Middleware.CircularDependencyDetectorMiddleware.Execute(ResolveRequestContext context, Action`1 next)
at Autofac.Core.Resolving.ResolveOperation.GetOrCreateInstance(ISharingLifetimeScope currentOperationScope, ResolveRequest request)
at Autofac.Core.Resolving.ResolveOperation.ExecuteOperation(ResolveRequest request)
at lambda_method2485(Closure , IWidgetViewModel )
at UiPath.Studio.Plugin.Workflow.Presentation.FilterWidget.OpenFilterDialog()
at UiPath.Studio.Plugin.Workflow.Presentation.FilterWidget.OpenPopup(Object sender, RoutedEventArgs e)
at System.Threading.Tasks.Task.<>c.b__128_0(Object state)
at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler), HResult -2146233088

6

@ewanc1

Looks like the system activities compatibility issue…can you try to changes the system activities version and check

Cheers

7

Great thank you, that fixed it!!

1 Like
8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.