mojahidm Posted June 6, 2018 Share Posted June 6, 2018 Hi team, I'm trying to create a report where I will enter in a date range and a list of orgnizations (from a previously made simple list). From this, I would want the organization name, the priority name and the within fix I have named the report: Sandbox Official 2.Incidents Resolved Count Ver5 - Date and Org with Priority/Fix The issue I have is that no data is being returned. Please see following report construction: FILTERS: 1. REQUEST TYPE WILL BE INCIDENT: 2. DATE PROMPT FOR RESOLVED DATE 3. ORGANIZATION PROMPT SELECT ORDERING DATA PREVIEW I have run the following code in the database direct and can see that there should be data here: SELECT * FROM h_itsm_requests AS his JOIN h_sys_organizations AS hso ON his.h_org_id = hso.h_organization_id WHERE hso.h_organization_name = 'UK_Review' Any help would be much appreciated Kind regards, Mojahid 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