How to add Or filter condition in uipath apps

Help Apps
,
1

Hi @Venkata_Rajendran

I try to filter uipath data services data in uipath apps

Just want to know how to pass or condition for to differentiate 2 conditions

I hope “, comma “ is considered as “and “condition in uipath apps

image
image1920×2560 419 KB

2

@Naveen.Ch ,

Advanced filter like Or , AND is not available at the moment. you can just add the filter comma separated multiple filter and that return only all satisfied rules.

Thanks,
Arvind

1 Like
3

Hi @Arvind_Kumar1

Thank you for the quick response

My condition should be like below

Var1=Var2 and Var3=Var4 or var3 = var5

How to do using comma separator to match above condition

4

Hi @Arvind_Kumar1

filter function support multiple conditions with comma separations.

filter(TravelRequest, [TravelRequest.Status, "=", SelectedStatusValue], [TravelRequest.ManagerEmailID, "=", ManagerEmailID])

Attached image looks correct. If it’s not working, Please check the values in those app variables. Also check if the data service has values for these conditions.

5

@Viswanath_Lekshmanan ,

Yes that is there but does it support advanced condition like AND, OR?

6

Hello @Naveen.Ch ,

Check below.

image
image1066×238 11 KB

7

Hi @Viswanath_Lekshmanan

Thank you for the response

But I am unable to add or condition , if I use comma separator that is considered as and condition

Like below

Entity.Var1=Var2 and entity.Var3=Var4 or entity.var3 = var5

8

@Naveen.Ch ,

Yes that’s correct, I said you OR condition is not supported right now.

1 Like
9

No. We don’t have support for OR operators now. All conditions are treated as AND by default.

10

@Viswanath_Lekshmanan @Arvind_Kumar1 @Venkata_Rajendran

Is it possible to click on table results and to display in detail window using uipath apps

how to disable the text field value once the firm is filled?

image
image1920×2560 411 KB

11

@Naveen.Ch ,

Yes you can create one page and on click open the page as pop and display the details view.

For disable you use below expression.

image

Thanks,
Arvind

1 Like
12
1 Like
13

Hi @Venkata_Rajendran @Arvind_Kumar1

I am able to show the details in the label based on above information

But my question is different, when the user select the record from table results which is populated from data service , I need to find the selected row and need to fetch the values of selected row and column (example : travel request id)

image
image1920×2560 740 KB

14

@Naveen.Ch ,

Please follow below.

  1. Go to table control
  2. Click on Event control
  3. Create rule
  4. Transfer selected table Value wherever is required as ID or other field

Thanks,
Arvind

15

@Arvind_Kumar1

I had created the rule but not sure how to get the selected row value

Currently I had set hard coded value

image
image1920×2560 462 KB

16

Hi @Naveen.Ch , I hope the below example helps.

  • I have 2 entities - Employee and Department entity
  • I have bound the employee entity to table control to fetch all values from the employee entity
  • Then I added a couple of text boxes to show the employee details of the selected row from the table. So when a row is clicked, it shows the details of the selected row
  • I also added another table that is bound to the department entity and has a filter to show the department based on the selected row in the employee table control
2 Likes
17

@Arvind_Kumar1 thank you for connecting and helping to fix issue

18

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