How to recover the Progress Bar column image lost in MyItems

Version 4

    Details

     

    This article shows how to recover the Progress Bar column image that has been accidentally deleted in the grid WebUI.MyItem.

    As the application warns, if we try to remove the column, there is no way to put it back.

     

     


    Resolution

    This workaround is only suitable in the case that there is not other solution. Please try to reset IIS or reboot the server to make sure that there is no other solution.

    It is not recommended to make changes directly to the database, but in this case there is no  other option. Back up the database before executing  this procedure, as it is an unsupported solution and it is preferable to  cover all possible problems. This solution has been tested in our labs, but it is better to do it  safely.

    1. Go to the database and execute from the SQL Server Management Studio the content of the file 14562.sql attached to the article. This will delete the current  definition of the grid "WebUI.MyItems" and will re-create it again as default.

      This is the content of the attached file, but it is preferable copying it from the file:

      SELECT [Name]
            ,[Perspective]
            ,[TableRef]
            ,[DefinitionKind]
            ,'{Name:"WebUI.MyItems",Perspective:"(Base)",DisplayName:"WebUI.MyItems",TableRef:"FRS_MyItem#",Joins:null,Description:"",Editable:false,Columns:[{Name:"0",Alignment:"Left",Width:50,FollowGridResize:0,FieldRef:"ParentID",Id:"0",Header:"ID",WordWrap:true,NotSortable:false,NotGroupedBy:false,StyleExpression:null,ColumnRenderer:null,FormattingExpr:null},{Name:"summary",Alignment:"Left",Width:330,FollowGridResize:0,FieldRef:"DisplayText",Id:"summary",Header:"Summary",WordWrap:true,NotSortable:false,NotGroupedBy:false,StyleExpression:null,ColumnRenderer:null,FormattingExpr:null},{Name:"1",Alignment:"Left",Width:150,FollowGridResize:0,FieldRef:"ParentObjectType",Id:"1",Header:"Type",WordWrap:false,NotSortable:false,NotGroupedBy:false,StyleExpression:null,ColumnRenderer:null,FormattingExpr:null},{Name:"progress",Alignment:"Left",Width:100,FollowGridResize:0,FieldRef:"Status",Id:"progress",Header:"Progress",WordWrap:false,NotSortable:false,NotGroupedBy:false,StyleExpression:null,ColumnRenderer:null,FormattingExpr:null},{Name:"2",Alignment:"Left",Width:150,FollowGridResize:0,FieldRef:"DueDateTime",Id:"2",Header:"Due
      Date",WordWrap:false,NotSortable:false,NotGroupedBy:true,StyleExpression:null,ColumnRenderer:null,FormattingExpr:null},{Name:"3",Alignment:"Left",Width:100,FollowGridResize:0,FieldRef:"Status",Id:"3",Header:"Status",WordWrap:false,NotSortable:false,NotGroupedBy:false,StyleExpression:null,ColumnRenderer:null,FormattingExpr:null},{Name:"createdon",Alignment:"Left",Width:150,FollowGridResize:0,FieldRef:"ParentCreatedDateTime",Id:"createdon",Header:"Created On",WordWrap:false,NotSortable:false,NotGroupedBy:true,StyleExpression:null,ColumnRenderer:null,FormattingExpr:null},{Name:"4",Alignment:"Left",Width:150,FollowGridResize:0,FieldRef:"ParentLastModDateTime",Id:"4",Header:"Modified On",WordWrap:false,NotSortable:false,NotGroupedBy:true,StyleExpression:null,ColumnRenderer:null,FormattingExpr:null}],Condition:{Tree:{Op:"NotEqual",Left:{FieldIndex:0,Details:null,Kind:"Field"},Right:{Value:"Deleted",Kind:"Literal"},Kind:"Binary"},FieldRefs:["Status"]},System:false,DefaultGroupByName:"",DefaultSortField:"ParentCreatedDateTime",DefaultSortDir:"DESC",DefaultSortFields:null,FilterFields:null,LinkColumnField:null,LinkColumnConfig:null,MaxRows:1000,DefaultPageSize:{Workspace:0,Dashboard:10,Popup:10,ChildPanel:10},TemplateName:null,IsFrsOwned:true,RowFormattingExpr:null,IsCommonlyUsed:false,IsOutOfTheBox:false}' as [Definition]
            ,[LastModified]
            ,[ModifiedBy]
            ,[Revision]
            ,[MergedFrom]
            ,[IsFrsOwned]
            ,[IsCommonlyUsed]
            ,[IsOutOfTheBox]
      INTO #Frs_def_grids_temp
      FROM [dbo].[Frs_def_grids]
      WHERE Name LIKE 'WebUI.MyItems'

      DELETE FROM [dbo].[Frs_def_grids] WHERE Name LIKE 'WebUI.MyItems'
       
      INSERT INTO [dbo].[Frs_def_grids] SELECT * FROM #Frs_def_grids_temp

      DROP TABLE #Frs_def_grids_temp

    2. Remove the cache, this will force the application to reload the form



    3. Check My Items