Grouping text area field

[ServiceBreez]

Is there anyway possible to group by a text area field?  Whether that is via datapage option or sql I need a way to do this. Thanks!

[Aether]

Hi @ServiceBreez,

The workaround to use a Text(6400)/Text area field in the Group By on the Tabular Report DataPage is to add a Formula field in your table and convert the Text(6400) field like this:
 

CONVERT (VARCHAR(255), [@field:6400])

And then use that newly added Formula field to Group By your Tabular report.

--------

As for the SQL, you can only use the Group By function if you are using SELECT with aggregation. Like this:
 

(SELECT COUNT(ID)
FROM TABLENAME
GROUP BY DATE)

I hope this helps!

[ServiceBreez]

Thank you WatashiwaJin!!

[ServiceBreez]

@WatashiwaJin I am attempting this now.  I've created the formula field.  But where can I select Group By?  It is not showing enable grouping on this field.

[ServiceBreez]

@WatashiwaJin - sorry - I realized that you are suggesting to create the formula field in the TABLE not in the datapage.  I am trying that now.

[ServiceBreez]

OK this worked as suggested, thank you!

One thing to note for others that may go down this path, it cuts off at 255 characters.  So grouping is possible (yay!), but unfortunately displaying the full text area is limited to 255.

 

Thanks again @WatashiwaJin