There are 2 methods to extract queries

Method 1 - Advanced Reporting (report folder)

1. Before using this method, ensure the user has the Clarity right:
Advanced Reporting - Administer

2. Go to  Home > Advanced Reporting > View > Repository
Select a report to view. I

For example, the report(Project Status Report List) is chosen.

3. Right click on the Report and click "Export". 
It will export and display message: Export succeeded.

4. Extract the exported file.

5. Navigate to the folder: Resources/CA_PPM/reports/project_management
to view the related files.

The relative path will be displayed

6. Under the 'reports' folder, find the file named: main_jrxml.data

The file can be opened and edited in a text processing editor to view and extract the query.

Method 2  - Advanced Reporting (View Query)

1. Login to the Jaspersoft server via the URL
2. Go to Manage > Server Settings > Ad Hoc Settings
3. Checkmark 'Enable View Query in Ad Hoc Editor. Click 'Change' button to save settings.

Method 3 - Use Jaspersoft Studio

1. Create a Jaspersoft Studio connection to the Jaspersoft Server. The steps can be found here.

2. Once a connection to the server is made, expand the tree until the report folder is reached.

3. Double-click on the file: Main.jrxml

4. Once the report opens, click the icon labeled: "Dataset and Query Editor dialog".



5. The Query Editor opens with the report query.