Selecting a saved filter doesn't update the data presentation

KReporter
1

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

2

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.

3

Will do, thanks very much!

4

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.

1 Like