Skip to Content (Press Enter)
UserImage.jpg
Lovish Goyal
2125Views
8Comments
Solved
list column sorting
Question

i have one column on table which is not coming from db table . Actually this is evaluated from expression.  So how i can sort it?

0
0
15 Dec 2017
Copy Link
2020-02-28 09-46-54
Eduardo Jauch
Solution

Hi Lovish,

In this case, none. When it is a calcualted column, you give it a name and use only its name.

For example, if you do an aggregate GetUsers with User entity, and wants to sort by name, you would use {User}.[Name] in the ListSort_Column widget, as Name is an attribute of entity user.

But if you have a Calculate field to concatenate Name and email, like this: User.Name + " (" + User.EMail + ")", And you give it the name UserInfo, in the ListSort_Column widget you would use simply UserInfo, no entity name (as it isn't an entity attribute) and no [ ] around the name of the attribute, because it is a calculated field.

Just use the name you gave.

Cheers,
Eduardo Jauch

See solution in context
1
0
17 Dec 2017
Copy Link
UserImage.jpg
osuser

Eduardo Jauch wrote:

Hi Lovish,

In this case, none. When it is a calcualted column, you give it a name and use only its name.

For example, if you do an aggregate GetUsers with User entity, and wants to sort by name, you would use {User}.[Name] in the ListSort_Column widget, as Name is an attribute of entity user.

But if you have a Calculate field to concatenate Name and email, like this: User.Name + " (" + User.EMail + ")", And you give it the name UserInfo, in the ListSort_Column widget you would use simply UserInfo, no entity name (as it isn't an entity attribute) and no [ ] around the name of the attribute, because it is a calculated field.

Just use the name you gave.

Cheers,
Eduardo Jauch

Hi,

I am doing the same but still getting this error: 'Current' found in 'Order By' parameter is an invalid Entity.

As you can see I have "Approval" column in aggregate and using same name in List_SortColumn.

 


0
0
09 Mar 2018
Copy Link
2020-02-28 09-46-54
Eduardo Jauch

Pratima Solanki wrote:

Eduardo Jauch wrote:

Hi Lovish,

In this case, none. When it is a calcualted column, you give it a name and use only its name.

For example, if you do an aggregate GetUsers with User entity, and wants to sort by name, you would use {User}.[Name] in the ListSort_Column widget, as Name is an attribute of entity user.

But if you have a Calculate field to concatenate Name and email, like this: User.Name + " (" + User.EMail + ")", And you give it the name UserInfo, in the ListSort_Column widget you would use simply UserInfo, no entity name (as it isn't an entity attribute) and no [ ] around the name of the attribute, because it is a calculated field.

Just use the name you gave.

Cheers,
Eduardo Jauch

Hi,

I am doing the same but still getting this error: 'Current' found in 'Order By' parameter is an invalid Entity.

As you can see I have "Approval" column in aggregate and using same name in List_SortColumn.

 


Hello Pratma.

Try to logout and login.
The message says to me that you used a {Current}.... before, and changed to Approval, but your session is still valid and he does not change the previous value because of that.

Usually logout/login solves this problem.

Cheers.


0
0
09 Mar 2018
Copy Link
2020-02-28 09-46-54
Eduardo Jauch

Hi lovish,

If is an expression evaluated in table in screen, you can't. Not without JavaScript and would never be perfect.

If you can, move it to a calculated column in the aggregate, and now this column can be sorted.

Cheers,

Eduardo Jauch

1
0
15 Dec 2017
Copy Link
UserImage.jpg
Lovish Goyal

Eduardo Jauch wrote:

Hi lovish,

If is an expression evaluated in table in screen, you can't. Not without JavaScript and would never be perfect.

If you can, move it to a calculated column in the aggregate, and now this column can be sorted.

Cheers,

Eduardo Jauch


which entity we have to mention for that aggregated column? 

0
0
17 Dec 2017
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP

Alternatively, you can use ListSort to sort the list, but this has some drawbacks, like not working nicely together with the RichWidgets column sort, and not working well if you have paginated data and don't want to retrieve (and calculate) the data for all pages.

1
0
15 Dec 2017
Copy Link
2020-02-28 09-46-54
Eduardo Jauch
Solution

Hi Lovish,

In this case, none. When it is a calcualted column, you give it a name and use only its name.

For example, if you do an aggregate GetUsers with User entity, and wants to sort by name, you would use {User}.[Name] in the ListSort_Column widget, as Name is an attribute of entity user.

But if you have a Calculate field to concatenate Name and email, like this: User.Name + " (" + User.EMail + ")", And you give it the name UserInfo, in the ListSort_Column widget you would use simply UserInfo, no entity name (as it isn't an entity attribute) and no [ ] around the name of the attribute, because it is a calculated field.

Just use the name you gave.

Cheers,
Eduardo Jauch

1
0
17 Dec 2017
Copy Link
UserImage.jpg
osuser

Eduardo Jauch wrote:

Hi Lovish,

In this case, none. When it is a calcualted column, you give it a name and use only its name.

For example, if you do an aggregate GetUsers with User entity, and wants to sort by name, you would use {User}.[Name] in the ListSort_Column widget, as Name is an attribute of entity user.

But if you have a Calculate field to concatenate Name and email, like this: User.Name + " (" + User.EMail + ")", And you give it the name UserInfo, in the ListSort_Column widget you would use simply UserInfo, no entity name (as it isn't an entity attribute) and no [ ] around the name of the attribute, because it is a calculated field.

Just use the name you gave.

Cheers,
Eduardo Jauch

Hi,

I am doing the same but still getting this error: 'Current' found in 'Order By' parameter is an invalid Entity.

As you can see I have "Approval" column in aggregate and using same name in List_SortColumn.

 


0
0
09 Mar 2018
Copy Link
2020-02-28 09-46-54
Eduardo Jauch

Pratima Solanki wrote:

Eduardo Jauch wrote:

Hi Lovish,

In this case, none. When it is a calcualted column, you give it a name and use only its name.

For example, if you do an aggregate GetUsers with User entity, and wants to sort by name, you would use {User}.[Name] in the ListSort_Column widget, as Name is an attribute of entity user.

But if you have a Calculate field to concatenate Name and email, like this: User.Name + " (" + User.EMail + ")", And you give it the name UserInfo, in the ListSort_Column widget you would use simply UserInfo, no entity name (as it isn't an entity attribute) and no [ ] around the name of the attribute, because it is a calculated field.

Just use the name you gave.

Cheers,
Eduardo Jauch

Hi,

I am doing the same but still getting this error: 'Current' found in 'Order By' parameter is an invalid Entity.

As you can see I have "Approval" column in aggregate and using same name in List_SortColumn.

 


Hello Pratma.

Try to logout and login.
The message says to me that you used a {Current}.... before, and changed to Approval, but your session is still valid and he does not change the previous value because of that.

Usually logout/login solves this problem.

Cheers.


0
0
09 Mar 2018
Copy Link
2014-10-21 20-15-17
Alberto Ferreira

Hi Lovish


If Eduardo answer your question, mark it as correct. That will help other to find answers to similar questions.


Thanks

0
0
18 Dec 2017
Copy Link
UserImage.jpg
osuser

Thank You Eduardo, It solved my problem :)

1
0
09 Mar 2018
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.