Jump to content

Joining Tables to create a widget


Recommended Posts

Hi,

Can I create a data chart widget, from joining two tables?

If I choose data type 'sql group by' only get option for one table . Is there a way to select/join two tables (manage to join in reports, as well as on list of data widget, but not for data chart widget')

Thanks.

Regards,

Joyce

Link to post
Share on other sites

Hi @Joyce

You cannot currently join in this type of widget - however, depending on what you are specifically looking to achieve, there may be something you can do by performing a "Sub Select" in the "WHERE" clause. But this is wholly dependent on what you would like to do. 

If you could provide me with an example of a widget you are looking to display, I can see if this would be possible or not for you.

Kind Regards

Bob

Link to post
Share on other sites

Hi @Joyce

I have been able to create your report using a Sub Select statement in the WHERE CLAUSE -  hopefully the screenshots show what I mean here, but we are using two SELECT statements in one - one to get a subset of data from h_itsm_requests and the main one to then interrogate that subset to get the results. 
 

I have placed this on your instance for you to have a look at, but for anyone else who is reading this thread, here is how it was achieved:

Finished Widget showing groupings of answers to questions

Screenshot_17.png

 

Widget Configuration

Screenshot_18.png

 

WHERE clause used in the widget configuration

Screenshot_19.png

 

I hope this helps

Kind Regards

Bob

Link to post
Share on other sites

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

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...