DataGrid: Possibillity to show data type in the header

[hohnzy]

Is your feature request related to a problem or use case? Please describe. We are filling the datagrid with data comming from SQL and because we need values to be displayed as strings as they come from backend (no localization, no datetime transformations, number formatting, etc) we somehow need to show users what data type it is like float, int8, int16, double, long, string, date, datetime, boolean, etc.

Describe the solution you'd like some kind of icons which could be set for the header like:

or maybe something like subheader?

Describe alternatives you've considered Tooltip is not a solution for us, because its already showing possible ellipsified column names.

[tmcconechy]

Wondering if you know which other grid features you plan to use? Filter, Sort, Arrange?

[hohnzy]

We have only search filtering. Column filtering is not user friendly when all the values are just string. Also sorting is not really applicable. Our product is basically SQL editor, so sorting and filtering can be done in a query

[tmcconechy]

cc @inforandy what do you think about making these database icons? Also what about the placement

[kevinwhitedesign]

@hohnzy I don't think using icons would be a wise choice because I could see the communication breaking down very easily considering the very specific ones like " int8, int16, string". From my icon creator pov these would visually be hard to create metaphors for.

I think there's some weight with what was said about an 'eyebrow' text or maybe something such as a parenthesis after the col name example:

firstname (String)

Only problem there is losing the information to truncation, although the name would be available on hover or resize of the col headers.

Worth exploring @katieinfor maybe we can get a ticket for this assigned to me

[hohnzy]

These were used for the file types, I can imagine similar style... Or what about some kind of subheaders? I would rather have taller header row than forcing users to resize the columns (+ the column resizing is kinda buggy when all the columns fit into the screen width)

[tmcconechy]

My biggest concern is how to fit it in with all the other "icons" on the header here:

If we add this we'd need to make sure it all works/fits. Not certain there is a big advantage to adding this from a UX standpoint vs the complication.

[ghost]

@kevinwhitedesign created a ticket for this in Jira! https://jira.infor.com/browse/UXD-2370 thanks.

[inforandy]

@tmcconechy let me know if there is any further feedback required here, otherwise looks like we are set

[tmcconechy]

@hohnzy after https://github.com/infor-design/enterprise/issues/6490 is done this should be possible FYI @inforandy i think we should be set

[CindyMercadoReyes]

This task has been completed

[tmcconechy]

Closing as this was implemented https://main-enterprise.demo.design.infor.com/components/datagrid/example-header-icon-with-tooltip.html