How can you unhide a column in the webversion of Spotfire?

[Erwin Brinkhuis]

In the webversion of Spotfire end-users have an option to hide columns in a table (see picture acttached). How can end-users unhide these columns again in the webversion?

[Fredrik Rosell]

Hello,

To show the column again, you could do the following:

1. Select "Editing" mode in the upper right corner (so this means having the Business Author license)
2. Right-click on the table > Properties
3. Under Columns, click "Select Column"
4. Now you can add the column that had been hidden/removed.

[Erwin Brinkhuis]

Hi Frederik,

Thanks for your reply but the point is that the end-user is working in the web version of Spotfire. In that version it's not possible to go into the editing or properties mode.

[Fredrik Rosell]

Hello Erwin,

With web version I assume you mean "only having the Consumer"-license then. As mentioned in my previous reply, the more advanced web client - i.e. having the Business Author license enabled - is needed. I don't think there is a built-in way to show the column again if you only have the Consumer license.

Spotfire Business Author license:

https://docs.tibco.com/pub/spotfire_server/12.2.0/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/spotfire_business_author_license.html

 

[Erwin Brinkhuis]

Hi Fredrik,

Then I assume the end-users are working with the Consumer licensed version of Spotfire. Nevertheless for me it's not logic that using the Consumer version you do have the option to hide a column but you don't have the option to unhide it.

Thanks for clarification.

[Fredrik Rosell]

Hello Erwin,

I think that is a very valid request. I took a quick look in the TIBCO Ideas portal (https://ideas.tibco.com/ideas) and didn't find anything existing idea - I recommend that you create an idea for this.

For now, here are the two workarounds I can think of for now (they both involve resetting the state of the analysis to the original state - as the analysis was saved in the library - i.e. any change the user has done (filtering, hiding columns etc) is reset)

• If you had just hidden the column and still have that session open (i.e. you haven't closed the analysis), you could use File menu > Revert to last saved to restore the analysis to the original state.

• If the analysis has been saved, when opening it you can append &applyState=false to the URL, which prevents the users state from being applied.

[Erwin Brinkhuis]

Hi Fredrik,

Thanks for the tips, we already discovered the first one. It can take up some time as the report/analysis has to load all over again. I will enter in the idea section 👍

[Fredrik Rosell]

Sounds good!