Multi Select List and table reference

Description

Design:
Adding 2 new reference type
1. Multi Select Table
2. Multi Select List

When multi select table reference column is sync to DB, create column of Integer array. When multi select list reference column synced, create column of string array.

create editor for each reference type and allow check box to select multiple value.

Add support for handling array data type in PO class as well as GridTable.

Environment

None

Activity

Show:
Deepak Pansheriya
September 14, 2017, 1:21 PM

JSON impact performance as serializing and deserialize add overhead. Also we need to check how easy to perform DB operations in json content. We expect that contains, comparison like operation for values require in sql

Heng Sin Low
June 24, 2019, 1:15 PM
Edited

Implemented as Chosen Box control:

  1. Added 3 Reference Type:

    1. ChosenMultipleSelectionList

    2. ChosenMultipleSelectionTable

    3. ChosenMultipleSelectionSearch

  2. Store as comma separated string

  3. Implemented for window, info window and report parameter

  4. For window find/advanced find and info window search, intersect is use for searching on csv column

  5. For report parameter, IN is use for _ID and single value list column (for e.g DocAction) and intersect is use for csv column

Carlos Ruiz
December 28, 2019, 10:46 PM

Noticed the seed database for oracle is incomplete (no type TABLE_OF_VARCHAR2 and function toTableOfVarchar2) because there was one missing / in the script.

Will fix it in 7.1

Carlos Ruiz
December 28, 2019, 11:01 PM
Carlos Ruiz
July 25, 2020, 5:11 PM

Added documentation
https://wiki.idempiere.org/en/NF7.1_Multi_Select

Pull request 185 configure most of the report parameters to use this new feature.

Assignee

Heng Sin Low

Reporter

Deepak Pansheriya

Labels

None

Tested By

None

Components

Fix versions

Priority

Major
Configure