incident report with filter to location

avanis
Kilo Contributor

I need to create a report for incident table.

The region logged in user has to match with assigned to location>region.

the filter on report does not allow to apply dynamic filter on this field. Assigned to>location> region.

Can someone please guide how this can be achieved.

5 REPLIES 5

Vishal Khandve
Kilo Sage

Hi avni,



Add filter condtion : show related list> assigned to.location.region



Thank you,


vIshu


Ashutosh Munot1
Kilo Patron
Kilo Patron

Hi Avani,



This is something complex. We have to use javascript: script include.



Here in script include we need to check logged   in user and send his region to filter and then match it with Assigned to region.



Thanks,


Rajshekhar Pau1
Kilo Guru

Hi Avani,



Please find the helpful community thread:


filter incidents by logged in user region



Please hit Like or Helpful or mark Correct based on the impact.


Regards,


Rajshekhar Paul


How can i add the dynamic filter here in report ?



find_real_file.png