Filters getting broken in the TextArea component

[Henry Heberle]

As I'm changing the information links from tables A and B, or creating new calculated columns, the filters from tables D and E are not directly influenced but yet their filters in the Text Area get broken. I just noticed that the Filter Scheme for this page is also broken, and the columns were set up to have a filter of one type, and they lost that settings too. It is not the first time it happens, so I'd appreciate it if I could understand what I can do to avoid having to repeat the organization of this page and the filter scheme (which has over a hundred of columns).

Any clues of how to avoid this behavior?

My understanding is that this should happen only if the table doesn't exist anymore, or the columns had their names changed, but this is not the case.

Spotfire 11

 

Edited November 22 by Henry Heberle

[Olivier Keugue Tadaa]

Hi @Henry Heberle
Tables D and E are NOT related in any way to tables A and B? How are tables E and D created? 

[Henry Heberle]

IL-data-on-demand -> Table 1 -> join Table 2 -> result Table 3 -> Show filters from Table 3

Add columns to Table 2 or change 1 name of column of table 2, all hundred other columns stay the same, table has the same name -> destroy filter scheme completly (?)

I have not tested this but that is what it seems to be happening. In multiple ocasions I have not touched Table 3 directly, because it would just have added some columns to it or so. But then when I would review the pages of the dashboard, I would find out that I had to waste time organizing filters.

Organizing filters is not optimal in Spotfire, because the GUIs related to filters is very poor. E.g., If I need to add a filter again to the text area, and I have 30 tables with hundreds of columns, I need to manually scroll and search for the table name and then for the column name because there is no search. Or in the Organize filters from filter scheme, when I search a table name, it doesn't work, and when I search for a column name, many options are deactivated.

So all together, this is being a pain point that I'd like to know if there is anything I can do to avoid the problem.

[Olivier Keugue Tadaa]

Thanks, Henry

Can you share more details (e.g., a DXP without data)? I can't reproduce this behavior since you are not supposed to lose the filters, as long as the columns are not removed and then recreated, 

Edited November 25 by Olivier Keugue Tadaa

[Henry Heberle]

Ok, so let's say there is no way to avoid because it's not expected to happen. I can't share the dashboard, but if I find out more details about the root cause I might come back to share it.

[Olivier Keugue Tadaa]

Agreed. Since the only way you can lose your filters is when the columns are deleted and then recreated. In your case, it looks like the entire data table itself is being recreated. That's why I'd like to review your data pipeline (if you can't share your DXP structure, the source information from data table properties should also be OK). 

Regarding your comments on filter organization and its' improvements, here are some very good ideas. Please have a look at some of them and add your comments.

https://ideas.spotfire.com/ideas/search?query=filter+organization