Geoff Soper Posted July 25, 2022 Share Posted July 25, 2022 On attempting to create a report from h_itsm_requests - this table is no longer selectable from the drop down - which table has this been replaced with? Thanks Link to comment Share on other sites More sharing options...
Steve Giller Posted July 25, 2022 Share Posted July 25, 2022 @Geoff Soper Are you in the Service Manager Application section? I believe that will affect the Tables available for use in Reports. Link to comment Share on other sites More sharing options...
James Ainsworth Posted July 25, 2022 Share Posted July 25, 2022 Link to comment Share on other sites More sharing options...
Victor Posted July 25, 2022 Share Posted July 25, 2022 Tables available for selection when creating reports are not specific to app context. All tables are available in the list regardless of where you are in the navigation menu (e.g. Platform Configuration, Service Manager, etc.). h_itsm_requests is not available with this name in Reports (h_itsm_requests is only in DB Direct), you are looking for the "Requests" table: While app context does not matter when it comes to available tables when designing a report, it will matter in regards to where the report will reside. For example, if you create a report while in Service Manager - so using the "Reporting" admin option from Service Manager section - then the report created will only be visible and accessible from this reporting section and not from other reporting sections (e.g. reporting section from Platform Configuration or another app). Link to comment Share on other sites More sharing options...
Geoff Soper Posted July 26, 2022 Author Share Posted July 26, 2022 Hi James - I only see 3 reports, but I get emailed my monthly reports that I need to amend, but can't see any of them - we have a lot more than 3 reports. This is all I can see and two of the reports were created yesterday. Link to comment Share on other sites More sharing options...
Victor Posted July 26, 2022 Share Posted July 26, 2022 @Geoff Soper 9 hours ago, Victor said: While app context does not matter when it comes to available tables when designing a report, it will matter in regards to where the report will reside. For example, if you create a report while in Service Manager - so using the "Reporting" admin option from Service Manager section - then the report created will only be visible and accessible from this reporting section and not from other reporting sections (e.g. reporting section from Platform Configuration or another app). As per above the reports are grouped by app. In the above screenshot, where exactly you are in admin when viewing those reports? Platform Configuration? Service Manager? or other app? Link to comment Share on other sites More sharing options...
Geoff Soper Posted July 26, 2022 Author Share Posted July 26, 2022 17 hours ago, Steve Giller said: @Geoff Soper Are you in the Service Manager Application section? I believe that will affect the Tables available for use in Reports. Yes - this has fixed it - Thanks Steve Link to comment Share on other sites More sharing options...
Victor Posted July 26, 2022 Share Posted July 26, 2022 Just to clarify for future reference: Tables available for selection when designing reports are NOT filtered by app. ALL tables will be available for selection regardless of the app context when in admin view. Reports however are filtered by app and the reports displayed in "Reporting" in admin tool depend on app context when in admin view. A report created via "Platform Configuration -> Reporting" will only be visible while in "Platform Configuration" and a report created via "Service Manager -> Reporting" will only be visible while in "Service Manager" Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now