Query record directly from entity

Hello Guys,

I am working on UiPath app use case, it has field related to passport like nationality, passport expiry date etc. i have candidatepassport details entity it has all the all data which we need to show in apps fields.

Challenge : i have search field in apps , when i enter email id in search input and click on search icon, based on email id passed as input i need to fetch values directly from the entity using email Id . and show that values in UiPath apps input fields.

Request help on this how to query and get the result.

thanks
Shiva

You can achieve this in UiPath Apps by using Entity Rules.
Create a rule on the Search button/icon click, and use Get Entity Records on your CandidatePassportDetails entity. Apply a filter like:

EmailId = App.Input.SearchEmail

Then Store the result in a local app variable and bind your App input fields (Nationality, Passport Expiry Date, etc.) directly to the attributes of that variable.

@MohammedShabbir do you mean to say run a process in backgroud for this and get the data ?. am i reading it correctly?.

@shivappa.katti1

use query builder to form the filter and get the data you need

No need to run process ..you can use set variable in events rules

cheers

you don’t need to run a process for this use case, On the Search button/icon click, create an Event Rule and use Get Entity Records.
In the Query Builder, add a filter like EmailId equals App.Input.SearchEmail

Then store the output in a local app variable using Set variable.

@MohammedShabbir i tried but i didnt find get entity record in the list ,

Hi @Anil_G i have tried it but i didnt find the get entity records in list.

make use of Query Entity Records

Go to the Rules panel, then click Add Rule, Choose Value → Query / Data source, Then select your Entity and use the Query Builder there to filter with your condition i.e EmailId equals App.Input.SearchEmail

Apps - The Query builder

@shivappa.katti1

this how you would do it

Select query builder and filter and save the records to variable

cheers

Hi @shivappa.katti1

Use an Entity Query in UiPath Apps.
On search button click, filter the entity with Email = input email, then bind the returned record fields to the app input fields.