How to avoid tuple objects in slice for expand/collapse state management?

Ravi asked on August 8, 2019

Hi Team,
 
How to avoid tuple objects in ‘slice->expands->rows/measures’ list?. This occupies our DB space storage as much.

Can you handle this using a boolean or is there any other way?

6 answers

Public
Tanya Gryshko Flexmonster August 8, 2019

Hello, Ravi,

Thank you for your question.

We would like to inform you that this information is stored in order to determine what to expand when parsing the report. In case it is removed, the expands will not be restored.

Please let us know in case of other questions.

Regards,
Tanya

Public
Ravi August 8, 2019

can we have like below in pivot config?
“rows”:[{“uniqueName”: “Year”,”sort”: “asc”,“expands”:true},{“uniqueName”: “Month Name”,”sort”: “asc”}]

Public
Ian Sadovy Flexmonster August 14, 2019

Hello Ravi,
 
Thank you for the answer and apologies for a slight delay.
In case there is no need to save expands, you can easily remove expands/drills from the report Object before saving to the DB and it does not require any additional configuration on Flexmonster.

var report = pivot.getReport();
delete report.slice.expands;
delete report.slice.drills;

Please take a look at the following sample: https://jsfiddle.net/flexmonster/09v8b7ed/
 
Hope it helps.
 
Regards,
Ian
 

Public
Ravi 3 days ago

Hello Ian Sadovy,
We need to save expands/collapse state for columns/rows into DB.
And also, we should avoid tuples which acquires lot of data to save in report.

We need some great solutions. please help us.

Public
Ian Sadovy Flexmonster 3 days ago

Hello Ravi,
 
Thank you for your answer.
Please note, that saving specific tuples for rows/columns are required to restore specific expands in the future when loading the report. Every tuple represents one expanded row or column and currently, there is no option to avoid it if you need expanded rows/columns by default.
In case you do not want to save expands to the DB, you can remove them (see our previous recommendations) and then perform some expands programmatically when loading reports using expandData() or expandAllData() methods.
 
Hope it helps.
 
Regards,
Ian

Public
Ravi 2 days ago

Hello Ian Sadovy,
I Understand your answer,
We are handling Lacks of records.in this case the tuples are require more DB space.
But here our query is need to save row/column level expand/collapse state.

So can you provide a solutions to save the states for columns/rows header level instead of every row/columns?

Please login or Register to Submit Answer