'List of Data' Widget - support column renaming

[Martyn Houghton]

At the moment it is not possible to rename a column name when using a 'List of Data' Widget in Advanced Analytics, so when the Widget displays the physical database column name, i.e. h_datelogged, h_pk_reference etc.

It would be really useful to be able to use the 'as <name>' format then entering the columns to allow the column output to be renamed or for the Widget output to use the field label/translation text.

Cheers

Martyn

[NeilWJ]

Hi Martyn,

For now if you use list type "custom sql query" you can use AS alias in your sql. I will have a chat with the api team to see if we can pull the schema label for the columns used when using the "single table query".

 

SELECT h_pk_reference As Reference,  h_description As Summary, h_ownerid  As Owner
FROM h_itsm_requests
where h_ownerid is not null
limit 10

Cheers

[Martyn Houghton]

@NeilWJ

Thanks, that does the trick. Just a note, when you use the 'custom sql query' option, the presentation of the columns does use the translation labels by default, rather than the column names which the 'single table query' does.

Cheers

Martyn

[Everton1878]

it would be good to have a few more customisation options too

conditional formatting?

spacing between columns

hide column headings

alternate row background colours