Groupin e-mail account

dspit

Hi,

I have a problem with the osTicket configuration, so i would like to ask you if there is a way to resolve it. My problem matters the customers: I would like to organize tickets by group instead of organize them by e-mail accounts, this happens because every customer has several e-mail accounts.

Is there a way to allow the customer to see all his tickets that belong to all their e-mail accounts?

Is there an option that allows me to do this?

jccrofty30

You would need to rewrite the MySQL query that populates the "My Tickets" area.

Right now it is something like:

...WHERE email='xxx@yyy.zzz'...

This would need to be changed to:

...WHERE email LIKE '%@yyy.zzz'...

I don't know the file or the exact query that currently exists; but that would be the change that needs implemented.

jccrofty30

To parse it out you might be able to do something like this:

$companyDomain = strrchr(.db_input($thisclient->getEmail()), "@");

$qwhere =' WHERE ticket.email LIKE '%$companyDomain';

I am not 100% on this.