Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-11395

LB->Quick links->System Utilization Report->After deselecting all user type, User name still shown.

    Details

    • Type: Bug
    • Status: Resolution Setting
    • Priority: Low
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
    • Environment:
      Production, Stage, QA
    • Bug Type:
      Functional
    • Bug Severity:
      Low
    • Level:
      Partner
    • Module:
      BenAdmin - Report
    • Reported by:
      Harbinger
    • Company:
      All Clients/Multiple Clients
    • Item State:
      LB QA - On Hold
    • Issue Importance:
      Q2
    • Sprint:
      WT Sprint 39 - Bugs

      Description

      environment: LB
      Login: Partner
      browser: Chrome

      steps:
      1.Home->Quick links->System Utilization Report
      2.Deselect all user type

      Actual result: After deselecting all user type, User name still shown.
      Expected Result:User name should not be shown

        Attachments

          Activity

          sanjana.jadhav Sanjana Jadhav (Inactive) created issue -
          Show
          sanjana.jadhav Sanjana Jadhav (Inactive) added a comment - CC: Rakesh Roy Prasad Pise Hrishikesh Deshpande Sachin Hingole
          harshada.borole Harshada Borole (Inactive) made changes -
          Field Original Value New Value
          Dev Due Date 18/Oct/2017
          gaurav.sodani Gaurav Sodani (Inactive) made changes -
          Sprint WT Sprint 39 - Bugs [ 90 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Assignee Harshada Borole [ harshada.borole ] Prasanna Karlekar [ prasanna ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Assignee Prasanna Karlekar [ prasanna ] Parmeshwar Jumbad [ parmeshwar.jumbade ]
          parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
          Status Open [ 1 ] In Development [ 10007 ]
          parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 18/Oct/17 09:33 AM
          • Time Spent:
            7h
             

            Code changes
            Internal discussion
            review request
            JIRA update

          prasanna Prasanna Karlekar (Inactive) made changes -
          Code Reviewed By Jyoti Agarwal [ 16704 ]
          Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208)
          prasanna Prasanna Karlekar (Inactive) made changes -
          Assignee Parmeshwar Jumbad [ parmeshwar.jumbade ] Jyoti Agrawal [ jyoti.agrawal ]
          Hide
          parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - - edited

          3CS:

          Concern: After deselecting all user type, User name still shown.

          Cause: code implementation not exist to handle this case.

          Coŕrection: After deselecting all user type this will display as empty and validation will not shown for username section but when we click on preview it will shown select username validation.

          While working on this we found below four problems:
          1. If user select employee role then it was always showing atleast one employee should select.
          2. If user select employee role user type along with other role types then it was not showing result of employees.
          3. If selected user type will not have list of users then it was showing select user.
          4. If user list is more than 1000 characters then it was throwing data-source error.

          Now we have resolved above both problems as follows.

          1. If user select only employee then it will show all employee in user name section and will not fire validation.
          2. If user select employee role type with combination of other roles then we have added "All Employee" as option in user name section. All we will get result based on the selection of user names.
          3. If selected user types not have any users to selection then it will show empty box of usernames. If employee selected in user type then will All employee will appear into section.
          4. Now we have extened limit of charactes and set to max so it will work for any number of users.

          Affected files:
          \OnlineEnrollment\04_Stored Procedures\dbo.OES_SP_GetSystemUtilizationInformation.StoredProcedure.sql
          \OnlineEnrollment\04_Stored Procedures\dbo.OES_SP_SystemUtilization.StoredProcedure.sql
          \Web Projects\BenAdmin\Areas\Report\Views\Report\DashboardReports\SystemUtilizationReport.cshtml

          Affected Areas: Quick link system utilization report.

          Tested Scenarios:
          1. Verified validations on different combinatios os select and deselect.
          2. Verified report output through preview report with different usernames and usertypes combinations.
          3. Verified list of usernames appering or not in case of selection of employee with other user types.
          4. Verified list of populated usernames in case of selection of multiple user roles.

          CC: Prasanna Karlekar

          Show
          parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - - edited 3CS : Concern : After deselecting all user type, User name still shown. Cause : code implementation not exist to handle this case. Coŕrection : After deselecting all user type this will display as empty and validation will not shown for username section but when we click on preview it will shown select username validation. While working on this we found below four problems: 1. If user select employee role then it was always showing atleast one employee should select. 2. If user select employee role user type along with other role types then it was not showing result of employees. 3. If selected user type will not have list of users then it was showing select user. 4. If user list is more than 1000 characters then it was throwing data-source error. Now we have resolved above both problems as follows. 1. If user select only employee then it will show all employee in user name section and will not fire validation. 2. If user select employee role type with combination of other roles then we have added "All Employee" as option in user name section. All we will get result based on the selection of user names. 3. If selected user types not have any users to selection then it will show empty box of usernames. If employee selected in user type then will All employee will appear into section. 4. Now we have extened limit of charactes and set to max so it will work for any number of users. Affected files : \OnlineEnrollment\04_Stored Procedures\dbo.OES_SP_GetSystemUtilizationInformation.StoredProcedure.sql \OnlineEnrollment\04_Stored Procedures\dbo.OES_SP_SystemUtilization.StoredProcedure.sql \Web Projects\BenAdmin\Areas\Report\Views\Report\DashboardReports\SystemUtilizationReport.cshtml Affected Areas : Quick link system utilization report. Tested Scenarios : 1. Verified validations on different combinatios os select and deselect. 2. Verified report output through preview report with different usernames and usertypes combinations. 3. Verified list of usernames appering or not in case of selection of employee with other user types. 4. Verified list of populated usernames in case of selection of multiple user roles. CC: Prasanna Karlekar
          prasanna Prasanna Karlekar (Inactive) logged work - 18/Oct/17 11:30 PM
          • Time Spent:
            0.5h
             

            Discussion on fix to be done

          jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
          Dev Due Date 18/Oct/2017 25/Oct/2017
          jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
          Assignee Jyoti Agrawal [ jyoti.agrawal ] Parmeshwar Jumbad [ parmeshwar.jumbade ]
          jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: Development(10200)Level 1 values: In Progress(10206)
          jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 24/Oct/17 06:11 PM
          • Time Spent:
            1.5h
             

            Code and functionality review, discussion on functionality with Prasanna

          prasanna Prasanna Karlekar (Inactive) logged work - 24/Oct/17 09:30 PM
          • Time Spent:
            0.25h
             

            Discussion on UI related issues

          jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
          Remaining Estimate 0h [ 0 ]
          Time Spent 1.5h [ 5400 ]
          Worklog Id 86221 [ 86221 ]
          parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
          Assignee Parmeshwar Jumbad [ parmeshwar.jumbade ] Jyoti Agrawal [ jyoti.agrawal ]
          parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
          Company All Clients/Multiple Clients [ 18434 ]
          Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
          Original Estimate 0h [ 0 ]
          parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 25/Oct/17 12:35 PM
          • Time Spent:
            1.5h
             

            Internal discussion, code changes, Unit testing & JIRA update

          parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
          Time Spent 1.5h [ 5400 ] 3h [ 10800 ]
          Worklog Id 86345 [ 86345 ]
          jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
          jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
          Assignee Jyoti Agrawal [ jyoti.agrawal ] Parmeshwar Jumbad [ parmeshwar.jumbade ]
          jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
          Dev Due Date 25/Oct/2017 26/Oct/2017
          parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
          Code Review Date 25/Oct/2017
          jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
          Time Spent 3h [ 10800 ] 3.25h [ 11700 ]
          Worklog Id 86507 [ 86507 ]
          jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
          Worklog Id 86507 [ 86507 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Time Spent 3.25h [ 11700 ] 3.5h [ 12600 ]
          Worklog Id 86594 [ 86594 ]
          parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
          Time Spent 3.5h [ 12600 ] 10.5h [ 37800 ]
          Worklog Id 86643 [ 86643 ]
          khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
          parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
          Assignee Parmeshwar Jumbad [ parmeshwar.jumbade ] Sachin Hingole [ sachin.hingole ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Assignee Sachin Hingole [ sachin.hingole ] Sanjana Jadhav [ sanjana.jadhav ]
          jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 26/Oct/17 05:44 PM - edited
          • Time Spent:
            0.25h
             

            Functionality and code review

          prasanna Prasanna Karlekar (Inactive) made changes -
          Time Spent 10.5h [ 37800 ] 11h [ 39600 ]
          Worklog Id 86907 [ 86907 ]
          satyap Satya made changes -
          Labels Standard_Report
          satyap Satya made changes -
          Environment_New LB [ 18444 ]
          sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
          Attachment WT-11395.png [ 67017 ]
          Hide
          sanjana.jadhav Sanjana Jadhav (Inactive) added a comment -

          Scenarios:

          1. Verified validations on different combinatios os select and deselect.-Pass
          2. Verified report output through preview report with different usernames and usertypes combinations.-Pass
          3. Verified list of usernames appering or not in case of selection of employee with other user types.-Pass
          4. Verified list of populated usernames in case of selection of multiple user roles.-Pass

          Working properly.Ready for stage.
          PFA,

          CC: Prasad Pise Rakesh Roy

          Thanks,
          Sanjana Jadhav

          Show
          sanjana.jadhav Sanjana Jadhav (Inactive) added a comment - Scenarios: 1. Verified validations on different combinatios os select and deselect.-Pass 2. Verified report output through preview report with different usernames and usertypes combinations.-Pass 3. Verified list of usernames appering or not in case of selection of employee with other user types.-Pass 4. Verified list of populated usernames in case of selection of multiple user roles.-Pass Working properly.Ready for stage. PFA, CC: Prasad Pise Rakesh Roy Thanks, Sanjana Jadhav
          sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
          sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
          Time Spent 11h [ 39600 ] 11.5h [ 41400 ]
          Worklog Id 89390 [ 89390 ]
          sanjana.jadhav Sanjana Jadhav (Inactive) logged work - 08/Nov/17 04:03 AM
          • Time Spent:
            0.5h
             

            Verified on LB.

          gaurav.sodani Gaurav Sodani (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
          gaurav.sodani Gaurav Sodani (Inactive) made changes -
          Environment LB [ 18444 ] Production,Stage,LB [ 18442, 18443, 18444 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status In LB Testing [ 10200 ] Resolution Setting [ 11616 ]
          Transition Time In Source Status Execution Times
          Parmeshwar Jumbad (Inactive) made transition -
          Open In Development
          14d 20h 33m 1
          Sachin Hingole (Inactive) made transition -
          In Development In LB Testing
          8d 2h 30m 1
          Sachin Hingole (Inactive) made transition -
          In LB Testing Resolution Setting
          192d 17h 9m 1

            People

            Assignee:
            sanjana.jadhav Sanjana Jadhav (Inactive)
            Reporter:
            sanjana.jadhav Sanjana Jadhav (Inactive)
            Developer:
            Harshada Borole (Inactive)
            QA:
            Sanjana Jadhav (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Dev Due Date:
              Code Review Date:

                Time Tracking

                Estimated:
                Original Estimate - 0h
                0h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 11.5h
                11.5h