0040585: SerializedByTermImportEntryProcessorRunnable.countEntries is not using bind-parameters

Description

This code is not using bind-params:

    final String whereClause = ImportEntry.PROPERTY_IMPORTSTATUS + "='" + importStatus + "' and "
        + ImportEntry.PROPERTY_CREATIONDATE + "<=:creationDate and "
        + ImportEntry.PROPERTY_CREATEDTIMESTAMP + "<:createdtimestamp and "
        + ImportEntry.PROPERTY_OBPOSPOSTERMINAL + "=:terminal and id!=:id";
    final Query<Object> qry = OBDal.getInstance()
        .getSession()
        .createQuery("select 1 from " + ImportEntry.ENTITY_NAME + " where " + whereClause,
            Object.class);

Steps To Reproduce

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

design defect

0038136

acknowledged

Triage Platform Base

Openbravo ERP

Tracking issue: Find & Fix queries not using bind-params but embedding values into query string

Notes
(0111710) hgbot (developer) 2019-05-16 10:04	Repository: erp/pmods/org.openbravo.retail.posterminal Changeset: 883614a9abf7462e56bf9fbe3028898a118d6e83 Author: Ranjith S R <ranjith <at> qualiantech.com> Date: Thu May 16 13:33:10 2019 +0530 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/883614a9abf7462e56bf9fbe3028898a118d6e83 [^] Fixed issue 40585 : SerializedByTermImportEntryProcessorRunnable.countEntries is not using bind-parameters --- M src/org/openbravo/retail/posterminal/process/SerializedByTermImportEntryProcessorRunnable.java ---

Issue History
Date Modified	Username	Field	Change
2019-04-10 12:56	shuehner	New Issue
2019-04-10 12:56	shuehner	Assigned To	=> Retail
2019-04-10 12:56	shuehner	Triggers an Emergency Pack	=> No
2019-04-10 12:56	shuehner	Relationship added	blocks 0038136
2019-05-13 12:44	shuehner	Target Version	=> RR19Q3
2019-05-15 07:42	ranjith_qualiantech_com	Assigned To	Retail => ranjith_qualiantech_com
2019-05-15 07:42	ranjith_qualiantech_com	Status	new => scheduled
2019-05-16 10:04	hgbot	Checkin
2019-05-16 10:04	hgbot	Note Added: 0111710
2019-05-16 10:04	hgbot	Status	scheduled => resolved
2019-05-16 10:04	hgbot	Resolution	open => fixed
2019-05-16 10:04	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/883614a9abf7462e56bf9fbe3028898a118d6e83 [^]
2019-05-24 12:54	marvintm	Review Assigned To	=> marvintm
2019-05-24 12:54	marvintm	Status	resolved => closed
2019-05-24 12:54	marvintm	Fixed in Version	=> RR19Q3