I am trying to create a list of students grouped by their parent. My parents are identified by a user_id, which is being used by the {{name}}. I would prefer to show the parents last name. If I group by parents last name, then the table groups all the students with the same last name under one heading, even though they have different parents.

Is there a way to group by user_id, but show parents last_name?

Thank you

Hello Mike,
I am afraid this is not possible as the {{$name}} binding used in the repeat region returns the user_id value.

Thank you for your response. I was thinking this was the way it worked.

Is there a way to get the user_id from the {{$name}} that I can use for a query
( select * from users where user_id = $name ) ?

I just ran into this problem too. In showing work orders grouped by user, it's logical to use user ID as the filter, but you'd still want to show the names. Also, grouping by name instead of user ID isn't a good idea because you can have many users with the same first or last name.

It would be REALLY helpful to be able to group by user ID, but show the first and last name of the user when listing work orders by user. No one identifies each other by user ID....

Hi Steve,
Could you please explain a little more detailed what exactly do you need to achieve?

Here's my test page:
www.reliable-service.com/sandbox/userCompletedWO.asp

This is a list of work orders, grouped by user ID, which is the right way to do this because user ID's are the only thing about users that are unique. The problem is that I want to show the user's first and last name where each user ID is shown above the records. I've put in the user's name at the end of each line to verify that it is grouping correctly.

Is there no way to show the user's name where the user ID is?

Hi Steve, Mike
sorry for the late reply i was just working on this and came across this topic.

Steve,
In your repeat regions change:

<p>{{$name}} -- </p>

To:

{{$value[0].nameF}} - {{$value[0].nameL}}

This will give you the First and Last names instead of the ugly id.

Mike it is the same for you - just use last_name:

{{$value[0].last_name}}

Better late than never I guess, but this works perfectly. Thank you Teodor!

One question:
Would it always be "value[0]." that needs to be added to accomplish this or would that value number ever be something other than a zero? Just curious...

Again, thank you. I love solutions!

Yes, it should always be {{$value[0].