[NF-4634] Report - Admin User - Enrollment record shows No records - Workterra Jira

Details

Type: Bug
Status: Closed
Priority: High
Resolution: Bug Fixed
Affects Version/s: None
Fix Version/s: None
Component/s: UI Refresh
Labels:
- Standard_Report

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

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Attachments

4634.jpg
104 kB
16/Dec/17 08:14 AM
NF-4634 code review check list.doc
23 kB
16/Nov/17 01:02 PM
Test Scenarios.xls
12 kB
22/Nov/17 10:37 AM
Test Scenarios-New.xls
14 kB
15/Dec/17 04:06 AM

Issue Links

duplicates

NF-5454 Pre Prod | Employee Census and Eligibility Report not showing any data.

Closed

is duplicated by

NF-5274 NF:- Cambrian School District - Admin Login - No records found is being displayed on running an Enrollment Report

Closed

relates to

WT-12131 Virgin - Reports not pulling up

Closed

Activity

Ascending order - Click to sort in descending order

Hrishikesh Deshpande (Inactive) created issue - 11/Oct/17 09:48 AM

Hrishikesh Deshpande (Inactive) made changes - 11/Oct/17 09:49 AM

Field	Original Value	New Value
Assignee	Nidhi Kaul [ nidhi.kaul ]	Prasanna Karlekar [ prasanna ]

Permalink

Parmeshwar Jumbad (Inactive) logged work - 11/Oct/17 01:01 PM

Time Spent:

0.5h

Discussion with Hrishikesh related to issue

Parmeshwar Jumbad (Inactive) made changes - 11/Oct/17 01:02 PM

Remaining Estimate		0h [ 0 ]
Time Spent		0.5h [ 1800 ]
Worklog Id		84280 [ 84280 ]

Permalink

Hrishikesh Deshpande (Inactive) logged work - 11/Oct/17 01:13 PM

Time Spent:

1h

Issue repro and discussion

Hrishikesh Deshpande (Inactive) made changes - 11/Oct/17 01:13 PM

Time Spent	0.5h [ 1800 ]	1.5h [ 5400 ]
Worklog Id		84298 [ 84298 ]

Hide

Permalink

Prasanna Karlekar (Inactive) added a comment - 12/Oct/17 06:21 AM

Hi Hrishikesh Deshpande,

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

Thank you!

cc:Gaurav Sodani

Show

Prasanna Karlekar (Inactive) added a comment - 12/Oct/17 06:21 AM Hi Hrishikesh Deshpande , Could you please provide Admin Login details, from which you were verifying this. Thank you! cc: Gaurav Sodani

Hide

Permalink

Nidhi Kaul (Inactive) added a comment - 23/Oct/17 10:22 AM

Prasanna Karlekar
Does this need to be assigned to Hrishikesh?

Thanks,
Nidhi.

Show

Nidhi Kaul (Inactive) added a comment - 23/Oct/17 10:22 AM Prasanna Karlekar Does this need to be assigned to Hrishikesh? Thanks, Nidhi.

Prasanna Karlekar (Inactive) made changes - 23/Oct/17 01:26 PM

Assignee

Prasanna Karlekar [ prasanna ]

Hrishikesh Deshpande [ hrishikesh.deshpande ]

Hide

Permalink

Prasanna Karlekar (Inactive) added a comment - 23/Oct/17 01:26 PM

Hrishikesh Deshpande -

Please provide admin login credentials.

Thank you!

Show

Prasanna Karlekar (Inactive) added a comment - 23/Oct/17 01:26 PM Hrishikesh Deshpande - Please provide admin login credentials. Thank you!

Hide

Permalink

Hrishikesh Deshpande (Inactive) added a comment - 24/Oct/17 09:18 AM

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 (Inactive) added a comment - 24/Oct/17 09:18 AM 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.

Hrishikesh Deshpande (Inactive) made changes - 24/Oct/17 09:18 AM

Assignee

Hrishikesh Deshpande [ hrishikesh.deshpande ]

Prasanna Karlekar [ prasanna ]

Parmeshwar Jumbad (Inactive) made changes - 03/Nov/17 08:47 AM

Labels

Standard_Report

Satya made changes - 04/Nov/17 06:43 AM

Environment_New

Others [ 18445 ]

Harshada Borole (Inactive) made changes - 08/Nov/17 05:16 AM

