Add a NEW field to an EXISTING domain in Jasperserver 7.5

In Jasperserver 7.5, how can I add a NEW field to an EXISTING domain without moving my table with the new field from Selected Tables to Available Tables and back again? Doing so wipes out Pre-Filters and Data Presentation information. In 7.1, it was simple to do this. This question is for 7.5.

ETA: I can, however, add a field to a Derived Table by editing, running the query, and adding the new field to the selected fields. The new field then automatically becomes available in Data Presentation. This is fine going forward, as I can present all of my tables as derived tables. However, I have several domains already created and in use that do not have (previously unneccessary and frankly superfluous) derived tables to mirror each data warehouse table. It's a common request from our customer to add more fields to their datasets, and this is going to be a pain point in our move to 7.5. 

lshanyfelt's picture
Joined: Aug 29 2016 - 12:33pm
Last seen: 2 months 2 weeks ago

Yes, I can force the update, but doing so loses all of the data presentation work in the domain. For that reason, it's not a viable solution.

To get around this, I am just adding new fields directly to the domain file, skipping the editor.

lshanyfelt_1 - 2 years 10 months ago

2 Answers:

You can force an update from the data warehouse by going to the "kebab" menu (three dots), select Change Data Source and then pick the same data source. Not a shining example of intuitive UI.

elizam's picture
14002
Joined: Mar 5 2012 - 9:19am
Last seen: 2 years 7 months ago

I have the same problem on my 7.5 and changing data source did not affect the domain, the tables are still missing new fields.

chiricoluca87's picture
Joined: Apr 11 2014 - 12:40am
Last seen: 10 months 1 week ago
Feedback
randomness