Summary:

Making any changes to any of the Grid lists used in the mobile or tablet view will break the hyperlinks in the find entity results on mobile screens

Symptoms:

The symptoms only occur when the user tries to log in through a device that uses the android or iPhone screens.

The links to phone numbers, companies and people are all broken.

If the person is clicked on it will send the user back to the main menu.

The hyperlinks are broken.

The person name has also been split onto two lines.

Description 

Workaround:

If the user has already made changes to these fields then they must do the following to revert the list back to its original working state.

These scripts will put the PersonGrid and CaseGrid back to the way it was when CRM was installed, fixing any changes or errors that have happened as a result of the bug.

The first two scripts are for installs that have been, or still are 7.1 (or earlier), and the second to are for new installs that have only used CRM7.2 (were never upgraded from 7.1).

-------------------------------------------------------------------------------------

/*
This will fix the Person Grid List. This is only to be used on 7.2 installs that have previously been upgraded from 7.1 or any earlier version.

Use This query to check if it is all ok at the end
select * from Custom_Lists where GriP_GridName = N'PersonGrid'*/

Delete from Custom_Lists where GriP_GridName = N'PersonGrid'

declare @tableID int
declare @GriPID int

select @TableId = CObj_TableId from Custom_ScreenObjects where CObj_Name = N'PersonGrid'

exec @GriPID = eware_get_Identity_Id @Table_Name = 'Custom_lists'

