Hi Guys,
I am currently working on a mod that will allow you to add a company to a table with the domain name, this will then display the company name depending on the domain on the email address.
domain | company
company.com | Company Ltd
this avoids people typing the company name in differently each time and screwing up reports.
i have however hit a little issue that i cant figure out how to fix and maybe one of the OS ticket Gurus out there can help me with it.
I would need to left join the "company" table to the ticket query that selects the ticket and displays it on the dashboard, the issue i have is that i cant explode the email address if i havent already run the sql query.
Is there a way around this or would you simply run a 2nd sql query that once a ticket is pulled it will explode the email address and match the domain in the company table?
I wanted to avoid using 2 sql queries as i dont want to add bloat but this is the only way i can think of doing this.
any help would be appreciated, if you need clarification on anything let me know.
Steve