Assignee

Prasanna Karlekar [ prasanna ]

Harshada Borole [ harshada.borole ]

Harshada Borole (Inactive) made changes - 08/Nov/17 06:09 AM

Company		All Clients/Multiple Clients [ 18434 ]
Developer		Harshada Borole [ harshada.borole ]
Item State		Parent values: Development(10200)Level 1 values: In Analysis(10204)
Original Estimate		0h [ 0 ]

Permalink

Harshada Borole (Inactive) logged work - 09/Nov/17 03:53 AM

Time Spent:

5h

Issue analysis
discussion on issue.

Permalink

Jyoti Agrawal (Inactive) logged work - 09/Nov/17 01:23 PM

Time Spent:

0.5h

Discussion on issue

Jyoti Agrawal (Inactive) made changes - 09/Nov/17 01:23 PM

Time Spent	1.5h [ 5400 ]	2h [ 7200 ]
Worklog Id		89944 [ 89944 ]

Prasanna Karlekar (Inactive) made changes - 09/Nov/17 03:00 PM

Time Spent	2h [ 7200 ]	2.5h [ 9000 ]
Worklog Id		89967 [ 89967 ]

Permalink

Harshada Borole (Inactive) logged work - 09/Nov/17 04:00 PM

Time Spent:

4h

Analysis and discussion on issue fix.

Permalink

Prasanna Karlekar (Inactive) logged work - 10/Nov/17 02:00 AM

Time Spent:

0.5h

Analysis and discussion on fix to be done

Harshada Borole (Inactive) made changes - 10/Nov/17 03:54 AM

Time Spent	2.5h [ 9000 ]	7.5h [ 27000 ]
Worklog Id		90037 [ 90037 ]

Harshada Borole (Inactive) made changes - 10/Nov/17 04:00 AM

Time Spent	7.5h [ 27000 ]	11.5h [ 41400 ]
Worklog Id		90040 [ 90040 ]

Jyoti Agrawal (Inactive) made changes - 10/Nov/17 09:32 AM

Dev Due Date

14/Nov/2017

Jyoti Agrawal (Inactive) made changes - 10/Nov/17 09:35 AM

Item State

Parent values: Development(10200)Level 1 values: In Analysis(10204)

Parent values: Development(10200)Level 1 values: In Progress(10206)

Permalink

Harshada Borole (Inactive) logged work - 10/Nov/17 12:26 PM

Time Spent:

4h

Discussion on issue fix.
Code changes.

Harshada Borole (Inactive) made changes - 10/Nov/17 12:27 PM

Time Spent	11.5h [ 41400 ]	15.5h [ 55800 ]
Worklog Id		90157 [ 90157 ]

Permalink

Jyoti Agrawal (Inactive) logged work - 10/Nov/17 12:29 PM

Time Spent:

2h

Discussion, analysis, mail writing

Jyoti Agrawal (Inactive) made changes - 10/Nov/17 12:29 PM

Time Spent	15.5h [ 55800 ]	17.5h [ 63000 ]
Worklog Id		90162 [ 90162 ]

Prasanna Karlekar (Inactive) made changes - 10/Nov/17 02:23 PM

Time Spent	17.5h [ 63000 ]	18.25h [ 65700 ]
Worklog Id		90244 [ 90244 ]

Permalink

Prasanna Karlekar (Inactive) logged work - 10/Nov/17 07:30 PM

Time Spent:

0.75h

Code debug
Impact analysis of fix to be done
Email review

Harshada Borole (Inactive) made changes - 13/Nov/17 10:15 AM

Status

Open [ 1 ]

In Development [ 10007 ]

Permalink

Harshada Borole (Inactive) logged work - 13/Nov/17 05:05 PM

Time Spent:

3h

SP changes
Testing.

Harshada Borole (Inactive) made changes - 14/Nov/17 05:08 AM

Time Spent	18.25h [ 65700 ]	21.25h [ 76500 ]
Worklog Id		90596 [ 90596 ]

Kumar Chhajed (Inactive) made changes - 14/Nov/17 06:44 AM

Time Spent	21.25h [ 76500 ]	22.25h [ 80100 ]
Worklog Id		90639 [ 90639 ]

Permalink

Harshada Borole (Inactive) logged work - 14/Nov/17 11:07 AM

