Hi all,
I am using a view as the data source for an entity-backed record. I have a field "Student Full Name" in the view, which I am getting by concatenating "Student First Name" and "Candidate Last Name" using the function concat("studLastNm", ", ", "studFirstNm").
So, for example, in the view and record the student full name will be displayed as "Brewer, Allan". There are no null or empty values in "Student Last Name". My CDT for view has primary key. When I sort the view for "Student Full Name" in the cloud database, the values are getting sorted properly. But the same in the record gives the following error:
The alias [[field=STUDENT_FULL_NM, ascending=true]] cannot be used because it contains illegal characters. The alias must contain only letters, numbers, and underscores, and must start with a letter. (APNX-1-4203-009)
Does the record sorting not work when the field has commas?
Can someone help me to fix this issue? Thanks.
Discussion posts and replies are publicly visible
@Brinda,
Can you share the initial sort configuration you have for the Grid in Record Types and also sort configuration of the grid column "Student Full Name"?
It seems like you might have used rf!STUDENT_FULL_NM or something similar to that instead of just "STUDENT_FULL_NM "
I have the same idea. Please check that.
Thank you Stefan. It is working now.