Advanced Browse Page and Browse Page are Merged into the Browse Page Object

Issue

When upgrading from a prior version to v5 or a v5 version to v6 of XMPro, the advanced browse page and browse page are merged into the browse page object.

Resolution

To copy the advanced browse page controls to the browse page table, execute the following script on the XMPro database in question.

If you are planning on upgrading and utilizing the XMMobile interface, the below needs to be executed.

Note: Remember to backup your database prior to running any scripts.

insert into fcBrowsePage (

Title, Description, Connection, SQL,

OrderBy, PageSize, EventControlID

)

select  p.Title, p.Description, p.ConnectionString as Connection,

p.Query + CASE WHEN p.WhereClause='' then '' ELSE ' where ' + p.WhereClause end as SQL,

p.OrderBy, p.PageSize, p.EventControlID

from fcAdvancedBrowsePage p inner join

fcEventControl c on c.ID = p.EventControlID

where  c.Type = 'Advanced Browse Page'

insert into fcBrowseObject

select  b.ID, o.cIndex, o.Name, o.Description,o.Source, o.Target, 0 as Filter

from fcBrowsePage b inner join

fcAdvancedBrowsePage a on a.EventControlID = b.EventControlID inner join

fcAdvancedBrowseObject o on o.AdvancedBrowsePageID = a.ID

update fcEventControl

set      Type = 'Browse Page'

where  Type = 'Advanced Browse Page'