I’d like to include some other details in the Request History template, but it’s items that are only related to the HS_Request table, not fields in that table. How would I go about adding additional SQL (or replace the existing SQL?) to the Request History template to look up this other data?
Well the template is PHP so you can add any PHP you like to it to make DB queries and such. If you need advice on the exact SQL you need then you’ll have to post the exact information you’re trying to retrieve and we can help you from there.
Is it possible to get the current database session, or will I just establish a new session instead? Thanks Ian.
I believe it will pickup the current session so you can just use mysql_query (or the appropriate one for your DB), though you could start a new session if it doesn’t detect it.