Customize reports

Moderator: crythias

Locked
machadoa
Znuny advanced
Posts: 101
Joined: 11 Dec 2015, 17:36
Znuny Version: 5.0.5

Customize reports

Post by machadoa »

Hello

I added 2 fields for my clients: outsourcing pc and server outsourcing
I wish in reports show tickets by 2 criteria, if the PC is outsourced or if the server is outsourced
However, if a customer has outsourcing pc but does not outsourced server, the ticket is not displayed in the report because my filters are based on outsourcing pc = no and outsourcing server = no.
Would it be possible to put the conditions in filters ?To view the tickets of customers with outsourcing pc but not outsourcing server and vice versa

Thank you
Eggllo
Znuny newbie
Posts: 79
Joined: 09 Jun 2016, 14:27
Znuny Version: 5.0.10

Re: Customize reports

Post by Eggllo »

I'm not 100% clear on what you're trying to do, but from what I can gather you want to display tickets that have either an outsourced PC, or an outsourced server. If you already have two fields that keep track of that, one possible way you could do this is by having a third field that has a 'yes' value, or some sort of positive value if either of the other two fields are 'yes'. You could set up some generic agents to make sure the third field is updated whenever something changes.

You could use that third field as a filter and only show tickets that have a yes value for it.
OTRS v5.0.10 with ITSM extension.
MySQL database
Ubuntu 16.04 LTS
Locked