Project SimpleProject Type: software

Project Simple

Uploaded image for project: 'Project Simple'
  1. Project Simple
  2. ST-179

Query performance - OES_SP_Get_EmployeeAttributeFields

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Component/s: Performance
    • Labels:
      None
    • Module:
      Platform - Performance
    • Reported by:
      Support
    • Item State:
      Development - On Hold

      Description

      Call Stack:
      WORKTERRA.SqlHelper.ExecuteReader(:0)
      WORKTERRA.EmployeeData.GetEmployeeProfile(:0)
      WORKTERRA.EmployeeData.GetData(:0)
      WORKTERRA.Shared.WORKTERRAControllerAppTier.GetData(:0)

      StoredProc: OES_SP_Get_EmployeeAttributeFields

        Attachments

          Issue Links

          relates to

          Enhancement - An improvement or enhancement to an existing feature or task. ST-175 Query Optimization for performance

          • High - Serious problem that could block progress.
          • New Request

            Activity

            Ascending order - Click to sort in descending order
            saurabh.sablaka Saurabh Sablaka (Inactive) created issue -
            saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
            Field Original Value New Value
            Link This issue relates to ST-175 [ ST-175 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Development Backlog(10205) Parent values: Development(10200)Level 1 values: In Progress(10206)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: On Hold(10207)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Attachment OES_SP_Get_EmployeeAttributeFields.sql [ 49436 ]
            Attachment OES_SP_GetOptionsForFieldsWithListControl.sql [ 49437 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Nandkumar [ satyap ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 0.5h [ 1800 ]
            Worklog Id 49639 [ 49639 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Status New Request [ 10029 ] Product Backlog [ 10100 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Status Product Backlog [ 10100 ] Pending for Approval [ 10002 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Status Pending for Approval [ 10002 ] Rejected [ 10004 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Rejected [ 10004 ] Closed [ 6 ]

              People

              Assignee:
              nandkumar Nandkumar Prabhakar Karlekar (Inactive)
              Reporter:
              saurabh.sablaka Saurabh Sablaka (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 0.5h
                  0.5h