[ST-227] Query Performance - OES_SP_GENERIC_EFFECTIVEDATE_CALCULATION - Workterra Jira

Details

Type: Enhancement
Status: Closed
Priority: High
Resolution: Done
Component/s: Performance
Labels:
None

Reported by:
Support
Item State:
Production QA
Issue Importance:
Must Have

Attachments

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

Attachments

227Employees.txt
0.9 kB
04/Oct/16 11:50 AM
OEMODE_EffectiveDateCalls.xlsx
19 kB
16/Sep/16 12:55 PM
Scenarios_Production.xls
73 kB
27/Oct/16 11:40 AM
Scenarios_Stage.xls
66 kB
08/Oct/16 01:18 PM
Scenarios.xls
52 kB
04/Oct/16 11:45 AM
Test Cases.xlsx
17 kB
26/Sep/16 12:41 PM
Test Cases.xlsx
17 kB
23/Sep/16 05:36 AM

Issue Links

relates to

ST-175 Query Optimization for performance

New Request

WT-4998 Cobra plans are not showing in Cobra enrollment mode

Production Complete

Activity

Ascending order - Click to sort in descending order

Prasanna Karlekar (Inactive) created issue - 22/Jun/16 08:52 AM

Prasanna Karlekar (Inactive) made changes - 22/Jun/16 08:55 AM

Field	Original Value	New Value
Issue Importance		Must Have [ 11800 ]

Prasanna Karlekar (Inactive) made changes - 22/Jun/16 08:55 AM

Link

This issue relates to ST-175 [ ST-175 ]

Vikas Pawar (Inactive) made changes - 04/Aug/16 09:26 AM

Assignee

Vikas Pawar [ vikas.pawar ]

Vikas Pawar (Inactive) made changes - 09/Sep/16 05:39 AM

Status

New Request [ 10029 ]

Pending for Approval [ 10002 ]

Vikas Pawar (Inactive) made changes - 09/Sep/16 05:39 AM

Status

Pending for Approval [ 10002 ]

Approved for Development [ 10003 ]

Vikas Pawar (Inactive) made changes - 09/Sep/16 05:40 AM

Item State

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

Vikas Pawar (Inactive) made changes - 14/Sep/16 06:23 AM

Status

Approved for Development [ 10003 ]

In Development [ 10007 ]

Amruta Lohiya made changes - 14/Sep/16 06:25 AM

Assignee

Vikas Pawar [ vikas.pawar ]

Amruta Lohiya [ amruta.baheti ]

Vikas Pawar (Inactive) made changes - 14/Sep/16 06:39 AM

Item State

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

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

Vikas Pawar (Inactive) made changes - 14/Sep/16 06:40 AM

Assignee

Amruta Lohiya [ amruta.baheti ]

Vikas Pawar [ vikas.pawar ]

Vikas Pawar (Inactive) made changes - 16/Sep/16 12:55 PM

Attachment

OEMODE_EffectiveDateCalls.xlsx [ 26995 ]

Vikas Pawar (Inactive) made changes - 23/Sep/16 05:27 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Vikas Pawar (Inactive) made changes - 23/Sep/16 05:27 AM

Assignee

Vikas Pawar [ vikas.pawar ]

Rakesh Roy [ rakeshr ]

Vikas Pawar (Inactive) made changes - 23/Sep/16 05:36 AM

Attachment

Test Cases.xlsx [ 27420 ]

Vikas Pawar (Inactive) made changes - 23/Sep/16 05:54 AM

Item State

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

Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)

Khandu Kshirsagar (Inactive) made changes - 23/Sep/16 06:17 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)

Rakesh Roy (Inactive) made changes - 23/Sep/16 06:47 AM

Assignee

Rakesh Roy [ rakeshr ]

Alankar Chavan [ alankar.chavan ]

Vikas Pawar (Inactive) made changes - 26/Sep/16 12:41 PM

Attachment

Test Cases.xlsx [ 27624 ]

Vikas Pawar (Inactive) made changes - 27/Sep/16 06:21 AM

Link

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

Rakesh Roy (Inactive) made changes - 27/Sep/16 07:18 AM

Assignee

Alankar Chavan [ alankar.chavan ]

Priya Dhamande [ priya.dhamande ]

Priya Dhamande (Inactive) made changes - 29/Sep/16 01:09 PM

Item State

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

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

Priya Dhamande (Inactive) made changes - 30/Sep/16 05:13 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)

Priya Dhamande (Inactive) made changes - 30/Sep/16 05:13 AM

Assignee

