impact Posted July 26, 2017 Share Posted July 26, 2017 The documentation suggests that opening a domain, clicking OK, and then re-opening the domain will refresh the source schema. I've noticed this does work for new tables. But I have an existing table already part of a set and participating in joins in the domain. I've added a column to the source table. I cannot figure out a way to "refresh" the table definition and expose the new column within the domain. I don't really want to unselect the effected table since I will lose all my joins, and display modifications. Does anyone know how to see new table columns within a selected table in an existing domain? Link to comment Share on other sites More sharing options...
Solution vchiem Posted July 27, 2017 Solution Share Posted July 27, 2017 For existing tables, I suppose you mean tables that are already part of the Selected Tables pane in the Tables tab and Joins tab. I have added new test columns to an existing table in an existing domain and simply by clicking on "Edit with Domain Designer" and expand the table, the new columns appear immediately in the table that selected in the Selected Table and its reflected in the Joins tab. I am using JRS 6.3 though. I wonder whether this is attributed the difference in JRS versions. Try doing a quick test on sample Foodmart database... Create a domain via use domain designer and use existing table, then add a column to the database table structure and then close out designer and reopen designer to see the new column reflected in the Tables and Joins tab. Link to comment Share on other sites More sharing options...
impact Posted July 28, 2017 Author Share Posted July 28, 2017 So it is interesting. Once I do a schema change, the first time I go to edit the domain in the designer, the browser just spins forever. I restart Tomcat and then return to the designer and the new filed is there. Link to comment Share on other sites More sharing options...
impact Posted August 8, 2017 Author Share Posted August 8, 2017 I've confirmed that version 6.3.0 build 20160621_1840 does not update the schema in the domain automatically. I can click OK and Submit on the Domain several times and the columns to choose from are still not reflecting a field recently added to the source. If I restart Tomcat, the moment I go back into the Domain Designer, the new fields are available. 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