Time Spent:

3.5h

Testing

Permalink

Rakesh Shahane (Inactive) logged work - 14/Nov/17 12:35 PM

Time Spent:

2.5h

Verified impact on export for the udf OES_UDF_GetEmployeeWhereClause

Permalink

Ramya Tantry (Inactive) logged work - 14/Nov/17 01:02 PM

Time Spent:

0.5h

Discussion with Kumar for verification of change on ACA

Ramya Tantry (Inactive) made changes - 14/Nov/17 01:02 PM

Time Spent	22.25h [ 80100 ]	22.75h [ 81900 ]
Worklog Id		90780 [ 90780 ]

Permalink

Kumar Chhajed (Inactive) logged work - 14/Nov/17 02:43 PM

Time Spent:

1h

Analysis
Unit testing
Internal Discussion

Prashant Samal (Inactive) made changes - 14/Nov/17 08:20 PM

Link

This issue relates to ~~WT-12131~~ [ ~~WT-12131~~ ]

Hide

Permalink

Prashant Samal (Inactive) added a comment - 14/Nov/17 08:25 PM

Hello,

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

Thanks
S Prashant

Show

Prashant Samal (Inactive) added a comment - 14/Nov/17 08:25 PM Hello, Faced similar issue on https://workterra.atlassian.net/browse/WT-12131 Thanks S Prashant

Hrishikesh Deshpande (Inactive) made changes - 15/Nov/17 05:13 AM

Priority

Medium [ 3 ]

High [ 2 ]

Hrishikesh Deshpande (Inactive) made changes - 15/Nov/17 05:14 AM

Bug Severity

Medium [ 16702 ]

Critical [ 16701 ]

Hide

Permalink

Nidhi Kaul (Inactive) added a comment - 15/Nov/17 05:15 AM - edited

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

Thanks,
Nidhi.

Satya Gaurav Sodani

Show

Nidhi Kaul (Inactive) added a comment - 15/Nov/17 05:15 AM - edited Harshada Borole What is the status on this? The development was supposed to complete yesterday. Thanks, Nidhi. Satya Gaurav Sodani

Hide

Permalink

Harshada Borole (Inactive) added a comment - 15/Nov/17 05:20 AM

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 (Inactive) added a comment - 15/Nov/17 05:20 AM 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

Harshada Borole (Inactive) made changes - 15/Nov/17 10:47 AM

Assignee

Harshada Borole [ harshada.borole ]

Parmeshwar Jumbad [ parmeshwar.jumbade ]

Harshada Borole (Inactive) made changes - 15/Nov/17 10:47 AM

Item State

Parent values: Development(10200)Level 1 values: In Progress(10206)

Parent values: Development(10200)Level 1 values: Ready for Review(10208)

Harshada Borole (Inactive) made changes - 15/Nov/17 10:47 AM

Dev Due Date

14/Nov/2017

15/Nov/2017

Harshada Borole (Inactive) made changes - 15/Nov/17 11:08 AM

Time Spent	22.75h [ 81900 ]	26.25h [ 94500 ]
Worklog Id		90891 [ 90891 ]

Permalink

Harshada Borole (Inactive) logged work - 15/Nov/17 05:15 PM

Time Spent:

3h

Testing
Sent code for review.

Harshada Borole (Inactive) made changes - 16/Nov/17 05:15 AM

Time Spent	26.25h [ 94500 ]	29.25h [ 105300 ]
Worklog Id		91040 [ 91040 ]

Parmeshwar Jumbad (Inactive) made changes - 16/Nov/17 10:01 AM

Assignee

Parmeshwar Jumbad [ parmeshwar.jumbade ]

Jyoti Agrawal [ jyoti.agrawal ]

Jyoti Agrawal (Inactive) made changes - 16/Nov/17 01:02 PM

Attachment

NF-4634 code review check list.doc [ 67874 ]

Jyoti Agrawal (Inactive) made changes - 16/Nov/17 01:02 PM

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)

Permalink

Jyoti Agrawal (Inactive) logged work - 16/Nov/17 01:03 PM

Time Spent:

1.5h

Code review, functionality review, 3C's review, code checklist preparation

Jyoti Agrawal (Inactive) made changes - 16/Nov/17 01:03 PM

Assignee

Jyoti Agrawal [ jyoti.agrawal ]

