0045240: MultiUPC filter by multiple UPCs should work in the SEARCH component in Remote mode

Openbravo Issue Tracking System - Retail Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0045240

Retail Modules

Web POS

public

2020-10-19 08:48

2020-11-13 09:01

Reporter

marvintm

Assigned To

ranjith_qualiantech_com

Priority

normal

Severity

major

Reproducibility

have not tried

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

RR21Q1

Merge Request Status

Review Assigned To

OBNetwork customer

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0045240: MultiUPC filter by multiple UPCs should work in the SEARCH component in Remote mode

Description

When the multiUPC module is installed, currently it is possible to:
- Scan by multiple UPCs in local mode
- Scan by multiple UPCs in remote mode
- Use SEARCH to filter by multiple UPCs in local mode

However, it is not possible to:
- Use SEARCH to filter by multiple UPCs in remote mode

We need to implement this last flow.

Steps To Reproduce

- Enable product remote mode and install multiupc module
- Try to search by any upc code defined in the multiupc table. Realise that no product was found.

Proposed Solution

Two changes need to be implemented:
- A new HQLCriteriaProcess class must be implemented, to specify in the getHQLFilter method, the subquery to filter by the multiupc table
- In the frontend, in the extendUPCSearch.js file, in the OBPOS_PreSearchProducts hook, we need to find a way to inject an HQLCriteria to the filter, specifying the qualifier defind in the previous HQLCriteriaProcess, so that when the search request is done to the backend, the infrastructure knows that the subquery must be injected in the main product query.

Additional Information