HelpSpot Help Desk Software | HelpSpot Blog | HelpSpot Support

SQL Query


#1

Hi Ian,

I was wondering if you could you let me know the SQL query that I can execute to retreive the name, email address and complete request history from the heplspot database?

Thanks,

J


#2

Sure. Well they’re in different tables and the way it’s setup you’ll get the name/email in each row. You could also do it as 2 queries, one to get the name/email and the other to pull the request histories.

SELECT HS_Request.sFirstName, HS_Request.sLastName, HS_Request.sEmail, HS_Request_History.*
FROM HS_Request, HS_Request_History
WHERE HS_Request.xRequest = HS_Request_History.xRequest
ORDER BY HS_Request_History.xRequest, HS_Request_History.dtGMTChange DESC

I think that should do it.


#3

Thanks alot,

I’ll have a talk with the technical guys here and let you know how we get on.

Thanks again.

J