04-16-2009 04:35 AM
04-16-2009 02:49 PM
04-24-2009 04:51 PM
In version 7.5.1 we included the ability to sync views out to remotes.
Additionally, you would need to do the following:
Open DBManager in Admin, locate the View that was created in the database, and select “ENABLE”.
Then insert the following data into ResyncTableDefs
<DISPLAYNAME>Campaign Targets View</DISPLAYNAME>
04-25-2009 04:46 AM
Unless I misunderstand the previous posts the functionality has been available since version 6.0 of SalesLogix. The steps you show are accurate but enabling the view via the DB Manager already creates the Entry in the Resynctabledefs so manually inserting the record is not required. I provide an add-in that we sell to SalesLogix customers and the issues I have with SQL Views that your email does not address are as follows:
04-26-2009 06:14 AM
AFAIK Ray is 100% correct. Enabling Views has been available since the "Scorpion" release. However, there has been a "bug" in view enabling from teh beginning and I believe it's still there in 7.5.1 - The Keyfield data is NOT filled in and one has to do it manually.
Cutting a new remote db after view enablement will result in the view showing up in the remote db. Enabling a view after a cut will not sync.
04-26-2009 04:10 PM
Actually RJ I have not had much of an issue with Views synching out to remotes as long as you Drop/Create the views. Alter View does not work at all. On occasion I have run into an issue that you can not cut a remote with the Views enabled. I always advise the client to drop the views build the remote and create/enable the views again. I understand there are some backdoor way to make NHibernator work with the views by updating the Keyfield but I have not been able to make it work so I gave up.
It just should be easier than this.....
04-29-2009 04:19 PM
I think that the following steps should address both of your questions:
1. No mechanism to move the SQL View to a new database/system via the bundling technology.
2. No ability to create an Entity in the Web Development environment to support the use of the data in the Web environment.
1. Bundling a View
1. Create view in database in the sysdba schema
2. Enable view using DB Manager in Administrator (this does create the entries in RESYNCTABLEDEFS)
3. Get Create View SQL from database
4. Create legacy bundle with Execute SQL action that contains Create View SQL
2. Create an Entity from a view
1. Provided that steps 1 & 2 above have been followed you should be able to use the New Entity Wizard in Application Architect to create an Entity using the new view
Let me know if this answers your question, or if there is some part of it that isn't working for you.
04-30-2009 04:23 AM