Editing a query linked to a report/label does not update the report/label definition

[benritchie]

Situation: We are using Specify 7 wherever possible (so including for query development etc).
Still use iReport for query development though. (as AFAIK ,there's no specify 7 native replacement for this yet?)

Issue is as follows: If you update a query in Specify 7 to add a new field, and then go into iReport, the new fields you've added don't show up.
To get the fields to show up, you need ot go into Specify 6, change the query there (any cange seems to do it) and then next time you open ireport, new fields are there.
I'm assuming specify 6 does some magic under the covers to make this all work.

Ask is to: Ideally fix this so that Specify 7 can be used to tweak reports for queries.
Failing that, at least get this clearly documented - could specify 7 recognise the query was used for a report, and display a popup (you must open and save this query in specify 6) or similar?

thanks.

[grantfitzsimmons]

Specify 7 definitely should have a feature like this. Currently, you must

1. Modify the query
2. Define a report or label based on the query
3. Copy the updated fields into the existing report

`

<field name="18,20-borrowMaterials.borrowmaterial.materialNumber" class="java.lang.String"/>

`

4. Edit that report in Jaspersoft Studio

It seems that the query is embedded in the .jrxml file in 7. In 6, I take it that the available fields are refreshed based on the query it was made with when iReport is opened.

My request is that the underlying query associated with a report/several reports should be directly editable in 7 with the QB interface.

[benritchie]

maybe one to address when you add a Report editor to 7?

[grantfitzsimmons]

Still needs to be fixed.

[grantfitzsimmons]

Still needs to be fixed.