Harshada Borole [ harshada.borole ]

Jyoti Agrawal (Inactive) made changes - 16/Nov/17 01:03 PM

Dev Due Date

15/Nov/2017

17/Nov/2017

Jyoti Agrawal (Inactive) made changes - 16/Nov/17 01:04 PM

Time Spent	29.25h [ 105300 ]	30.75h [ 110700 ]
Worklog Id		91178 [ 91178 ]

Rakesh Shahane (Inactive) made changes - 17/Nov/17 12:36 PM

Time Spent	30.75h [ 110700 ]	33.25h [ 119700 ]
Worklog Id		91377 [ 91377 ]

Permalink

Harshada Borole (Inactive) logged work - 21/Nov/17 12:42 PM

Time Spent:

2h

Corrected the script.
Testing.

Harshada Borole (Inactive) made changes - 21/Nov/17 12:42 PM

Time Spent	33.25h [ 119700 ]	35.25h [ 126900 ]
Worklog Id		91886 [ 91886 ]

Hide

Permalink

Sumeet.Kolge (Inactive) added a comment - 22/Nov/17 09:35 AM

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 (Inactive) added a comment - 22/Nov/17 09:35 AM 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

Permalink

Nidhi Kaul (Inactive) added a comment - 22/Nov/17 09:40 AM

Harshada Borole
3c's are missing originally.

Show

Nidhi Kaul (Inactive) added a comment - 22/Nov/17 09:40 AM Harshada Borole 3c's are missing originally.

Harshada Borole (Inactive) made changes - 22/Nov/17 10:37 AM

Attachment

Test Scenarios.xls [ 68335 ]

Hide

Permalink

Harshada Borole (Inactive) added a comment - 22/Nov/17 10:37 AM

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 (Inactive) added a comment - 22/Nov/17 10:37 AM 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

Harshada Borole (Inactive) made changes - 22/Nov/17 10:37 AM

Code Review Date		16/Nov/2017
Code Reviewed By		Jyoti Agarwal [ 16704 ]

Hide

Permalink

Nidhi Kaul (Inactive) added a comment - 22/Nov/17 11:07 AM

Harshada Borole

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

Show

Nidhi Kaul (Inactive) added a comment - 22/Nov/17 11:07 AM Harshada Borole Has anything been corrected after Sumeet tested it? Thanks, Nidhi

Hide

Permalink

Harshada Borole (Inactive) added a comment - 22/Nov/17 12:17 PM

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 (Inactive) added a comment - 22/Nov/17 12:17 PM 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

Permalink

Sumeet.Kolge (Inactive) added a comment - 22/Nov/17 12:50 PM - 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 (Inactive) added a comment - 22/Nov/17 12:50 PM - 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

Permalink

Jyoti Agrawal (Inactive) logged work - 22/Nov/17 01:17 PM

Time Spent:

1h

Discussion, analysis

Jyoti Agrawal (Inactive) made changes - 22/Nov/17 01:17 PM

Time Spent	35.25h [ 126900 ]	36.25h [ 130500 ]
Worklog Id		92140 [ 92140 ]

Permalink

Sumeet.Kolge (Inactive) logged work - 22/Nov/17 01:31 PM

Time Spent:

1.3h

Tried scenarios and discussed with teams

Sumeet.Kolge (Inactive) made changes - 22/Nov/17 01:31 PM

Time Spent	36.25h [ 130500 ]	37.55h [ 135180 ]
Worklog Id		92144 [ 92144 ]

Permalink

Harshada Borole (Inactive) logged work - 22/Nov/17 04:17 PM

Time Spent:

1h

Discussion and analysis.

Harshada Borole (Inactive) made changes - 23/Nov/17 04:17 AM

Time Spent	37.55h [ 135180 ]	38.55h [ 138780 ]
Worklog Id		92245 [ 92245 ]

Khandu Kshirsagar (Inactive) made changes - 23/Nov/17 07:00 AM

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)

Permalink

Harshada Borole (Inactive) logged work - 23/Nov/17 04:07 PM - edited

Time Spent:

1h

Analysis

Harshada Borole (Inactive) made changes - 24/Nov/17 04:07 AM

Time Spent	38.55h [ 138780 ]	39.55h [ 142380 ]
Worklog Id		92445 [ 92445 ]

