# Filter by 'active user' option does not work

**URL:** <https://community.spicecrm.io/t/filter-by-active-user-option-does-not-work/305>\
**Category:** KReporter\
**Created:** [June 9, 2018, 7:01pm UTC](https://community.spicecrm.io/t/filter-by-active-user-option-does-not-work/305 "2018-06-09T19:01:23Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![FibreCRM\_Simon](https://avatars.discourse-cdn.com/v4/letter/f/f07891/32.png) [@FibreCRM\_Simon](https://community.spicecrm.io/u/FibreCRM_Simon)\
**Post date:** [June 9, 2018, 7:01pm UTC](https://community.spicecrm.io/t/filter-by-active-user-option-does-not-work/305/1 "2018-06-09T19:01:23Z")

</div>

So we have a report where the filter is Assigned User ‘is one of’ ‘ **active user** ’  
This is not working on our CRM’S. Is this a known bug or feature that is not yet implemented?  
Thanks

---

<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:** [June 13, 2018, 1:53pm UTC](https://community.spicecrm.io/t/filter-by-active-user-option-does-not-work/305/2 "2018-06-13T13:53:24Z")

</div>

Simon,  
it’s an unknown bug. Thank you for reporting.  
Looking for a fix.

Val

---

<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:** [June 13, 2018, 2:04pm UTC](https://community.spicecrm.io/t/filter-by-active-user-option-does-not-work/305/3 "2018-06-13T14:04:35Z")

</div>

Fix will be published with KReporter 4.4  
Add/replace following code in modules/KReports/KReportQuery.php on line 1613  
if (is\_string($value) && $value == ‘current\_user\_id’) { //bug fix 2018-04-18 maretval: check on string!  
$value = $current\_user-\>user\_name;  
}  
//bug fix 2018-06-13: $value might be an array!  
if (is\_array($value) && $value[0] == ‘current\_user\_id’) {  
$value = $current\_user-\>user\_name;  
}

 ![grafik](https://canada1.discourse-cdn.com/flex030/uploads/spicecrm/original/1X/ff8b7bf3cdd6841b5b87d06990915cb4b93e9fdc.png)

Val