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]

Do you have labels associated with each of the choice list values?

The Group by will group based on the value in the field and then display the label. Its possible to create records with choice list values that don't exist so that could be the cause.

Are you able to share a screenshot?

[scott barnard1]

Hi Andrew

Thanks for the response. All the choices have values and labels. In the list view they are fine it's just when I try to use the Group by function or run a report using that field and try to use the group by option

Regards

[Midhun1]

Hi Scott,

Is there any business rule configured to populate values for that field .

How did you configure choices ?

[scott barnard1]

Hi Midhun

There's no BR on that field. It's populated manually

Regards