Page 1 of 1

Customizing Dashboard need help with SQL query

PostPosted: Wed Sep 07, 2011 5:43 am
by jasonstarkey
I had created a custom logical field for incidents called UDF1.

I want to create a chart that shows me the count for all incidents where UDF = trued for the past x months. where X is most likely going to be 6.

I will also want to create some other charts that show the number of non closed incidents, work orders, change requests, problems where a particular UDF is true. Is this at all possible? I'm assuming if we have the SQL Query at our disposal anything is possible, but I have to admit i'm not a SQL guru.

Any help would be greatly appreciated!

Thanks,
Jason

Re: Customizing Dashboard need help with SQL query

PostPosted: Tue Sep 20, 2011 12:32 pm
by tccwrd
jasonstarkey wrote:I will also want to create some other charts that show the number of non closed incidents, work orders, change requests, problems where a particular UDF is true. Is this at all possible? I'm assuming if we have the SQL Query at our disposal anything is possible, but I have to admit i'm not a SQL guru.


You can do this Jason, but keep in mind UDFs are per object. Having one chart for all those objects won't work when testing for the value for one UDF.

Do you have a UDF for each object?