Gareth Watkins Posted February 6 Share Posted February 6 Hi all I'm trying to create a list type widget in Service Manager and wondered if there was any limitation on querying more than 1 table using the custom SQL option. I cant seem to get any results when using even a basic query over 2 tables using a JOIN. I'd hoped that, as there is a single table query option, the custom would allow queries or multiple tables if written with the correct join statements. Can anyone help? A sample of my SQL is below. Not a die-hard SQL user but this query successfully returns results via database direct so I would expect it to do so in the custom widget SQL window. What I get instead is a generic error advising to check the log for details. I've scoured the logs but cant locate the error / information to try and rectify the problem. SELECT h_itsm_requests.h_pk_reference, h_sys_tasks.h_task_id FROM h_itsm_requests JOIN h_sys_tasks ON h_itsm_requests.h_social_object_ref = h_sys_tasks.h_obj_ref_urn Any ideas? Link to comment Share on other sites More sharing options...
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now