Jump to content

Change Management Database Direct Queries


Awalker
 Share

Recommended Posts

Morning all,

 

Can someone tell me how easy it is to create a query to pull back all change requests in a select date range but also to show the date they have been scheduled for?

I cannot easily do/find this?

 

Thanks

Alex

Link to comment
Share on other sites

@Awalker i am not sure if you are looking to do this in the reports in the admin console or a widget etc in advanced analytics.

If you are using the reports, if you create a report using the Change Request entity, then you will have the scheduled dates columns available to select to include in your report content

image.png

 

image.png

For the date range,  you can use any of the date fields to evaluate against, i have shown Date Logged below, and you can use the user prompt option to prompt the user for the date range each time they run the report, or you could use the Against custom Criteria options as shown below where you can choose a date range for the report to use each time it is run

image.png

Hope that helps

Steve

Link to comment
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
 Share

×
×
  • Create New...