Harshada Borole (Inactive) made changes - 24/Nov/17 04:08 AM

Worklog Id

92445 [ 92445 ]

Prasanna Karlekar (Inactive) made changes - 24/Nov/17 02:04 PM

Time Spent	39.55h [ 142380 ]	39.8h [ 143280 ]
Worklog Id		92777 [ 92777 ]

Permalink

Prasanna Karlekar (Inactive) logged work - 24/Nov/17 10:00 PM

Time Spent:

0.25h

Scenario discussion

Permalink

Harshada Borole (Inactive) logged work - 25/Nov/17 05:00 AM

Time Spent:

0.5h

Discussion with Prasanna.

Harshada Borole (Inactive) made changes - 27/Nov/17 05:00 AM

Time Spent	39.8h [ 143280 ]	40.3h [ 145080 ]
Worklog Id		92835 [ 92835 ]

Harshada Borole (Inactive) made changes - 01/Dec/17 06:13 AM

Item State

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Parent values: Development(10200)Level 1 values: In Progress(10206)

Harshada Borole (Inactive) made changes - 05/Dec/17 06:32 AM

Link

This issue is duplicated by ~~NF-5274~~ [ ~~NF-5274~~ ]

Permalink

Harshada Borole (Inactive) logged work - 05/Dec/17 04:36 PM

Time Spent:

6.5h

Discussion with Prasanna.Jyoti.
Mail writing.
Coding.
Testing.

Permalink

Prasanna Karlekar (Inactive) logged work - 06/Dec/17 01:00 AM

Time Spent:

1.5h

Issue discussion
Discussion on changes to be done
Email review

Harshada Borole (Inactive) made changes - 06/Dec/17 04:37 AM

Time Spent	40.3h [ 145080 ]	46.8h [ 168480 ]
Worklog Id		94825 [ 94825 ]

Permalink

Harshada Borole (Inactive) logged work - 06/Dec/17 03:53 PM

Time Spent:

3h

Testing.
Changes in mail after review.

Harshada Borole (Inactive) made changes - 07/Dec/17 03:55 AM

Time Spent	46.8h [ 168480 ]	49.8h [ 179280 ]
Worklog Id		95033 [ 95033 ]

Harshada Borole (Inactive) made changes - 07/Dec/17 08:06 AM

Item State

Parent values: Development(10200)Level 1 values: In Progress(10206)

Parent values: Development(10200)Level 1 values: Ready for Review(10208)

Harshada Borole (Inactive) made changes - 07/Dec/17 08:07 AM

Assignee

Harshada Borole [ harshada.borole ]

Prasanna Karlekar [ prasanna ]

Permalink

Prasanna Karlekar (Inactive) logged work - 08/Dec/17 08:00 PM

Time Spent:

0.75h

Code and scenario review
Discussion

Hide

Permalink

Nidhi Kaul (Inactive) added a comment - 11/Dec/17 11:16 AM

Prasanna Karlekar
By when will this be fixed?

Nidhi.

Show

Nidhi Kaul (Inactive) added a comment - 11/Dec/17 11:16 AM Prasanna Karlekar By when will this be fixed? Nidhi.

Prasanna Karlekar (Inactive) made changes - 12/Dec/17 06:57 AM

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)

Prasanna Karlekar (Inactive) made changes - 12/Dec/17 06:57 AM

Assignee

Prasanna Karlekar [ prasanna ]

Harshada Borole [ harshada.borole ]

Hide

Permalink

Prasanna Karlekar (Inactive) added a comment - 12/Dec/17 06:58 AM

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

Thank you!

Show

Prasanna Karlekar (Inactive) added a comment - 12/Dec/17 06:58 AM Nidhi Kaul - This is fixed and review has been done. Thank you!

Harshada Borole (Inactive) made changes - 12/Dec/17 09:57 AM

Link

This issue duplicates ~~NF-5454~~ [ ~~NF-5454~~ ]

Harshada Borole (Inactive) made changes - 15/Dec/17 04:04 AM

Attachment

Test Scenarios-New.xls [ 70104 ]

Harshada Borole (Inactive) made changes - 15/Dec/17 04:05 AM

Attachment

Test Scenarios-New.xls [ 70104 ]

Harshada Borole (Inactive) made changes - 15/Dec/17 04:06 AM

Attachment

