Forum Discussion

Tim's avatar
Tim
Data Integration
06-01-2023
Solved

L2022.9: Filters with field names that do not match the names in the data model

We’re looking at updating Sisense; I have a question about the breaking change below. Analytical Engine Overview: In the event that widgets contain filters with field names that do not match the nam...
Releases
  • Tim's avatar
    Tim
    06-01-2023

    I got an answer. Turns out it's not when you set some name in the widget, but you rename the source column in the data model. And in such cases there was already a problem. So, I'm not so concerned; it's not likely to affect anyone, and if it does, then their widget already had an undiscovered bug, so I'll be glad to find it this way.

     

    Sisense support said:
    This breaking change does not affect all dashboards or data models. It only relates to "bad filters", which can occur when a designer creates a filter (any filter) using a column, and then the data admin renames that column in the data model.

    Previously, such filters were ignored, data wasn't filtered, and unexpected data could be shown to the viewers. With AE activated, the system blocks such cases, and the widget returns an error.

    The highlighted lines in your screenshot attached are completely fine and you don't need to edit them.

HamzaJ's avatar
HamzaJ
Data Integration
06-01-2023

Hey Tim 

We had this issue when we were migrating from Windows to Linux. We solved this by exporting 

  • dashboards
  • widgets
  • kpi
  • datacontext
  • metadata

collections from the Application DB (the mongoDB) and did a find/replace-all.  on ' (Calendar)]' to ']'.

I used the following commands:

mongoexport --uri="mongodb://localhost:30846/prismWebDB" --collection=dashboards --out=dashboards.json
mongoexport --uri="mongodb://localhost:30846/prismWebDB" --collection=widgets --out=widgets.json
mongoexport --uri="mongodb://localhost:30846/prismWebDB" --collection=kpi --out=kpi.json
mongoexport --uri="mongodb://localhost:30846/prismWebDB" --collection=dataContext --out=dataContext.json 
mongoexport --uri="mongodb://localhost:30846/prismWebDB" --collection=metadata --out=metadata.json
.\mongoimport.exe --uri="mongodb://localhost:30846/prismWebDB" --collection=dashboards --mode=upsert --file="C:\Users\xxx\Documents\dashboards_altered.json"
.\mongoimport.exe --uri="mongodb://localhost:30846/prismWebDB" --collection=widgets --mode=upsert --file="C:\Users\xxx\Documents\widgets_altered.json"
.\mongoimport.exe --uri="mongodb://localhost:30846/prismWebDB" --collection=kpi --mode=upsert --file="C:\Users\xxx\Documents\kpi_altered.json"
.\mongoimport.exe --uri="mongodb://localhost:30846/prismWebDB" --collection=dataContext --mode=upsert --file="C:\Users\xxx\Documents\dataContext_altered.json"
.\mongoimport.exe --uri="mongodb://localhost:30846/prismWebDB" --collection=metadata --mode=upsert --file="C:\Users\xxx\Documents\metadata_altered.json"

Please backup and test everything thoroughly before doing this on a live production.

Hamza