Update HOT on both filtered and unfiltered rows while on filter

Tags: #<Tag:0x00007f8b28c5fd68>
#1

Hello @aleksandra_budnik,

I couldnt find any example where we could update the table (visible as well as invisible rows) when filter is ON. Could you please help?

Thank you,
B

#2

Hey @boobal.ganesan

https://jsfiddle.net/handsoncode/L8607tow/

when you check the data console.log(hot.getData()) you’ll only get the visible rows. You need to call source data to get the source (visible and hidden) https://jsfiddle.net/handsoncode/71y9axdj/ but there is no method to change the source data at a given cell.
You may try to load a new dataset but it will reset the filters (as they no longer meet the filtering conditions).

#3

Thanks for the reply @aleksandra_budnik,

Can we consider this as a bug? I feel we should be allowed to edit the hidden rows too during filter.

I am actually working for a big concern and im working on a POC to evaluate this tool so that we can buy it.

This feature maybe a show stopper for us.

Thanks,
B

#4

Hey,

You may try to load a new dataset but it will reset the filters (as they no longer meet the filtering conditions).

Can you please let me know how I can load the new dataset after the filter is removed? That should fix this issue.

Thanks,
B

#5

You can use loadData() method in the afterFilter hook. This demo http://jsfiddle.net/1ddf47ck/ logs all needed information. If conditionsStack.length === 0 then the are no filters on the table.

1 Like
#6

Thank you, @aleksandra_budnik!

Please let me know about your licensing options.

B

#7

Hey @boobal.ganesan

Can you write us at sales@handsontable.com? Licensing depends on few factors so I would need to know a couple of additional details.

#8