Test Scenarios-New.xls [ 70105 ]

Hide

Permalink

Harshada Borole (Inactive) added a comment - 15/Dec/17 04:06 AM

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 (Inactive) added a comment - 15/Dec/17 04:06 AM 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

Khandu Kshirsagar (Inactive) made changes - 15/Dec/17 06:49 AM

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)

Harshada Borole (Inactive) made changes - 15/Dec/17 07:25 AM

Assignee

Harshada Borole [ harshada.borole ]

Sachin Hingole [ sachin.hingole ]

Jayshree Nagpure (Inactive) made changes - 16/Dec/17 08:11 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Jayshree Nagpure (Inactive) made changes - 16/Dec/17 08:13 AM

Item State

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Jayshree Nagpure (Inactive) made changes - 16/Dec/17 08:14 AM

Attachment

4634.jpg [ 70235 ]

Hide

Permalink

Jayshree Nagpure (Inactive) added a comment - 16/Dec/17 08:15 AM - 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 (Inactive) added a comment - 16/Dec/17 08:15 AM - 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

Jayshree Nagpure (Inactive) made changes - 16/Dec/17 08:15 AM

Item State

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Parent values: LB QA(10201)Level 1 values: Re-open(10212)

Jayshree Nagpure (Inactive) made changes - 16/Dec/17 08:16 AM

Assignee

Sachin Hingole [ sachin.hingole ]

Harshada Borole [ harshada.borole ]

Jayshree Nagpure (Inactive) made changes - 16/Dec/17 08:16 AM

Status

Local Testing [ 10200 ]

Reopen in Local [ 10018 ]

Permalink

Jayshree Nagpure (Inactive) logged work - 16/Dec/17 08:23 AM

Time Spent:

1.5h

codemap testing

Jayshree Nagpure (Inactive) made changes - 16/Dec/17 08:23 AM

Time Spent	49.8h [ 179280 ]	51.3h [ 184680 ]
Worklog Id		96448 [ 96448 ]

Hide

Permalink

Nidhi Kaul (Inactive) added a comment - 18/Dec/17 03:41 AM - edited

Please check this on priority.

Prasanna Karlekar
Nidhi.

Show

Nidhi Kaul (Inactive) added a comment - 18/Dec/17 03:41 AM - edited Please check this on priority. Prasanna Karlekar Nidhi.

Hide

Permalink

Harshada Borole (Inactive) added a comment - 18/Dec/17 05:56 AM - 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 (Inactive) added a comment - 18/Dec/17 05:56 AM - 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

Harshada Borole (Inactive) made changes - 18/Dec/17 05:57 AM

Status

Reopen in Local [ 10018 ]

In Development [ 10007 ]

Harshada Borole (Inactive) made changes - 18/Dec/17 05:57 AM

Assignee

Harshada Borole [ harshada.borole ]

Jayshree Nagpure [ jayshree.nagpure ]

Jayshree Nagpure (Inactive) made changes - 18/Dec/17 06:45 AM

Item State

Parent values: LB QA(10201)Level 1 values: Re-open(10212)

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Jayshree Nagpure (Inactive) made changes - 18/Dec/17 06:45 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Hide

Permalink

Jayshree Nagpure (Inactive) added a comment - 18/Dec/17 08:47 AM

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 (Inactive) added a comment - 18/Dec/17 08:47 AM 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.

Jayshree Nagpure (Inactive) made changes - 18/Dec/17 08:47 AM

Item State

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Parent values: LB QA(10201)Level 1 values: On Hold(10211)

Khandu Kshirsagar (Inactive) made changes - 19/Dec/17 06:42 AM

Item State

Parent values: LB QA(10201)Level 1 values: On Hold(10211)

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Khandu Kshirsagar (Inactive) made changes - 19/Dec/17 07:11 AM

Item State

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)

Permalink

Hrishikesh Deshpande (Inactive) logged work - 19/Dec/17 08:53 AM

Time Spent:

0.5h

<No comment>

Hide

Permalink

Hrishikesh Deshpande (Inactive) added a comment - 19/Dec/17 08:53 AM

This Issue is Fixed on Pre-Prod.

Show

Hrishikesh Deshpande (Inactive) added a comment - 19/Dec/17 08:53 AM This Issue is Fixed on Pre-Prod.

