How to sort the data in edit Data Grid inside UiPath Apps

Help Apps
,
1

Hi folks,

Need to know, on how we could Sort the data which is loading from a DataService and is being shown in Edit Data Grid.

I want the latest record which was created to be displayed first.
@Arvind_Kumar1 @Parth_Doshi : Do you guys have any idea on how to do this?

Thanks
Aditya

2

Hello @adiijaiin ,

Edit grid do not support Sort into Query builder however after generating your query you can modify the sort filter but remember once you modify it again you will not be able to use into Query builder.

Here is a screen shot ,

See highlighted screen, By default this sort based on sort column, how ever you can write a If else condition on this saying if sort column is nothing when pay load then sort by CreatedDate ( you can choose your field name) and if click then sort by sort column again into else condition.

image
image1239×437 56.7 KB

Thanks,
Arvind

3

Hi @Arvind_Kumar1

Even After adding this it’s not sorting it on the latest records first, and column that I have used is a System built-in field called “UpdateTime”, here’s the screenshot for the same.

image
image827×593 29.1 KB

4

Are you sure you have correct column name?

5

UpdateTime is the built-in field name, in Data Service, same as CreatedBy is the name of System built-in field.

6

Hello @adiijaiin ,

I just looked at my end and its working.

image
image1125×398 28.3 KB

7

Is this updatedDate a column that you created?

8

@adiijaiin ,

Its default column.

9

hi @Arvind_Kumar1

This is the default column Name that is there in my DataService.

image
image1125×403 16.3 KB

which I have put in

image
image827×593 29.1 KB

10

Can you try with other custom column if this is working?

11

Hi @Arvind_Kumar1

Tried with other columns as well, didn’t work.

12

Replace your Sort function with the below. “UpdateTime” is the default column in Entity
New SortOption(){addSortOption(“UpdateTime”, Not(False))}