Customizing Dashboard need help with SQL query

Open discussion about our Alloy Navigator 6 application

Customizing Dashboard need help with SQL query

Postby jasonstarkey on Wed Sep 07, 2011 5:43 am

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
jasonstarkey
Member
 
Posts: 10
Joined: Sat Oct 24, 2009 4:13 pm

Re: Customizing Dashboard need help with SQL query

Postby tccwrd on Tue Sep 20, 2011 12:32 pm

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?
Gary
User avatar
tccwrd
Senior
 
Posts: 49
Joined: Tue Nov 30, 2010 9:22 am


Return to Alloy Navigator 6 Discussion

Who is online

Users browsing this forum: No registered users and 1 guest

cron