Hrishikesh Deshpande (Inactive) made changes - 19/Dec/17 08:53 AM

Time Spent	51.3h [ 184680 ]	51.8h [ 186480 ]
Worklog Id		96817 [ 96817 ]

Hrishikesh Deshpande (Inactive) made changes - 19/Dec/17 08:53 AM

Item State

Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)

Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)

Hrishikesh Deshpande (Inactive) made changes - 19/Dec/17 08:53 AM

Status

Local Testing [ 10200 ]

Stage Testing [ 10201 ]

Prasanna Karlekar (Inactive) made changes - 02/Jan/18 02:13 PM

Time Spent	51.8h [ 186480 ]	52.55h [ 189180 ]
Worklog Id		99091 [ 99091 ]

Prasanna Karlekar (Inactive) made changes - 02/Jan/18 02:19 PM

Time Spent	52.55h [ 189180 ]	54.05h [ 194580 ]
Worklog Id		99101 [ 99101 ]

Permalink

Prasad Pise (Inactive) logged work - 19/Jan/18 12:36 PM

Time Spent:

2h

Understanding and Re-testing for sharing findings.

Prasad Pise (Inactive) made changes - 19/Jan/18 12:37 PM

Time Spent	54.05h [ 194580 ]	56.05h [ 201780 ]
Worklog Id		101160 [ 101160 ]

Permalink

Jayshree Nagpure (Inactive) logged work - 21/Mar/18 05:45 AM

Time Spent:

1h

Production verification

Hide

Permalink

Jayshree Nagpure (Inactive) added a comment - 21/Mar/18 05:45 AM

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

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

Working fine, hence closing this jira.

Thanks,
Jayshree

cc - Sachin Hingole Prasad Pise Rakesh Roy Hrishikesh Deshpande

Show

Jayshree Nagpure (Inactive) added a comment - 21/Mar/18 05:45 AM 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

Jayshree Nagpure (Inactive) made changes - 21/Mar/18 05:45 AM

Status

Stage Testing [ 10201 ]

Production Testing [ 10202 ]

Jayshree Nagpure (Inactive) made changes - 21/Mar/18 05:45 AM

Resolution		Bug Fixed [ 10402 ]
Status	Production Testing [ 10202 ]	Production Complete [ 10028 ]

Jayshree Nagpure (Inactive) made changes - 21/Mar/18 05:46 AM

Time Spent	56.05h [ 201780 ]	57.05h [ 205380 ]
Worklog Id		109140 [ 109140 ]

Jayshree Nagpure (Inactive) made changes - 21/Mar/18 05:46 AM

Status

Production Complete [ 10028 ]

Closed [ 6 ]

Transition	Time In Source Status	Execution Times

Harshada Borole (Inactive) made transition - 13/Nov/17 10:15 AM

Open

In Development

33d 1h 26m

Jayshree Nagpure (Inactive) made transition - 16/Dec/17 08:16 AM

In LB Testing

Reopen in Local

4m 59s

Harshada Borole (Inactive) made transition - 18/Dec/17 05:57 AM

Reopen in Local

In Development

1d 21h 41m

Jayshree Nagpure (Inactive) made transition - 18/Dec/17 06:45 AM

In Development

In LB Testing

32d 22h 44m

Hrishikesh Deshpande (Inactive) made transition - 19/Dec/17 08:53 AM

In LB Testing

Stage Testing

1d 2h 8m

Jayshree Nagpure (Inactive) made transition - 21/Mar/18 05:45 AM

Stage Testing

In Production Testing

91d 19h 51m

Jayshree Nagpure (Inactive) made transition - 21/Mar/18 05:45 AM

In Production Testing

Production Complete

12s

Jayshree Nagpure (Inactive) made transition - 21/Mar/18 05:46 AM

Production Complete

Closed

29s

People

Assignee:: Jayshree Nagpure (Inactive)

Reporter:: Hrishikesh Deshpande (Inactive)

Developer:: Harshada Borole (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 6 Start watching this issue

Dates

Created:: 11/Oct/17 09:48 AM

Updated:: 21/Mar/18 05:46 AM

Resolved:: 21/Mar/18 05:45 AM

Dev Due Date:: 17/Nov/2017

Code Review Date:: 16/Nov/2017

Time Tracking

Estimated:

Remaining:

Logged:

57.05h