How to keep GridAdvanced tree entries expanded after data reload?

[MA8731174]

Hi everyone,

I’m working with GridAdvanced in ThingWorx and I’m using it in tree mode to display a parent-child structure:

• I have main entries (parents) and when you click on one, it expands to show the sub-entries (children) below.

My challenge is:
Whenever I make a change and reload or refresh the data in the grid (e.g., after an action or a service call), all the parent entries collapse and I lose the expanded state. I’d like the grid to keep the same entries expanded after the data is loaded again, so the user doesn’t have to click and open them each time.

Does anyone have best practices or tips for how to keep certain tree rows expanded after reloading the data?
Is there a recommended way to save and restore the expanded state programmatically?

Any suggestions, examples, or workarounds would be greatly appreciated!

Thanks a lot in advance!

[TonyZhang · Accepted solution]

Hi @MA8731174,

In the Tree Grid Advanced widget, there is a property named PreserveRowExpansion that you can enable to fulfill your use case I believe.

See Help Center:

Best,

[MA8731174]

Thanks for your answer! 

Actually we are using grid widget and NOT tree Grid. In Grid widget i have child entries and parent entries. I have checked this preserverRowExpansion checkbox true but still it does not work. As from documentation its stated that its just for Tree Grid.

Any further tips would be great!

[TonyZhang]

Hi @MA8731174,

Hi, I tested PreserveRowExpansion for ptcs-grid (Standard Grid) widget and it is working in ThingWorx 9.6.0  (Tree Grid only means you are displaying tree-structure data in Grid widget I guess).

Which version of ThingWorx are you running? 

I found internally that there's a bug being fixed regarding PreserveRowExpansion in ThingWorx 9.6.0.

Also, please make sure that CacheRuntimeChanges is set to true along with the PreserveRowExpansion

Best,

[MA8731174]

Hi @TonyZhang Thank you for further information. We are using Thingworx 9.4 at the moment. We are showing tree structure and yes i have selected PreserveRowExpansion and CacheRuntimeChanges to true but its still not working. Would you please confirm that if bug remains there in 9.4  

[TonyZhang]

Hi @MA8731174,

I tested in ThingWorx 9.4.4 and PreserveRowExpansion options is working for ptcs-grid in my 9.4.4 environment.

If this is not working in your environment, could you please open a support case for further assistance?

It would be great if you could share the support case No with me via private message so that I can update the root cause/findings of the issue here once it becomes clear after investigation.

Best,

[MA8731174]

I am sorry @TonyZhang our version is 9.3.7 

Excuse me for my mistake. 

[TonyZhang]

Hi @MA8731174,

I'm sorry that I don't have 9.3 environment available at the moment for testing. 9.3 is a very old version - its standard support ended in last year. Please consider upgrading your ThingWorx to at least 9.6.0 or even newer version (9.7 or 10) and see if enabling PreserveRowExpansion option works. If still not, please consider opening a support case for help.

Best,