group by custom field in List view empty

[scott barnard1]

Hi All

I have a table in an application that I have created from the studio.

I used a template and it generates a lot of the base tables extending the sm order/task capability. It also generates table names from the application name. Column names get generated off the table name.

When I create records and view the list of created records all is good.

When I try to group by a field I have added the results just come back in groups but the labels are empty. My field is a choice list and the values are visible in the records etc.

A previous post by Cory suggested that the column names need to be below 30 characters and that this was fixed in Helsinki patch 6.

I am using Jakarta patch 2 and it's still evident so I guess there may be some issue still.

Anybody else found a workround for this, or a easy method of renaming the columns?

Regards

[andrew_venables]

A screenshot would be really helpful.

[scott barnard1]

Couple of shots of list and then as grouped

and grouped

[scott barnard1 · Accepted solution]

In the end I gave up trying to get it to work

I got around the situation by creating new form fields and modifying their names to very short values. This worked.

Not a great fix but I guess you just need to be brief with your column names