Uploaded image for project: 'New Features 2017'
  1. New Features 2017
  2. NF-4634

Report - Admin User - Enrollment record shows No records

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Bug Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: UI Refresh
    • Labels:
    • Environment:
      Others
    • Bug Type:
      Functional
    • Bug Severity:
      Critical
    • Level:
      Admin
    • Module:
      BenAdmin - Report
    • Reported by:
      Harbinger
    • Company:
      All Clients/Multiple Clients
    • Item State:
      Stage QA - Production Deployment on Hold

      Description

      Environment - Azure

      1) Admin user does not have rights of All classes.
      2) Admin Runs Enrollment Report with All selection
      3) No records shows on Report.

      If for same report Admin Set None and Run the report then it is running successfully.

      CC ; Prasanna Karlekar [~parmeshwar.jumbade]

        Attachments

        1. 4634.jpg
          4634.jpg
          104 kB
        2. NF-4634 code review check list.doc
          23 kB
        3. Test Scenarios.xls
          12 kB
        4. Test Scenarios-New.xls
          14 kB

          Issue Links

            Activity

            Hide
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Hi Hrishikesh Deshpande,

            Could you please provide Admin Login details, from which you were verifying this.

            Thank you!

            cc:Gaurav Sodani

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Hi Hrishikesh Deshpande , Could you please provide Admin Login details, from which you were verifying this. Thank you! cc: Gaurav Sodani
            Hide
            nidhi.kaul Nidhi Kaul (Inactive) added a comment -

            Prasanna Karlekar
            Does this need to be assigned to Hrishikesh?

            Thanks,
            Nidhi.

            Show
            nidhi.kaul Nidhi Kaul (Inactive) added a comment - Prasanna Karlekar Does this need to be assigned to Hrishikesh? Thanks, Nidhi.
            Hide
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Hrishikesh Deshpande -

            Please provide admin login credentials.

            Thank you!

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Hrishikesh Deshpande - Please provide admin login credentials. Thank you!
            Hide
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

            Admin ID - admk
            Company - Kindercare

            You can Create new report for Basic Life plan.

            First select All Classes and Run report. Observe that there is No records on report.
            Then select None Classes and Run report. Observe that there is Records on report.

            Show
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - Admin ID - admk Company - Kindercare You can Create new report for Basic Life plan. First select All Classes and Run report. Observe that there is No records on report. Then select None Classes and Run report. Observe that there is Records on report.
            Hide
            Prashant.samal Prashant Samal (Inactive) added a comment -

            Hello,

            Faced similar issue on https://workterra.atlassian.net/browse/WT-12131

            Thanks
            S Prashant

            Show
            Prashant.samal Prashant Samal (Inactive) added a comment - Hello, Faced similar issue on https://workterra.atlassian.net/browse/WT-12131 Thanks S Prashant
            Hide
            nidhi.kaul Nidhi Kaul (Inactive) added a comment - - edited

            Harshada Borole
            What is the status on this? The development was supposed to complete yesterday.

            Thanks,
            Nidhi.

            SatyaGaurav Sodani

            Show
            nidhi.kaul Nidhi Kaul (Inactive) added a comment - - edited Harshada Borole What is the status on this? The development was supposed to complete yesterday. Thanks, Nidhi. Satya Gaurav Sodani
            Hide
            harshada.borole Harshada Borole (Inactive) added a comment -

            Hi Nidhi Kaul,

            Unit testing was pending yesterday but because of Database server maintenance it got extended today.

            Thank you,
            Harshada

            cc: Prasanna Karlekar, Jyoti Agrawal

            Show
            harshada.borole Harshada Borole (Inactive) added a comment - Hi Nidhi Kaul , Unit testing was pending yesterday but because of Database server maintenance it got extended today. Thank you, Harshada cc: Prasanna Karlekar , Jyoti Agrawal
            Hide
            sumeet.kolge Sumeet.Kolge (Inactive) added a comment -

            Hi Harshada Borole,

            Verified this issue on Codemap following are our observations:
            1, Created new admin
            2. Login as admin>> in reports>> standard reports>> select All Classes and Run report. Observe that there is No records on report.
            then try by selecting None Classes and Run report. Observe that there is Records on report.

            Request you to please look into this issue. Thank you!

            -------------------------------------------------------------------------
            CC: Mandar Kulkarni, Satya, Sachin Hingole

            Show
            sumeet.kolge Sumeet.Kolge (Inactive) added a comment - Hi Harshada Borole , Verified this issue on Codemap following are our observations: 1, Created new admin 2. Login as admin>> in reports>> standard reports>> select All Classes and Run report. Observe that there is No records on report. then try by selecting None Classes and Run report. Observe that there is Records on report. Request you to please look into this issue. Thank you! ------------------------------------------------------------------------- CC: Mandar Kulkarni , Satya , Sachin Hingole
            Hide
            nidhi.kaul Nidhi Kaul (Inactive) added a comment -

            Harshada Borole
            3c's are missing originally.

            Show
            nidhi.kaul Nidhi Kaul (Inactive) added a comment - Harshada Borole 3c's are missing originally.
            Hide
            harshada.borole Harshada Borole (Inactive) added a comment -

            Below are the 3C's:

            Corncern:- Enrollment record shows No records.

            Cause:- When Classes for company admin is set to none and classes selected in report is all/specific, on pulling report from admin login, incorrect query was created. Due to incorrect query, records were not getting fetched.

            Correction:- Have fixed the query to fetch proper record.

            Affected files:-
            OES_UDF_GetEmployeeWhereClause.sql

            Tested scenarios:-
            PFA: Test Scenarios.xls

            Show
            harshada.borole Harshada Borole (Inactive) added a comment - Below are the 3C's: Corncern:- Enrollment record shows No records. Cause:- When Classes for company admin is set to none and classes selected in report is all/specific, on pulling report from admin login, incorrect query was created. Due to incorrect query, records were not getting fetched. Correction:- Have fixed the query to fetch proper record. Affected files:- OES_UDF_GetEmployeeWhereClause.sql Tested scenarios:- PFA: Test Scenarios.xls
            Hide
            nidhi.kaul Nidhi Kaul (Inactive) added a comment -

            Harshada Borole

            Has anything been corrected after Sumeet tested it?
            Thanks,
            Nidhi

            Show
            nidhi.kaul Nidhi Kaul (Inactive) added a comment - Harshada Borole Has anything been corrected after Sumeet tested it? Thanks, Nidhi
            Hide
            harshada.borole Harshada Borole (Inactive) added a comment -

            Hi Nidhi Kaul,

            Nothing has been corrected after Sumeet tested.
            We verified at our end and we can see records in the report.

            Sumeet.Kolge Could you please verify it once again and let me know if you stil cannot see the data.

            cc:Jyoti Agrawal,Prasanna Karlekar

            Show
            harshada.borole Harshada Borole (Inactive) added a comment - Hi Nidhi Kaul , Nothing has been corrected after Sumeet tested. We verified at our end and we can see records in the report. Sumeet.Kolge Could you please verify it once again and let me know if you stil cannot see the data. cc: Jyoti Agrawal , Prasanna Karlekar
            Hide
            sumeet.kolge Sumeet.Kolge (Inactive) added a comment - - edited

            Hi Sachin Hingole, Nidhi Kaul, Harshada Borole,

            We tried the below scenarios on codemap

            1. created company admin with flag "Show EE with selected class combination only" flag to "No"

            2. By CA login >> in reports>> standard reports>> enrollment>> if we try to pull report with none classes we can see the report.

            However if we select particular classes ( say all classes ) we cannot pull the report.

            We need to discuss this issue internally weather this customization or behavior is correct or not. Thanks !

            ---------------------------------------------------------------------------------------
            CC: Mandar Kulkarni, Sachin Hingole, Satya, Nidhi Kaul, Prasanna Karlekar

            Show
            sumeet.kolge Sumeet.Kolge (Inactive) added a comment - - edited Hi Sachin Hingole , Nidhi Kaul , Harshada Borole , We tried the below scenarios on codemap 1. created company admin with flag "Show EE with selected class combination only" flag to "No" 2. By CA login >> in reports>> standard reports>> enrollment>> if we try to pull report with none classes we can see the report. However if we select particular classes ( say all classes ) we cannot pull the report. We need to discuss this issue internally weather this customization or behavior is correct or not. Thanks ! --------------------------------------------------------------------------------------- CC: Mandar Kulkarni , Sachin Hingole , Satya , Nidhi Kaul , Prasanna Karlekar
            Hide
            nidhi.kaul Nidhi Kaul (Inactive) added a comment -

            Prasanna Karlekar
            By when will this be fixed?

            Nidhi.

            Show
            nidhi.kaul Nidhi Kaul (Inactive) added a comment - Prasanna Karlekar By when will this be fixed? Nidhi.
            Hide
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Nidhi Kaul -
            This is fixed and review has been done.

            Thank you!

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Nidhi Kaul - This is fixed and review has been done. Thank you!
            Hide
            harshada.borole Harshada Borole (Inactive) added a comment -

            Below are the 3C's:

            Concern: Report - Admin User - Enrollment record shows No records
            Cause: When "Show EE with selected class combination only" is set to NO while creating Company Admin and classes selected in report is all/specific,incorrect query was getting formed.Due to incorrect query,records were not getting pulled.
            Correction: Have fixed this issue to fetch proper query when "Show EE with selected class combination only" flag is set to "No" to fetch proper records.

            Affected file's:
            OES_UDF_GetEmployeeWhereClause.sql

            Test Scenario's:
            Please refer the attached .xls file.
            Test Scenarios-New.xls

            Show
            harshada.borole Harshada Borole (Inactive) added a comment - Below are the 3C's: Concern: Report - Admin User - Enrollment record shows No records Cause: When "Show EE with selected class combination only" is set to NO while creating Company Admin and classes selected in report is all/specific,incorrect query was getting formed.Due to incorrect query,records were not getting pulled. Correction: Have fixed this issue to fetch proper query when "Show EE with selected class combination only" flag is set to "No" to fetch proper records. Affected file's: OES_UDF_GetEmployeeWhereClause.sql Test Scenario's: Please refer the attached .xls file. Test Scenarios-New.xls
            Hide
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - - edited

            Hi Harshada Borole,

            Verified on codemap
            Company- Kindercare
            Browser - IE 11, Chrome

            Admin - kindercare/Password@1

            Verified by admin and partner login
            Pulling Admin enrollment reporting throwing error
            PFA :

            Hence reopening this jira

            Thanks,
            Jayshree

            cc :Rakesh Roy Prasad Pise Sachin Hingole Hrishikesh Deshpande

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - - edited Hi Harshada Borole , Verified on codemap Company- Kindercare Browser - IE 11, Chrome Admin - kindercare/Password@1 Verified by admin and partner login Pulling Admin enrollment reporting throwing error PFA : Hence reopening this jira Thanks, Jayshree cc : Rakesh Roy Prasad Pise Sachin Hingole Hrishikesh Deshpande
            Hide
            nidhi.kaul Nidhi Kaul (Inactive) added a comment - - edited

            Please check this on priority.

            Prasanna Karlekar
            Nidhi.

            Show
            nidhi.kaul Nidhi Kaul (Inactive) added a comment - - edited Please check this on priority. Prasanna Karlekar Nidhi.
            Hide
            harshada.borole Harshada Borole (Inactive) added a comment - - edited

            Hi Jayshree Nagpure,

            This was related to Standard Report and not Admin Enrollment Report.
            Could you please verify the fix once again?

            Thank you,
            Harshada

            cc:Prasanna Karlekar,Jyoti Agrawal,Nidhi Kaul

            Show
            harshada.borole Harshada Borole (Inactive) added a comment - - edited Hi Jayshree Nagpure , This was related to Standard Report and not Admin Enrollment Report. Could you please verify the fix once again? Thank you, Harshada cc: Prasanna Karlekar , Jyoti Agrawal , Nidhi Kaul
            Hide
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Hi Harshada Borole,

            Verified on Codemap
            Company - Kindercare
            Login - Admin and Partner

            Pre-requisites - Created admin does not have rights of all classes.

            Verified below scenario with admin and partner :
            1) Verified enrollment report with all classes - Records shown
            2) Verified enrollment report with classes as none - Records shown
            3) Verified enrollment report with some classes - Records shown

            Working fine, marking item state as LB QA on hold.

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Hi Harshada Borole , Verified on Codemap Company - Kindercare Login - Admin and Partner Pre-requisites - Created admin does not have rights of all classes. Verified below scenario with admin and partner : 1) Verified enrollment report with all classes - Records shown 2) Verified enrollment report with classes as none - Records shown 3) Verified enrollment report with some classes - Records shown Working fine, marking item state as LB QA on hold.
            Hide
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

            This Issue is Fixed on Pre-Prod.

            Show
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - This Issue is Fixed on Pre-Prod.
            Hide
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Verified on Production
            Company - JE Dunn For HSPL
            Login - Admin and Partner

            Pre-requisites - Created admin does not have rights of all classes.

            Verified below scenario with admin and partner :
            1) Verified enrollment report with all classes - Records shown
            2) Verified enrollment report with classes as none - Records shown
            3) Verified enrollment report with some classes - Records shown

            Working fine, hence closing this jira.

            Thanks,
            Jayshree

            cc - Sachin Hingole Prasad Pise Rakesh Roy Hrishikesh Deshpande

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Verified on Production Company - JE Dunn For HSPL Login - Admin and Partner Pre-requisites - Created admin does not have rights of all classes. Verified below scenario with admin and partner : 1) Verified enrollment report with all classes - Records shown 2) Verified enrollment report with classes as none - Records shown 3) Verified enrollment report with some classes - Records shown Working fine, hence closing this jira. Thanks, Jayshree cc - Sachin Hingole Prasad Pise Rakesh Roy Hrishikesh Deshpande

              People

              Assignee:
              jayshree.nagpure Jayshree Nagpure (Inactive)
              Reporter:
              hrishikesh.deshpande Hrishikesh Deshpande (Inactive)
              Developer:
              Harshada Borole (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 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 - 57.05h
                  57.05h