0034035: It would be fine if the order the values are shown in a selector could be defined

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0034035

Openbravo ERP

A. Platform

public

2016-09-20 13:12

2022-02-01 08:09

Reporter

ngarcia

Assigned To

Triage Platform Base

Priority

urgent

Severity

major

Reproducibility

always

Status

new

Resolution

open

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0034035: It would be fine if the order the values are shown in a selector could be defined

Description

It would be fine if the order the values are shown in a selector could be defined

Steps To Reproduce

As system admin role:
   Create a Reference with OBUISEL_Selector Reference Parent Reference
   Set it as Custom Query
   Add a HQL query with order by clause
   Assign the reference to a process definition parameter

As group admin role:
   Open the dropdown of the field with the previously created reference
   Check the following error is shown in the log:
   ERROR org.openbravo.service.datasource.DataSourceServlet - unexpected token: ORDER near line ...
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: ORDER near line ..

Proposed Solution

'Sort Field' field could be included in Reference - Defined Selector tab

Additional Information