INSERT INTO Custom_lists (GriP_GridPropsId, GriP_GridName, GriP_Order, GriP_ColName, GriP_AllowRemove, GriP_AllowOrderBy, GriP_OrderByDesc, GriP_Alignment, GriP_Jump, GriP_ShowHeading, GriP_ShowSelectAsGif, Grip_System, GriP_CreatedBy, GriP_CreatedDate, GriP_UpdatedBy, GriP_UpdatedDate, GriP_TimeStamp, GriP_Deleted, GriP_CustomAction, GriP_CustomIDField, GriP_ViewMode, GriP_Component, Grip_DeviceID, GriP_CreateScript, GriP_DefaultOrderBy, GriP_CustomFunction, GriP_CustomEditsIDFK, GriP_ScreenObjectsIDFK )
VALUES (@GriPID,'PersonGrid', 2, 'Pers_FirstName', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2014-03-03 11:26:00.000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 9, @TableId)
exec @GriPID = eware_get_Identity_Id @Table_Name = 'Custom_lists'
INSERT INTO Custom_lists (GriP_GridPropsId, GriP_GridName, GriP_Order, GriP_ColName, GriP_AllowRemove, GriP_AllowOrderBy, GriP_OrderByDesc, GriP_Alignment, GriP_Jump, GriP_ShowHeading, GriP_ShowSelectAsGif, Grip_System, GriP_CreatedBy, GriP_CreatedDate, GriP_UpdatedBy, GriP_UpdatedDate, GriP_TimeStamp, GriP_Deleted, GriP_CustomAction, GriP_CustomIDField, GriP_ViewMode, GriP_Component, Grip_DeviceID, GriP_CreateScript, GriP_DefaultOrderBy, GriP_CustomFunction, GriP_CustomEditsIDFK, GriP_ScreenObjectsIDFK )
VALUES(@GriPID,'PersonGrid', 3, 'Comp_Name', NULL, 'Y', NULL, NULL, 'Company', NULL, NULL, NULL, NULL, NULL, NULL, '2014-03-03 11:26:00.000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 77, @TableId)
exec @GriPID = eware_get_Identity_Id @Table_Name = 'Custom_lists'
INSERT INTO Custom_lists (GriP_GridPropsId, GriP_GridName, GriP_Order, GriP_ColName, GriP_AllowRemove, GriP_AllowOrderBy, GriP_OrderByDesc, GriP_Alignment, GriP_Jump, GriP_ShowHeading, GriP_ShowSelectAsGif, Grip_System, GriP_CreatedBy, GriP_CreatedDate, GriP_UpdatedBy, GriP_UpdatedDate, GriP_TimeStamp, GriP_Deleted, GriP_CustomAction, GriP_CustomIDField, GriP_ViewMode, GriP_Component, Grip_DeviceID, GriP_CreateScript, GriP_DefaultOrderBy, GriP_CustomFunction, GriP_CustomEditsIDFK, GriP_ScreenObjectsIDFK )
VALUES(@GriPID,'PersonGrid', 5, 'Pers_PhoneFullNumber', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2014-03-03 11:26:00.000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 151, @TableId)
exec @GriPID = eware_get_Identity_Id @Table_Name = 'Custom_lists'
INSERT INTO Custom_lists (GriP_GridPropsId, GriP_GridName, GriP_Order, GriP_ColName, GriP_AllowRemove, GriP_AllowOrderBy, GriP_OrderByDesc, GriP_Alignment, GriP_Jump, GriP_ShowHeading, GriP_ShowSelectAsGif, Grip_System, GriP_CreatedBy, GriP_CreatedDate, GriP_UpdatedBy, GriP_UpdatedDate, GriP_TimeStamp, GriP_Deleted, GriP_CustomAction, GriP_CustomIDField, GriP_ViewMode, GriP_Component, Grip_DeviceID, GriP_CreateScript, GriP_DefaultOrderBy, GriP_CustomFunction, GriP_CustomEditsIDFK, GriP_ScreenObjectsIDFK )
VALUES(@GriPID,'PersonGrid', 6, 'Pers_EmailAddress', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, -1, '2014-03-03 11:26:00.000', '2014-03-03 11:26:00.000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, @TableId)
exec @GriPID = eware_get_Identity_Id @Table_Name = 'Custom_lists'
INSERT INTO Custom_lists (GriP_GridPropsId, GriP_GridName, GriP_Order, GriP_ColName, GriP_AllowRemove, GriP_AllowOrderBy, GriP_OrderByDesc, GriP_Alignment, GriP_Jump, GriP_ShowHeading, GriP_ShowSelectAsGif, Grip_System, GriP_CreatedBy, GriP_CreatedDate, GriP_UpdatedBy, GriP_UpdatedDate, GriP_TimeStamp, GriP_Deleted, GriP_CustomAction, GriP_CustomIDField, GriP_ViewMode, GriP_Component, Grip_DeviceID, GriP_CreateScript, GriP_DefaultOrderBy, GriP_CustomFunction, GriP_CustomEditsIDFK, GriP_ScreenObjectsIDFK )
VALUES(@GriPID,'PersonGrid', 1, 'Pers_LastName', NULL, 'Y', NULL, NULL, 'Person', NULL, NULL, NULL, NULL, NULL, NULL, '2014-03-03 11:26:00.000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 88, @TableId)
exec @GriPID = eware_get_Identity_Id @Table_Name = 'Custom_lists'
INSERT INTO Custom_lists (GriP_GridPropsId, GriP_GridName, GriP_Order, GriP_ColName, GriP_AllowRemove, GriP_AllowOrderBy, GriP_OrderByDesc, GriP_Alignment, GriP_Jump, GriP_ShowHeading, GriP_ShowSelectAsGif, Grip_System, GriP_CreatedBy, GriP_CreatedDate, GriP_UpdatedBy, GriP_UpdatedDate, GriP_TimeStamp, GriP_Deleted, GriP_CustomAction, GriP_CustomIDField, GriP_ViewMode, GriP_Component, Grip_DeviceID, GriP_CreateScript, GriP_DefaultOrderBy, GriP_CustomFunction, GriP_CustomEditsIDFK, GriP_ScreenObjectsIDFK )
VALUES(@GriPID,'PersonGrid', 7, 'pers_secterr', NULL, 'Y', NULL, NULL, 'person', 'Y', NULL, NULL, -1, '2014-03-03 11:26:00.000', -1, '2014-03-03 11:26:00.000', '2014-03-03 11:26:00.000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 575, @TableId)
exec @GriPID = eware_get_Identity_Id @Table_Name = 'Custom_lists'
INSERT INTO Custom_lists (GriP_GridPropsId, GriP_GridName, GriP_Order, GriP_ColName, GriP_AllowRemove, GriP_AllowOrderBy, GriP_OrderByDesc, GriP_Alignment, GriP_Jump, GriP_ShowHeading, GriP_ShowSelectAsGif, Grip_System, GriP_CreatedBy, GriP_CreatedDate, GriP_UpdatedBy, GriP_UpdatedDate, GriP_TimeStamp, GriP_Deleted, GriP_CustomAction, GriP_CustomIDField, GriP_ViewMode, GriP_Component, Grip_DeviceID, GriP_CreateScript, GriP_DefaultOrderBy, GriP_CustomFunction, GriP_CustomEditsIDFK, GriP_ScreenObjectsIDFK )
VALUES(@GriPID,'PersonGrid', 1, 'pers_fullname', NULL, 'Y', NULL, NULL, 'runtabgroup', NULL, NULL, NULL, 1, '2014-03-03 11:26:00.000', 1, '2014-03-03 11:26:00.000', '2014-03-03 11:26:00.000', NULL, 'person', 'pers_personid', NULL, NULL, 2, NULL, NULL, NULL, 150, @TableId)
exec @GriPID = eware_get_Identity_Id @Table_Name = 'Custom_lists'
INSERT INTO Custom_lists (GriP_GridPropsId, GriP_GridName, GriP_Order, GriP_ColName, GriP_AllowRemove, GriP_AllowOrderBy, GriP_OrderByDesc, GriP_Alignment, GriP_Jump, GriP_ShowHeading, GriP_ShowSelectAsGif, Grip_System, GriP_CreatedBy, GriP_CreatedDate, GriP_UpdatedBy, GriP_UpdatedDate, GriP_TimeStamp, GriP_Deleted, GriP_CustomAction, GriP_CustomIDField, GriP_ViewMode, GriP_Component, Grip_DeviceID, GriP_CreateScript, GriP_DefaultOrderBy, GriP_CustomFunction, GriP_CustomEditsIDFK, GriP_ScreenObjectsIDFK )
VALUES(@GriPID,'PersonGrid', 2, 'pers_title', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2014-03-03 11:26:00.000', 1, '2014-03-03 11:26:00.000', '2014-03-03 11:26:00.000', NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 6, @TableId)
exec @GriPID = eware_get_Identity_Id @Table_Name = 'Custom_lists'
INSERT INTO Custom_lists (GriP_GridPropsId, GriP_GridName, GriP_Order, GriP_ColName, GriP_AllowRemove, GriP_AllowOrderBy, GriP_OrderByDesc, GriP_Alignment, GriP_Jump, GriP_ShowHeading, GriP_ShowSelectAsGif, Grip_System, GriP_CreatedBy, GriP_CreatedDate, GriP_UpdatedBy, GriP_UpdatedDate, GriP_TimeStamp, GriP_Deleted, GriP_CustomAction, GriP_CustomIDField, GriP_ViewMode, GriP_Component, Grip_DeviceID, GriP_CreateScript, GriP_DefaultOrderBy, GriP_CustomFunction, GriP_CustomEditsIDFK, GriP_ScreenObjectsIDFK )
VALUES(@GriPID,'PersonGrid', 3, 'comp_name', NULL, 'Y', NULL, NULL, 'runtabgroup', NULL, NULL, NULL, 1, '2014-03-03 11:26:00.000', 1, '2014-03-03 11:26:00.000', '2014-03-03 11:26:00.000', NULL, 'company', 'comp_companyid', NULL, NULL, 2, NULL, NULL, NULL, 77, @TableId)
exec @GriPID = eware_get_Identity_Id @Table_Name = 'Custom_lists'
INSERT INTO Custom_lists (GriP_GridPropsId, GriP_GridName, GriP_Order, GriP_ColName, GriP_AllowRemove, GriP_AllowOrderBy, GriP_OrderByDesc, GriP_Alignment, GriP_Jump, GriP_ShowHeading, GriP_ShowSelectAsGif, Grip_System, GriP_CreatedBy, GriP_CreatedDate, GriP_UpdatedBy, GriP_UpdatedDate, GriP_TimeStamp, GriP_Deleted, GriP_CustomAction, GriP_CustomIDField, GriP_ViewMode, GriP_Component, Grip_DeviceID, GriP_CreateScript, GriP_DefaultOrderBy, GriP_CustomFunction, GriP_CustomEditsIDFK, GriP_ScreenObjectsIDFK )
VALUES(@GriPID,'PersonGrid', 4, 'pers_phonefullnumber', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2014-03-03 11:26:00.000', 1, '2014-03-03 11:26:00.000', '2014-03-03 11:26:00.000', NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 151, @TableId)
exec @GriPID = eware_get_Identity_Id @Table_Name = 'Custom_lists'
INSERT INTO Custom_lists (GriP_GridPropsId, GriP_GridName, GriP_Order, GriP_ColName, GriP_AllowRemove, GriP_AllowOrderBy, GriP_OrderByDesc, GriP_Alignment, GriP_Jump, GriP_ShowHeading, GriP_ShowSelectAsGif, Grip_System, GriP_CreatedBy, GriP_CreatedDate, GriP_UpdatedBy, GriP_UpdatedDate, GriP_TimeStamp, GriP_Deleted, GriP_CustomAction, GriP_CustomIDField, GriP_ViewMode, GriP_Component, Grip_DeviceID, GriP_CreateScript, GriP_DefaultOrderBy, GriP_CustomFunction, GriP_CustomEditsIDFK, GriP_ScreenObjectsIDFK )
VALUES(@GriPID,'PersonGrid', 10, 'Pers_AccountId', NULL, 'Y', NULL, 'CENTER', 'account', NULL, NULL, NULL, -1, '2014-03-03 11:26:00.000', NULL, '2014-03-03 11:26:00.000', '2014-03-03 11:26:00.000', NULL, NULL, NULL, 'GIF', NULL, NULL, NULL, NULL, NULL, 11094, @TableId)

-------------------------------------------------------------------------------------

/*
This will fix the Case Grid List. This is only to be used on 7.2 installs that have previously been upgraded from 7.1 or any earlier version.

Use This query to check if it is all ok at the end
select * from Custom_Lists where GriP_GridName = N'CaseGrid'*/

Delete from Custom_Lists where GriP_GridName = N'CaseGrid'

declare @tableID int
declare @GriPID int

select @TableId = CObj_TableId from Custom_ScreenObjects where CObj_Name = N'CaseGrid'

exec @GriPID = eware_get_Identity_Id @Table_Name = 'Custom_lists'


INSERT INTO Custom_lists (GriP_GridPropsId, GriP_GridName, GriP_Order, GriP_ColName, GriP_AllowRemove, GriP_AllowOrderBy, GriP_OrderByDesc, GriP_Alignment, GriP_Jump, GriP_ShowHeading, GriP_ShowSelectAsGif, Grip_System, GriP_CreatedBy, GriP_CreatedDate, GriP_UpdatedBy, GriP_UpdatedDate, GriP_TimeStamp, GriP_Deleted, GriP_CustomAction, GriP_CustomIDField, GriP_ViewMode, GriP_Component, Grip_DeviceID, GriP_CreateScript, GriP_DefaultOrderBy, GriP_CustomFunction, GriP_CustomEditsIDFK, GriP_ScreenObjectsIDFK)
VALUES (@GriPID, 'CaseGrid', 1, 'case_status', NULL, 'Y','', 'CENTER', 'Case','', 'Y', NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, NULL, NULL, 'GIF', NULL, NULL, NULL, NULL, NULL, 232, @tableID)

exec @GriPID = eware_get_Identity_Id @Table_Name = 'Custom_lists'
INSERT INTO Custom_lists (GriP_GridPropsId, GriP_GridName, GriP_Order, GriP_ColName, GriP_AllowRemove, GriP_AllowOrderBy, GriP_OrderByDesc, GriP_Alignment, GriP_Jump, GriP_ShowHeading, GriP_ShowSelectAsGif, Grip_System, GriP_CreatedBy, GriP_CreatedDate, GriP_UpdatedBy, GriP_UpdatedDate, GriP_TimeStamp, GriP_Deleted, GriP_CustomAction, GriP_CustomIDField, GriP_ViewMode, GriP_Component, Grip_DeviceID, GriP_CreateScript, GriP_DefaultOrderBy, GriP_CustomFunction, GriP_CustomEditsIDFK, GriP_ScreenObjectsIDFK)
VALUES (@GriPID, 'CaseGrid', 2, 'case_referenceid', NULL, 'Y','','', 'Case','','', NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 160, @tableID)

exec @GriPID = eware_get_Identity_Id @Table_Name = 'Custom_lists'
INSERT INTO Custom_lists (GriP_GridPropsId, GriP_GridName, GriP_Order, GriP_ColName, GriP_AllowRemove, GriP_AllowOrderBy, GriP_OrderByDesc, GriP_Alignment, GriP_Jump, GriP_ShowHeading, GriP_ShowSelectAsGif, Grip_System, GriP_CreatedBy, GriP_CreatedDate, GriP_UpdatedBy, GriP_UpdatedDate, GriP_TimeStamp, GriP_Deleted, GriP_CustomAction, GriP_CustomIDField, GriP_ViewMode, GriP_Component, Grip_DeviceID, GriP_CreateScript, GriP_DefaultOrderBy, GriP_CustomFunction, GriP_CustomEditsIDFK, GriP_ScreenObjectsIDFK)
VALUES (@GriPID, 'CaseGrid', 3, 'case_priority', NULL, 'Y','','','','','', NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 234, @tableID)

exec @GriPID = eware_get_Identity_Id @Table_Name = 'Custom_lists'
INSERT INTO Custom_lists (GriP_GridPropsId, GriP_GridName, GriP_Order, GriP_ColName, GriP_AllowRemove, GriP_AllowOrderBy, GriP_OrderByDesc, GriP_Alignment, GriP_Jump, GriP_ShowHeading, GriP_ShowSelectAsGif, Grip_System, GriP_CreatedBy, GriP_CreatedDate, GriP_UpdatedBy, GriP_UpdatedDate, GriP_TimeStamp, GriP_Deleted, GriP_CustomAction, GriP_CustomIDField, GriP_ViewMode, GriP_Component, Grip_DeviceID, GriP_CreateScript, GriP_DefaultOrderBy, GriP_CustomFunction, GriP_CustomEditsIDFK, GriP_ScreenObjectsIDFK)
VALUES (@GriPID, 'CaseGrid', 4, 'case_targetver', NULL, 'Y', 'Y','','','','', NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 163, @tableID)

exec @GriPID = eware_get_Identity_Id @Table_Name = 'Custom_lists'
INSERT INTO Custom_lists (GriP_GridPropsId, GriP_GridName, GriP_Order, GriP_ColName, GriP_AllowRemove, GriP_AllowOrderBy, GriP_OrderByDesc, GriP_Alignment, GriP_Jump, GriP_ShowHeading, GriP_ShowSelectAsGif, Grip_System, GriP_CreatedBy, GriP_CreatedDate, GriP_UpdatedBy, GriP_UpdatedDate, GriP_TimeStamp, GriP_Deleted, GriP_CustomAction, GriP_CustomIDField, GriP_ViewMode, GriP_Component, Grip_DeviceID, GriP_CreateScript, GriP_DefaultOrderBy, GriP_CustomFunction, GriP_CustomEditsIDFK, GriP_ScreenObjectsIDFK)
VALUES (@GriPID, 'CaseGrid', 5, 'comp_name', NULL,'','','', 'Company','','', NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 77, @tableID)

exec @GriPID = eware_get_Identity_Id @Table_Name = 'Custom_lists'
INSERT INTO Custom_lists (GriP_GridPropsId, GriP_GridName, GriP_Order, GriP_ColName, GriP_AllowRemove, GriP_AllowOrderBy, GriP_OrderByDesc, GriP_Alignment, GriP_Jump, GriP_ShowHeading, GriP_ShowSelectAsGif, Grip_System, GriP_CreatedBy, GriP_CreatedDate, GriP_UpdatedBy, GriP_UpdatedDate, GriP_TimeStamp, GriP_Deleted, GriP_CustomAction, GriP_CustomIDField, GriP_ViewMode, GriP_Component, Grip_DeviceID, GriP_CreateScript, GriP_DefaultOrderBy, GriP_CustomFunction, GriP_CustomEditsIDFK, GriP_ScreenObjectsIDFK)
VALUES (@GriPID, 'CaseGrid', 6, 'case_productid', NULL, 'Y', 'Y','','','','', NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 184, @tableID)

exec @GriPID = eware_get_Identity_Id @Table_Name = 'Custom_lists'
INSERT INTO Custom_lists (GriP_GridPropsId, GriP_GridName, GriP_Order, GriP_ColName, GriP_AllowRemove, GriP_AllowOrderBy, GriP_OrderByDesc, GriP_Alignment, GriP_Jump, GriP_ShowHeading, GriP_ShowSelectAsGif, Grip_System, GriP_CreatedBy, GriP_CreatedDate, GriP_UpdatedBy, GriP_UpdatedDate, GriP_TimeStamp, GriP_Deleted, GriP_CustomAction, GriP_CustomIDField, GriP_ViewMode, GriP_Component, Grip_DeviceID, GriP_CreateScript, GriP_DefaultOrderBy, GriP_CustomFunction, GriP_CustomEditsIDFK, GriP_ScreenObjectsIDFK)
VALUES (@GriPID, 'CaseGrid', 7, 'case_description', NULL,'','','','','','', NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 86, @tableID)

exec @GriPID = eware_get_Identity_Id @Table_Name = 'Custom_lists'
INSERT INTO Custom_lists (GriP_GridPropsId, GriP_GridName, GriP_Order, GriP_ColName, GriP_AllowRemove, GriP_AllowOrderBy, GriP_OrderByDesc, GriP_Alignment, GriP_Jump, GriP_ShowHeading, GriP_ShowSelectAsGif, Grip_System, GriP_CreatedBy, GriP_CreatedDate, GriP_UpdatedBy, GriP_UpdatedDate, GriP_TimeStamp, GriP_Deleted, GriP_CustomAction, GriP_CustomIDField, GriP_ViewMode, GriP_Component, Grip_DeviceID, GriP_CreateScript, GriP_DefaultOrderBy, GriP_CustomFunction, GriP_CustomEditsIDFK, GriP_ScreenObjectsIDFK)
VALUES (@GriPID, 'CaseGrid', 8, 'case_assigneduserid', NULL, 'Y','','','','','', NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 224, @tableID)

exec @GriPID = eware_get_Identity_Id @Table_Name = 'Custom_lists'
INSERT INTO Custom_lists (GriP_GridPropsId, GriP_GridName, GriP_Order, GriP_ColName, GriP_AllowRemove, GriP_AllowOrderBy, GriP_OrderByDesc, GriP_Alignment, GriP_Jump, GriP_ShowHeading, GriP_ShowSelectAsGif, Grip_System, GriP_CreatedBy, GriP_CreatedDate, GriP_UpdatedBy, GriP_UpdatedDate, GriP_TimeStamp, GriP_Deleted, GriP_CustomAction, GriP_CustomIDField, GriP_ViewMode, GriP_Component, Grip_DeviceID, GriP_CreateScript, GriP_DefaultOrderBy, GriP_CustomFunction, GriP_CustomEditsIDFK, GriP_ScreenObjectsIDFK)
VALUES (@GriPID, 'CaseGrid', 9, 'case_stage', NULL, 'Y','','','','','', NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 233, @tableID)

exec @GriPID = eware_get_Identity_Id @Table_Name = 'Custom_lists'
INSERT INTO Custom_lists (GriP_GridPropsId, GriP_GridName, GriP_Order, GriP_ColName, GriP_AllowRemove, GriP_AllowOrderBy, GriP_OrderByDesc, GriP_Alignment, GriP_Jump, GriP_ShowHeading, GriP_ShowSelectAsGif, Grip_System, GriP_CreatedBy, GriP_CreatedDate, GriP_UpdatedBy, GriP_UpdatedDate, GriP_TimeStamp, GriP_Deleted, GriP_CustomAction, GriP_CustomIDField, GriP_ViewMode, GriP_Component, Grip_DeviceID, GriP_CreateScript, GriP_DefaultOrderBy, GriP_CustomFunction, GriP_CustomEditsIDFK, GriP_ScreenObjectsIDFK)
VALUES (@GriPID, 'CaseGrid', 10, 'case_secterr', NULL, 'Y', NULL, 'CENTER', 'case', 'Y', NULL, NULL, -1, '1999-12-11 15:52:00.000', -1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 571, @tableID)

exec @GriPID = eware_get_Identity_Id @Table_Name = 'Custom_lists'
INSERT INTO Custom_lists (GriP_GridPropsId, GriP_GridName, GriP_Order, GriP_ColName, GriP_AllowRemove, GriP_AllowOrderBy, GriP_OrderByDesc, GriP_Alignment, GriP_Jump, GriP_ShowHeading, GriP_ShowSelectAsGif, Grip_System, GriP_CreatedBy, GriP_CreatedDate, GriP_UpdatedBy, GriP_UpdatedDate, GriP_TimeStamp, GriP_Deleted, GriP_CustomAction, GriP_CustomIDField, GriP_ViewMode, GriP_Component, Grip_DeviceID, GriP_CreateScript, GriP_DefaultOrderBy, GriP_CustomFunction, GriP_CustomEditsIDFK, GriP_ScreenObjectsIDFK)
VALUES (@GriPID, 'CaseGrid', 1, 'case_status', NULL, 'Y', NULL, 'CENTER', 'runtabgroup', NULL, NULL, NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, 'case', 'case_caseid', 'GIF', NULL, 2, NULL, NULL, NULL, 232, @tableID)

exec @GriPID = eware_get_Identity_Id @Table_Name = 'Custom_lists'
INSERT INTO Custom_lists (GriP_GridPropsId, GriP_GridName, GriP_Order, GriP_ColName, GriP_AllowRemove, GriP_AllowOrderBy, GriP_OrderByDesc, GriP_Alignment, GriP_Jump, GriP_ShowHeading, GriP_ShowSelectAsGif, Grip_System, GriP_CreatedBy, GriP_CreatedDate, GriP_UpdatedBy, GriP_UpdatedDate, GriP_TimeStamp, GriP_Deleted, GriP_CustomAction, GriP_CustomIDField, GriP_ViewMode, GriP_Component, Grip_DeviceID, GriP_CreateScript, GriP_DefaultOrderBy, GriP_CustomFunction, GriP_CustomEditsIDFK, GriP_ScreenObjectsIDFK)
VALUES (@GriPID, 'CaseGrid', 2, 'case_referenceid', NULL, 'N', NULL, NULL, 'runtabgroup', NULL, NULL, NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, 'Case', 'case_caseid', NULL, NULL, 2, NULL, NULL, NULL, 160, @tableID)

exec @GriPID = eware_get_Identity_Id @Table_Name = 'Custom_lists'
INSERT INTO Custom_lists (GriP_GridPropsId, GriP_GridName, GriP_Order, GriP_ColName, GriP_AllowRemove, GriP_AllowOrderBy, GriP_OrderByDesc, GriP_Alignment, GriP_Jump, GriP_ShowHeading, GriP_ShowSelectAsGif, Grip_System, GriP_CreatedBy, GriP_CreatedDate, GriP_UpdatedBy, GriP_UpdatedDate, GriP_TimeStamp, GriP_Deleted, GriP_CustomAction, GriP_CustomIDField, GriP_ViewMode, GriP_Component, Grip_DeviceID, GriP_CreateScript, GriP_DefaultOrderBy, GriP_CustomFunction, GriP_CustomEditsIDFK, GriP_ScreenObjectsIDFK)
VALUES (@GriPID, 'CaseGrid', 3, 'comp_name', NULL, 'Y', NULL, NULL, 'runtabgroup', NULL, NULL, NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, 'Company', 'Comp_Companyid', NULL, NULL, 2, NULL, NULL, NULL, 77, @tableID)

exec @GriPID = eware_get_Identity_Id @Table_Name = 'Custom_lists'
INSERT INTO Custom_lists (GriP_GridPropsId, GriP_GridName, GriP_Order, GriP_ColName, GriP_AllowRemove, GriP_AllowOrderBy, GriP_OrderByDesc, GriP_Alignment, GriP_Jump, GriP_ShowHeading, GriP_ShowSelectAsGif, Grip_System, GriP_CreatedBy, GriP_CreatedDate, GriP_UpdatedBy, GriP_UpdatedDate, GriP_TimeStamp, GriP_Deleted, GriP_CustomAction, GriP_CustomIDField, GriP_ViewMode, GriP_Component, Grip_DeviceID, GriP_CreateScript, GriP_DefaultOrderBy, GriP_CustomFunction, GriP_CustomEditsIDFK, GriP_ScreenObjectsIDFK)
VALUES (@GriPID, 'CaseGrid', 4, 'case_description', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 86, @tableID)

exec @GriPID = eware_get_Identity_Id @Table_Name = 'Custom_lists'
INSERT INTO Custom_lists (GriP_GridPropsId, GriP_GridName, GriP_Order, GriP_ColName, GriP_AllowRemove, GriP_AllowOrderBy, GriP_OrderByDesc, GriP_Alignment, GriP_Jump, GriP_ShowHeading, GriP_ShowSelectAsGif, Grip_System, GriP_CreatedBy, GriP_CreatedDate, GriP_UpdatedBy, GriP_UpdatedDate, GriP_TimeStamp, GriP_Deleted, GriP_CustomAction, GriP_CustomIDField, GriP_ViewMode, GriP_Component, Grip_DeviceID, GriP_CreateScript, GriP_DefaultOrderBy, GriP_CustomFunction, GriP_CustomEditsIDFK, GriP_ScreenObjectsIDFK)
VALUES (@GriPID, 'CaseGrid', 5, 'case_assigneduserid', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 224, 226)

exec @GriPID = eware_get_Identity_Id @Table_Name = 'Custom_lists'
INSERT INTO Custom_lists (GriP_GridPropsId, GriP_GridName, GriP_Order, GriP_ColName, GriP_AllowRemove, GriP_AllowOrderBy, GriP_OrderByDesc, GriP_Alignment, GriP_Jump, GriP_ShowHeading, GriP_ShowSelectAsGif, Grip_System, GriP_CreatedBy, GriP_CreatedDate, GriP_UpdatedBy, GriP_UpdatedDate, GriP_TimeStamp, GriP_Deleted, GriP_CustomAction, GriP_CustomIDField, GriP_ViewMode, GriP_Component, Grip_DeviceID, GriP_CreateScript, GriP_DefaultOrderBy, GriP_CustomFunction, GriP_CustomEditsIDFK, GriP_ScreenObjectsIDFK)
VALUES (@GriPID, 'CaseGrid', 1, 'case_status', NULL, 'Y', NULL, 'CENTER', 'runtabgroup', 'N', NULL, NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, 'case', 'case_caseid', 'GIF', NULL, 7, NULL, NULL, NULL, 232, @tableID)

exec @GriPID = eware_get_Identity_Id @Table_Name = 'Custom_lists'
INSERT INTO Custom_lists (GriP_GridPropsId, GriP_GridName, GriP_Order, GriP_ColName, GriP_AllowRemove, GriP_AllowOrderBy, GriP_OrderByDesc, GriP_Alignment, GriP_Jump, GriP_ShowHeading, GriP_ShowSelectAsGif, Grip_System, GriP_CreatedBy, GriP_CreatedDate, GriP_UpdatedBy, GriP_UpdatedDate, GriP_TimeStamp, GriP_Deleted, GriP_CustomAction, GriP_CustomIDField, GriP_ViewMode, GriP_Component, Grip_DeviceID, GriP_CreateScript, GriP_DefaultOrderBy, GriP_CustomFunction, GriP_CustomEditsIDFK, GriP_ScreenObjectsIDFK)
VALUES (@GriPID, 'CaseGrid', 2, 'case_referenceid', NULL, 'N', NULL, NULL, 'runtabgroup', NULL, NULL, NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, 'case', 'case_caseid', NULL, NULL, 7, NULL, NULL, NULL, 160, @tableID)

exec @GriPID = eware_get_Identity_Id @Table_Name = 'Custom_lists'
INSERT INTO Custom_lists (GriP_GridPropsId, GriP_GridName, GriP_Order, GriP_ColName, GriP_AllowRemove, GriP_AllowOrderBy, GriP_OrderByDesc, GriP_Alignment, GriP_Jump, GriP_ShowHeading, GriP_ShowSelectAsGif, Grip_System, GriP_CreatedBy, GriP_CreatedDate, GriP_UpdatedBy, GriP_UpdatedDate, GriP_TimeStamp, GriP_Deleted, GriP_CustomAction, GriP_CustomIDField, GriP_ViewMode, GriP_Component, Grip_DeviceID, GriP_CreateScript, GriP_DefaultOrderBy, GriP_CustomFunction, GriP_CustomEditsIDFK, GriP_ScreenObjectsIDFK)
VALUES (@GriPID, 'CaseGrid', 3, 'comp_name', NULL, 'Y', NULL, NULL, 'runtabgroup', NULL, NULL, NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, 'company', 'comp_companyid', NULL, NULL, 7, NULL, NULL, NULL, 77, @tableID)

exec @GriPID = eware_get_Identity_Id @Table_Name = 'Custom_lists'
INSERT INTO Custom_lists (GriP_GridPropsId, GriP_GridName, GriP_Order, GriP_ColName, GriP_AllowRemove, GriP_AllowOrderBy, GriP_OrderByDesc, GriP_Alignment, GriP_Jump, GriP_ShowHeading, GriP_ShowSelectAsGif, Grip_System, GriP_CreatedBy, GriP_CreatedDate, GriP_UpdatedBy, GriP_UpdatedDate, GriP_TimeStamp, GriP_Deleted, GriP_CustomAction, GriP_CustomIDField, GriP_ViewMode, GriP_Component, Grip_DeviceID, GriP_CreateScript, GriP_DefaultOrderBy, GriP_CustomFunction, GriP_CustomEditsIDFK, GriP_ScreenObjectsIDFK)
VALUES (@GriPID, 'CaseGrid', 4, 'case_description', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, NULL, NULL, NULL, NULL, 7, NULL, NULL, NULL, 86, @tableID)

exec @GriPID = eware_get_Identity_Id @Table_Name = 'Custom_lists'
INSERT INTO Custom_lists (GriP_GridPropsId, GriP_GridName, GriP_Order, GriP_ColName, GriP_AllowRemove, GriP_AllowOrderBy, GriP_OrderByDesc, GriP_Alignment, GriP_Jump, GriP_ShowHeading, GriP_ShowSelectAsGif, Grip_System, GriP_CreatedBy, GriP_CreatedDate, GriP_UpdatedBy, GriP_UpdatedDate, GriP_TimeStamp, GriP_Deleted, GriP_CustomAction, GriP_CustomIDField, GriP_ViewMode, GriP_Component, Grip_DeviceID, GriP_CreateScript, GriP_DefaultOrderBy, GriP_CustomFunction, GriP_CustomEditsIDFK, GriP_ScreenObjectsIDFK)
VALUES (@GriPID, 'CaseGrid', 5, 'case_assigneduserid', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, NULL, NULL, NULL, NULL, 7, NULL, NULL, NULL, 224, @tableID)

-------------------------------------------------------------------------------------

/*
This will fix the Case Grid List. This Script is only for CRM installs that have NOT been updated at any stage from 7.1 or earlier. This is for fresh 7.2 installs.

Use This query to check if it is all ok at the end
select * from Custom_Lists where GriP_GridName = N'CaseGrid'*/

Delete from Custom_Lists where GriP_GridName = N'CaseGrid'

declare @tableID int

select @TableId = CObj_TableId from Custom_ScreenObjects where CObj_Name = N'CaseGrid'

INSERT INTO Custom_lists (GriP_GridName, GriP_Order, GriP_ColName, GriP_AllowRemove, GriP_AllowOrderBy, GriP_OrderByDesc, GriP_Alignment, GriP_Jump, GriP_ShowHeading, GriP_ShowSelectAsGif, Grip_System, GriP_CreatedBy, GriP_CreatedDate, GriP_UpdatedBy, GriP_UpdatedDate, GriP_TimeStamp, GriP_Deleted, GriP_CustomAction, GriP_CustomIDField, GriP_ViewMode, GriP_Component, Grip_DeviceID, GriP_CreateScript, GriP_DefaultOrderBy, GriP_CustomFunction, GriP_CustomEditsIDFK, GriP_ScreenObjectsIDFK)

VALUES ('CaseGrid', 1, 'case_status', NULL, 'Y','', 'CENTER', 'Case','', 'Y', NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, NULL, NULL, 'GIF', NULL, NULL, NULL, NULL, NULL, 232, @tableID)
('CaseGrid', 2, 'case_referenceid', NULL, 'Y','','', 'Case','','', NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 160, @tableID)
('CaseGrid', 3, 'case_priority', NULL, 'Y','','','','','', NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 234, @tableID)
('CaseGrid', 4, 'case_targetver', NULL, 'Y', 'Y','','','','', NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 163, @tableID)
('CaseGrid', 5, 'comp_name', NULL,'','','', 'Company','','', NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 77, @tableID)
('CaseGrid', 6, 'case_productid', NULL, 'Y', 'Y','','','','', NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 184, @tableID)
('CaseGrid', 7, 'case_description', NULL,'','','','','','', NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 86, @tableID)
('CaseGrid', 8, 'case_assigneduserid', NULL, 'Y','','','','','', NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 224, @tableID)
('CaseGrid', 9, 'case_stage', NULL, 'Y','','','','','', NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 233, @tableID)
('CaseGrid', 10, 'case_secterr', NULL, 'Y', NULL, 'CENTER', 'case', 'Y', NULL, NULL, -1, '1999-12-11 15:52:00.000', -1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 571, @tableID)
('CaseGrid', 1, 'case_status', NULL, 'Y', NULL, 'CENTER', 'runtabgroup', NULL, NULL, NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, 'case', 'case_caseid', 'GIF', NULL, 2, NULL, NULL, NULL, 232, @tableID)
('CaseGrid', 2, 'case_referenceid', NULL, 'N', NULL, NULL, 'runtabgroup', NULL, NULL, NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, 'Case', 'case_caseid', NULL, NULL, 2, NULL, NULL, NULL, 160, @tableID)
('CaseGrid', 3, 'comp_name', NULL, 'Y', NULL, NULL, 'runtabgroup', NULL, NULL, NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, 'Company', 'Comp_Companyid', NULL, NULL, 2, NULL, NULL, NULL, 77, @tableID)
('CaseGrid', 4, 'case_description', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 86, @tableID)
('CaseGrid', 5, 'case_assigneduserid', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 224, 226)
('CaseGrid', 1, 'case_status', NULL, 'Y', NULL, 'CENTER', 'runtabgroup', 'N', NULL, NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, 'case', 'case_caseid', 'GIF', NULL, 7, NULL, NULL, NULL, 232, @tableID)
('CaseGrid', 2, 'case_referenceid', NULL, 'N', NULL, NULL, 'runtabgroup', NULL, NULL, NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, 'case', 'case_caseid', NULL, NULL, 7, NULL, NULL, NULL, 160, @tableID)
('CaseGrid', 3, 'comp_name', NULL, 'Y', NULL, NULL, 'runtabgroup', NULL, NULL, NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, 'company', 'comp_companyid', NULL, NULL, 7, NULL, NULL, NULL, 77, @tableID)
('CaseGrid', 4, 'case_description', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, NULL, NULL, NULL, NULL, 7, NULL, NULL, NULL, 86, @tableID)
('CaseGrid', 5, 'case_assigneduserid', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 1, '1999-12-11 15:52:00.000', 1, '2013-10-02 16:43:00.000', '1999-12-11 15:52:00.000', NULL, NULL, NULL, NULL, NULL, 7, NULL, NULL, NULL, 224, @tableID)

-------------------------------------------------------------------------------------

/*
This will fix the Person Grid List. This Script is only for CRM installs that have NOT been updated at any stage from 7.1 or earlier. This is for fresh 7.2 installs.

Use This query to check if it is all ok at the end
select * from Custom_Lists where GriP_GridName = N'PersonGrid'*/

Delete from Custom_Lists where GriP_GridName = N'PersonGrid'

declare @TableID int

select @TableId = CObj_TableId from Custom_ScreenObjects where CObj_Name = N'PersonGrid'

INSERT INTO Custom_lists (GriP_GridName, GriP_Order, GriP_ColName, GriP_AllowRemove, GriP_AllowOrderBy, GriP_OrderByDesc, GriP_Alignment, GriP_Jump, GriP_ShowHeading, GriP_ShowSelectAsGif, Grip_System, GriP_CreatedBy, GriP_CreatedDate, GriP_UpdatedBy, GriP_UpdatedDate, GriP_TimeStamp, GriP_Deleted, GriP_CustomAction, GriP_CustomIDField, GriP_ViewMode, GriP_Component, Grip_DeviceID, GriP_CreateScript, GriP_DefaultOrderBy, GriP_CustomFunction, GriP_CustomEditsIDFK, GriP_ScreenObjectsIDFK )

VALUES ('PersonGrid', 2, 'Pers_FirstName', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2014-03-03 11:26:00.000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 9, @TableId),
('PersonGrid', 3, 'Comp_Name', NULL, 'Y', NULL, NULL, 'Company', NULL, NULL, NULL, NULL, NULL, NULL, '2014-03-03 11:26:00.000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 77, @TableId),
('PersonGrid', 5, 'Pers_PhoneFullNumber', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2014-03-03 11:26:00.000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 151, @TableId),
('PersonGrid', 6, 'Pers_EmailAddress', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, -1, '2014-03-03 11:26:00.000', '2014-03-03 11:26:00.000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, @TableId),
('PersonGrid', 1, 'Pers_LastName', NULL, 'Y', NULL, NULL, 'Person', NULL, NULL, NULL, NULL, NULL, NULL, '2014-03-03 11:26:00.000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 88, @TableId),
('PersonGrid', 7, 'pers_secterr', NULL, 'Y', NULL, NULL, 'person', 'Y', NULL, NULL, -1, '2014-03-03 11:26:00.000', -1, '2014-03-03 11:26:00.000', '2014-03-03 11:26:00.000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 575, @TableId),
('PersonGrid', 1, 'pers_fullname', NULL, 'Y', NULL, NULL, 'runtabgroup', NULL, NULL, NULL, 1, '2014-03-03 11:26:00.000', 1, '2014-03-03 11:26:00.000', '2014-03-03 11:26:00.000', NULL, 'person', 'pers_personid', NULL, NULL, 2, NULL, NULL, NULL, 150, @TableId),
('PersonGrid', 2, 'pers_title', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2014-03-03 11:26:00.000', 1, '2014-03-03 11:26:00.000', '2014-03-03 11:26:00.000', NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 6, @TableId),
('PersonGrid', 3, 'comp_name', NULL, 'Y', NULL, NULL, 'runtabgroup', NULL, NULL, NULL, 1, '2014-03-03 11:26:00.000', 1, '2014-03-03 11:26:00.000', '2014-03-03 11:26:00.000', NULL, 'company', 'comp_companyid', NULL, NULL, 2, NULL, NULL, NULL, 77, @TableId),
('PersonGrid', 4, 'pers_phonefullnumber', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2014-03-03 11:26:00.000', 1, '2014-03-03 11:26:00.000', '2014-03-03 11:26:00.000', NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 151, @TableId),
('PersonGrid', 10, 'Pers_AccountId', NULL, 'Y', NULL, 'CENTER', 'account', NULL, NULL, NULL, -1, '2014-03-03 11:26:00.000', NULL, '2014-03-03 11:26:00.000', '2014-03-03 11:26:00.000', NULL, NULL, NULL, 'GIF', NULL, NULL, NULL, NULL, NULL, 11094, @TableId)

--------------------------------------------------------------------------------------

Status:

This issue is resolved in Sage CRM v7.2e. However, if changes to the list have been made prior to the upgrade, the users will have to recreate the list - deleting all of the old links and re-adding them.