# Selecting a saved filter doesn't update the data presentation

**URL:** https://community.spicecrm.io/t/selecting-a-saved-filter-doesnt-update-the-data-presentation/26
**Category:** KReporter
**Created:** [November 22, 2016, 2:09pm UTC](https://community.spicecrm.io/t/selecting-a-saved-filter-doesnt-update-the-data-presentation/26 "2016-11-22T14:09:58Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![jonnygribben](https://avatars.discourse-cdn.com/v4/letter/j/f9ae1b/32.png) [@jonnygribben](https://community.spicecrm.io/u/jonnygribben)
#### Post date: [November 22, 2016, 2:09pm UTC](https://community.spicecrm.io/t/selecting-a-saved-filter-doesnt-update-the-data-presentation/26/1 "2016-11-22T14:09:58Z")

</div>

Hi,

We’ve started using the Saved Filters feature and are finding it very useful. We’ve come across an instance where selecting a saved filter updates the visualisations but not the data presentation. Here is one of the saved filters from the DB. I’ve edited it slightly to remove some names & email addresses.

mysql\> select \* from kreportsavedfilters where kreport\_id = ‘k57c16d164da30a0d24aea466668b’ and deleted = 0\G  
\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* 1. row \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*  
id: k3a6c612d85e5b62513d5d6840953  
name: Q4  
date\_entered: 2016-11-21 15:45:22  
date\_modified: 2016-11-21 15:45:22  
modified\_user\_id: 227  
created\_by: 227  
deleted: 0  
kreport\_id: k57c16d164da30a0d24aea466668b  
assigned\_user\_id: 227  
is\_global: 1  
selectedfilters: [{“fieldid”:“k7d6ae61e376464478fbf19a81dbc”,“operator”:“oneof”,“value”:[“Paul, Matthew”],“valuekey”:[“paul”,“matthew”],“valueto”:"",“valuetokey”:""},{“fieldid”:“ke86b5ed7ca53bbc1aa97ca89abcc”,“operator”:“ignore”,“value”:"",“valuekey”:"",“valueto”:"",“valuetokey”:""},{“fieldid”:“k5210dc17f27568d2b8f033f6ca95”,“operator”:“between”,“value”:“07/01/2017”,“valuekey”:“2017-07-01”,“valueto”:“09/30/2017”,“valuetokey”:“2017-09-30”},{“fieldid”:“ka1c849402602f50323be930c80fd”,“operator”:“ignore”,“value”:"",“valuekey”:"",“valueto”:"",“valuetokey”:""},{“fieldid”:“k436192c0a109d03d54835b94e8d8”,“operator”:“notcontains”,“value”:“stripe”,“valuekey”:"",“valueto”:"",“valuetokey”:""},{“fieldid”:“k721a99e4a1b47eb10b4e9bcf6a73”,“operator”:“ignore”,“value”:"",“valuekey”:"",“valueto”:"",“valuetokey”:""},{“fieldid”:“k238b5be98dd884cee2f227ee255e”,“operator”:“ignore”,“value”:"",“valuekey”:"",“valueto”:"",“valuetokey”:""},{“fieldid”:“k7558bcb61bfbcaefba78b717089c”,“operator”:“ignore”},{“fieldid”:“k9bb60605e278a3bcfbe1d6819d62”,“operator”:“ignore”},{“fieldid”:“k91fa284ed6878f375eab9cdb7e96”,“operator”:“ignore”}]

Any ideas what the issue could be?

Many thanks,  
Jonny

---

<div class="post-metadata">

### Author: ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)
#### Post date: [December 1, 2016, 3:24pm UTC](https://community.spicecrm.io/t/selecting-a-saved-filter-doesnt-update-the-data-presentation/26/2 "2016-12-01T15:24:37Z")

</div>

Jonny, I can’t reproduce the case. Best would be to have the report itself. Could you send me the result row of select \* from kreports where id = ‘k57c16d164da30a0d24aea466668b’ ? Please send it to my usual e-mail address.

---

<div class="post-metadata">

### Author: ![jonnygribben](https://avatars.discourse-cdn.com/v4/letter/j/f9ae1b/32.png) [@jonnygribben](https://community.spicecrm.io/u/jonnygribben)
#### Post date: [December 5, 2016, 3:00pm UTC](https://community.spicecrm.io/t/selecting-a-saved-filter-doesnt-update-the-data-presentation/26/3 "2016-12-05T15:00:18Z")

</div>

Will do, thanks very much!

---

<div class="post-metadata">

### Author: ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)
#### Post date: [December 6, 2016, 11:15am UTC](https://community.spicecrm.io/t/selecting-a-saved-filter-doesnt-update-the-data-presentation/26/4 "2016-12-06T11:15:41Z")

</div>

Jonny, your report has a treeview presentation and the load filter functionaility has been implemented for treeview yet. We will add it in next KReporter Release.