Priya Dhamande [ priya.dhamande ]

Vikas Pawar [ vikas.pawar ]

Vikas Pawar (Inactive) made changes - 30/Sep/16 11:11 AM

Assignee

Vikas Pawar [ vikas.pawar ]

Priya Dhamande [ priya.dhamande ]

Priya Dhamande (Inactive) made changes - 03/Oct/16 04:19 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)

Priya Dhamande (Inactive) made changes - 04/Oct/16 11:45 AM

Attachment

Scenarios.xls [ 28613 ]

Priya Dhamande (Inactive) made changes - 04/Oct/16 11:50 AM

Attachment

227Employees.txt [ 28614 ]

Priya Dhamande (Inactive) made changes - 04/Oct/16 11:55 AM

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)

Priya Dhamande (Inactive) made changes - 04/Oct/16 11:55 AM

Status

Local Testing [ 10200 ]

Pending for Stage Approval [ 10300 ]

Priya Dhamande (Inactive) made changes - 04/Oct/16 11:55 AM

Status

Pending for Stage Approval [ 10300 ]

Approved for Stage [ 10030 ]

Rakesh Roy (Inactive) made changes - 05/Oct/16 05:10 AM

Developer

Vikas Pawar [ vikas.pawar ]

Khandu Kshirsagar (Inactive) made changes - 05/Oct/16 09:14 AM

Item State

Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)

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

Priya Dhamande (Inactive) made changes - 06/Oct/16 12:13 PM

Item State

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

Parent values: Stage QA(10202)Level 1 values: In Testing(10214)

Priya Dhamande (Inactive) made changes - 07/Oct/16 12:25 PM

Status

Approved for Stage [ 10030 ]

Stage Testing [ 10201 ]

Priya Dhamande (Inactive) made changes - 08/Oct/16 01:18 PM

Attachment

Scenarios_Stage.xls [ 28937 ]

Priya Dhamande (Inactive) made changes - 08/Oct/16 01:18 PM

Item State

Parent values: Stage QA(10202)Level 1 values: In Testing(10214)

Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)

Priya Dhamande (Inactive) made changes - 08/Oct/16 01:18 PM

Status

Stage Testing [ 10201 ]

Pending for Production Approval [ 10301 ]

Ashwin Wankhede (Inactive) made changes - 13/Oct/16 07:55 AM

Item State

Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)

Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)

Vikas Pawar (Inactive) made changes - 13/Oct/16 08:07 AM

Code Reviewed By

Satya Prakash,Saurabh Sablaka [ 12300, 11909 ]

Rakesh Roy (Inactive) made changes - 13/Oct/16 08:51 AM

Status

Pending for Production Approval [ 10301 ]

Approved for production [ 10034 ]

Rakesh Roy (Inactive) made changes - 13/Oct/16 08:51 AM

Status

Approved for production [ 10034 ]

Production Testing [ 10202 ]

Priya Dhamande (Inactive) made changes - 13/Oct/16 10:52 AM

Item State

Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)

Parent values: Production QA(10203)Level 1 values: In Testing(10218)

Rakesh Roy (Inactive) made changes - 19/Oct/16 06:08 PM

Resolution		Fixed [ 1 ]
Status	Production Testing [ 10202 ]	Production Complete [ 10028 ]

Rakesh Roy (Inactive) made changes - 19/Oct/16 06:09 PM

Item State

Parent values: Production QA(10203)Level 1 values: In Testing(10218)

Parent values: Production Complete(10222)Level 1 values: Closed(10223)

Priya Dhamande (Inactive) made changes - 27/Oct/16 09:04 AM

Item State

Parent values: Production Complete(10222)Level 1 values: Closed(10223)

Parent values: Production QA(10203)Level 1 values: In Testing(10218)

Priya Dhamande (Inactive) made changes - 27/Oct/16 11:40 AM

Attachment

Scenarios_Production.xls [ 30616 ]

Priya Dhamande (Inactive) made changes - 27/Oct/16 11:53 AM

Item State

Parent values: Production QA(10203)Level 1 values: In Testing(10218)

Parent values: Production QA(10203)

Priya Dhamande (Inactive) made changes - 27/Oct/16 11:53 AM

Status

Production Complete [ 10028 ]

Closed [ 6 ]

People

Assignee:: Priya Dhamande (Inactive)

Reporter:: Prasanna Karlekar (Inactive)

Developer:: Vikas Pawar (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 22/Jun/16 08:52 AM

Updated:: 27/Oct/16 11:53 AM

Resolved:: 19/Oct/16 06:08 PM