renssak Posted March 30, 2020 Share Posted March 30, 2020 Hi all,I'm looking for a way to get all the SQL quelies of all Jasper reports in the repository.Is there a possibility? I haven't found anything yet ......My problem is that I currently have around 100 database views that were originally created for Jasper reports. A large part is no longer required and should be deleted from the database. Unfortunatelly I have no overview of which views are still used in reports.Thanks in advance.I am currentyl using Jasper Reports Server Version 6.4.2 (Commercial Version) with Oracle for the Jasper-repository.RegardsMartin Link to comment Share on other sites More sharing options...
jgust Posted March 31, 2020 Share Posted March 31, 2020 I don't know about server functionality but for the jrxml files, you can use a grep tool to find your specified content. In your case that would be items in the <queryString> tag.I used dnGrep for Windows with the settings below and was able to save the results to a text file for further review.Note that the regex the program uses is Microsoft's version of regex. There is a help file for the regex they use to assist you. Link to comment Share on other sites More sharing options...
renssak Posted May 6, 2020 Author Share Posted May 6, 2020 Hi - sorry for my late answer an thank you for your answer.I hoped there would be a solution via SQL.To step through the jrxml files by script currently is not possible, because we still use the old iReport to edit the reports.Perhaps, when we have migrates to JSS, I can build a script which steps though all jrxml-files to get the used queries - or better to get the used view-names in the queries. But this would be difficult, if there is more than one view used. 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