Jump to content
Martyn Houghton

'List of Data' Widget - support column renaming

Recommended Posts

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

  • Like 1

Share this post


Link to post
Share on other sites

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

  • Like 1

Share this post


Link to post
Share on other sites

@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

  • Like 1

Share this post


Link to post
Share on other sites

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

conditional formatting?

spacing between columns

hide column headings

alternate row background colours

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...