Details
-
Enabler
-
Resolution: Completed
-
Medium
-
None
-
None
-
None
-
IO Sprint 111
-
GxP
-
A
Description
Steps to complete:
- add Primary MOT to Parameter drop down list
- get Primary MOT opinions from the backend and show them in Value fields
- add logic into filter
Possible options:
AIR
OCEAN
ROAD
ROAD/OCEAN
Work to be done:
- Oscar-Web App
Update SuperSearch.component.html to support new parameters and values- doneUpdate PIRFilters.Entity- doneAdd Primary MOT column into sr.config.ts alertIOColsDef (hidden by default)- doneadd to selected filters- done
- Oscar App
- Update PIRFiltersLogic to add new filters:
Modify GetPIRFiltersMapper- doneUpdate PIRFilter entity model- doneModify the WEB.SP02_001_SR_GetPIRFilters_OnDemand.sql SP to get values from the table:- all doneadd view for fetching the datamodify the SP to get the data from the view- cannot complete this point without
OS-11528
Update PIRFilters to support adding new user views:- all doneupdate Util.GeneratePIRFilter to pass the valueupdate GetUserViewFiltersMapper to get the valuesModify the WEB.SP02_015_SR_GetUserViewSettings_OnDemand SP to get the values
- Update PIRFiltersLogic to add new filters:
- Microservices
Modify GeneratePIRFilter to reflect new filter- doneUpdate PIRFilter entiry model- doneUpdate GetAlertsMapper in PIRFilterRepository- doneModify the WEB.SP02_002_SR_GetAlerts_OnDemand_IO SP to reflect new filters:- all doneadd extraction of value from XMLadd the columne to tmp and result pageAdd the select in both quesries for finished goods (SR_ALETRS table) and semifinihsed goods (SR_ALERTS_APIPD table)
Changes for all the widgets:
- Microservices
Modify all SPs which fetches data for widgets (eg. WEB.SP23_001_LAP_GetCOPalletConversionChart) in order to reflect new filter:- doneWEB.SP23_036_LAP-GenerateDynamicQueryResultWithXML and it updates below:WEB.SP23_001_LAP_GetCOPalletConversionChartWEB.SP23_002_LAP_GetCOWithoutPalletConversionChartWEB.SP23_003_LAP_GetMDOPalletConversionChartWEB.SP23_005_LAP_GetMOPalletBasedOnMOTChartWEB.SP23_006_LAP_GetMOTopLanesByPalletsChartweb.SP23_016_LAP_GetNodalCapacityPlanChartWEB.SP23_023_LAP_GetNodalCapacityDetailweb.SP23_015_LAP_GetTCLExceptionChartWEB.SP23_024_LAP_GetTCLExceptionDetailweb.SP23_034_LAP_GetRoutingInfoweb.SP23_031_LAP_GetContactInfoweb.SP23_017_LAP_GetRoutingExceptionChartWEB.SP23_025_LAP_GetRoutingExceptionDetail
Attachments
Issue Links
- relates to
-
OS-7794 Add Super Filter - Primary MOT
- Closed