I’ll give you the “why” - help you see where I am coming from with this and add to that endless list of customer requests
What I need is an easy search function that will show me all the other tickets opened by people at the same company (defined by same domain name in email) as often in large co’s the left hand doesn’t even know there is a right hand. This is not something thats useful for internal helpdesk but is for external facing helpdesk like me (and you I would guess!).
I’ve done a very dirty page querying the helpspot db for where Email like ‘@domain.com’ and returning the results as both a html table and xml like your live lookup example.
(BTW - the live lookup doesn’t really work for this as we are not showing customer info and “Insert customer information” is not valid - but with a tiny bit more flexibility it could easily show a ajax datatable/grid that would be ideal for this sort of report).
The other part of this is ensuring it can only be ran by an authenticated helpspot user as you wouldn’t want just anyone running these - so something like a file “ensure_authenticated.php” which we could include that would wrap the login logic and redirect/stop processing if not logged in would be fan-tas-tic!