search

specify / specify7

Specify 7
https://www.specifysoftware.org/products/specify-7/
GNU General Public License v2.0
62 stars 36 forks source link

Queries made in Specify 7 cannot be used to create a report or label in iReport #1991

Open grantfitzsimmons opened 2 years ago

grantfitzsimmons commented 2 years ago

Developed a new report for labels in Specify 6 and iReport and the report runs fine in both Specify 6 and 7 and can be used with record sets. No errors and not a 500 error now.

However, queries developed in Specify 7 do not work in iReport, as the list of fields in the query are not available to be added to the report template in iReport, but when the same query is developed in Specify 6, the list of fields is displayed.

Reported By: Rob at CSIRO

grantfitzsimmons commented 2 years ago

Current workaround is to modify the existing Specify 7 query in Specify 6, then use it to compose a report or label in iReport. Closely related to #1768 as the same underlying problem leads to both issues. Specify 7 needs to update reports/labels associated with the queries created in it (potentially removing the independence of the report or labels in 7) or we need to address this in how we handle adding fields to JRXML files.

grantfitzsimmons commented 1 year ago

This was reported by Gothenburg museum of natural history

grantfitzsimmons commented 1 year ago

Reported by KwaZulu-Natal Museum

grantfitzsimmons commented 2 months ago

@emenslin I know this is still ongoing