Changes

IDEMPIERE-3040 Invoice Price Variations for Average PO costing method (#2428)

* IDEMPIERE-3040 Invoice Price Variations for Average PO costing method

Co-authored-by: dpansheriya <deepakpansheriya@gmail.com>

IDEMPIERE-6217 An Error Occurred While Uploading the CSV File as an Attachment (#2446)

- Fix Eclipse warnings

IDEMPIERE-6223 / COF #17758 - Add new field JsonData to AD_PInstance and AD_PInstance_Log (#2447)

IDEMPIERE-6223 Add new field JsonData to AD_PInstance - Peer Review Fixes (#2448)

IDEMPIERE-2981 Implement JSON Field type + IDEMPIERE-6227 - fixes (#2449)

* IDEMPIERE-2981 Implement JSON Field type

- Fix the JSON Editor, is sending to the database the value non prettified

* - Fix issue adding a JSON column with log migration script enabled

When logging migration script the Convert layer is applied, and we didn't implement Convert for the JSON column

* IDEMPIERE-6227 Cannot add a column with spaces on the default value (Convert layer logging migration script)

IDEMPIERE-6229: 2Pack / Data : fill table field using SQL Statement content (#2451)

IDEMPIERE-6228 - Info Window and Info Windows process support for tables with UUID as key / IDEMPIERE-5567 (#2450)

IDEMPIERE-6230 ConcurrentModificationException on MTable (#2453)

IDEMPIERE-5647 Allow definition of context variables by Role - fix issue not being used in Logic (#2452)

IDEMPIERE-6225 Improve IsSingleRow logic when opening 1 record (#2454)

IDEMPIERE-6007 Log Warning: Evaluator.parseSQLLogic: (AD_Table_ID) - SQL variable parse failed: @SQL=SELECT 1 FROM AD_Field WHERE AD_Tab_ID=@AD_Tab_ID@ (#2456)

IDEMPIERE-5567 Support of UUID as Key (FHCA-4195) - Record Info Improvements (#2455)

- allow generating permalink also for multi-key tables using UUID
- use TableName instead of AD_Table_ID for permalink
- add zoom condition to role for access tables on non-system tenants
- on copy select, prefer to generate using ID than UUID when possible - is easier when copying a select that is needed to search also for children

IDEMPIERE-6244 Required change on idempiere-server.sh for docker (#2458)

IDEMPIERE-5432:Performance Measure Calculation - Improve SQL Definition(cover more case) (#2460)

IDEMPIERE-6250:NPE when open SortTab (#2467)

Co-authored-by: hieplq <hieplq@debian.vn>

IDEMPIERE-6251:clean status bar error info (#2468)

Co-authored-by: hieplq <hieplq@debian.vn>

IDEMPIERE-5760 Manage mail.smtp.connectiontimeout and mail.smtp.writetimeout using SysConfig (#2465)

IDEMPIERE-6248: SysConfig to avoid cutting log (#2463)

IDEMPIERE-6249: CLogFormatter.fillExceptionTrace should filter org.adempiere. and org.idempiere. (#2462)

Eclipse warning clean-up after cherry-picks

IDEMPIERE-6146 Recently access menu item: minor refresh refinement (#2365)

IDEMPIERE-6146 Recently access menu item: minor refresh refinement (#2370)

* IDEMPIERE-6146 Recently access menu item: minor refresh refinement

* IDEMPIERE-6146 Recently access menu item: minor refresh refinement

- Fix handling of "enter" key

IDEMPIERE-6013 Implement a way to filter dinamically records on MRole.addAccessSQL (#2471)

- fix queries with alias (like InfoWindow)
- fix InfoWindow issue when the table has no alias

IDEMPIERE-6257: WListbox cannot add total line for Integer (#2470)

* IDEMPIERE-6257: WListbox cannot add total line for Integer

* IDEMPIERE-6257: WListbox cannot add total line for Integer

implement Carlos's suggestion (to reduce number of lines)

Co-Authored-By: Carlos Ruiz <carg67@gmail.com>

---------

Co-authored-by: Carlos Ruiz <carg67@gmail.com>

IDEMPIERE-6247: Issue with Zoom Across when several records should open a window using ZoomCondition (#2464)

IDEMPIERE-6211 Dashboard Goal - Chart doesn't work. (#2476)

IDEMPIERE-6210 : Dashboard Menu - not showed (#2477)

IDEMPIERE-6196 - AD_SysConfig (#2479)

IDEMPIERE-6260 Posting error not creating Notice (#2478)

IDEMPIERE-6248: System Property to avoid cutting log (#2482)

* IDEMPIERE-6248: System Property to avoid cutting log

* IDEMPIERE-6248: System Property to avoid cutting log

Remove SysConfig

* IDEMPIERE-6248: System Property to avoid cutting log

fix import

IDEMPIERE-6264 - Error message on BEFORE_PROCESS and AFTER_PROCESS is shown wrongly (#2484)

IDEMPIERE-6255:Incorrect column count on datatables (#2483)

* IDEMPIERE-6255:Incorrect column count on datatables

* IDEMPIERE-6255:Incorrect column count on datatables (csv header isn't translate)

* Remove never used warning

---------

Co-authored-by: hieplq <hieplq@debian.vn>
Co-authored-by: hengsin <hengsin@gmail.com>

IDEMPIERE-6264 - other cases with double :: on Error (#2486)

IDEMPIERE-6260 Posting error not creating Notice (#2489)

Fix unit test error

IDEMPIERE-6263 Wrong line net amount (#2490)

IDEMPIERE-3551 Automatic Packin - lower verbosity (#2491)

IDEMPIERE-6048 Check access - based on Heng Sin's PR2485 (#2494)

* IDEMPIERE-6048 Check access - based on Heng Sin's PR2485

* - remove warning

* - add a refactor to MChart Column Lookup, to be used by REST

* - fix wrong call - suggested by Heng Sin

IDEMPIERE-6272 - Model Generator fails in silence when the query does… (#2499)

* IDEMPIERE-6272 - Model Generator fails in silence when the query does not return any record

* IDEMPIERE-6272 - Model Generator fails in silence when the query does not return any record

IDEMPIERE-6267 Fields with dynamic validation using TabNo do not reve… (#2495)

* IDEMPIERE-6267 Fields with dynamic validation using TabNo do not revert to blank automatically when the target value is changed

* Handle ~ and make : optional

* Use regex to handle expression with default value

* - remove unnecessary $ from regex

---------

Co-authored-by: hengsin <hengsin@gmail.com>
Co-authored-by: Carlos Ruiz <carg67@gmail.com>

IDEMPIERE-6276 Window > Tab > Copy Tab Fields - must copy just the missing fields (#2505)

IDEMPIERE-6277 When deleting a Recent Item the list is shrunk, instead of showing the next recent item (#2506)

* IDEMPIERE-6277 When deleting a Recent Item the list is shrunk, instead of showing the next recent item

* - implement suggestion from Heng Sin

Extract just Env.java fixes -> IDEMPIERE-6116 Implement escape sequence in Env parseVariable and parseContext methods (#2503)

IDEMPIERE-6282 : idempiere login page enhancement (#2509)

* IDEMPIERE-6282 : idempiere login page enhancement

* revert latest change and added APPLICATION_LOGIN_LEFT_PANEL_SHOWN to configure the left panel visibilty

* remove unnecessary change

IDEMPIERE-6284 - Order is not validating user values when 0 is set (#2511)

IDEMPIERE-6285 - Component doesn't enable when user clicks on new record if positioned in a record without access (#2513)

IDEMPIERE-6279 Problem with hazelcast with multiple server running on localhost postgres on same network (#2514)

IDEMPIERE-6286-optimize-image-background-on-landing-page (#2515)

IDEMPIERE-6288 - Fix script in format item (#2516)

Revert "IDEMPIERE-6255:Incorrect column count on datatables (#2483)"

This reverts commit 3512cd00da4c39a747b9095a68202aa8d5138825.

IDEMPIERE-6000 Reset AD_SysConfig cache automatically when configured (#2525)

IDEMPIERE-6255:Incorrect column count on datatables / fix headers of CSV on change language (#2527)

* IDEMPIERE-6255:Incorrect column count on datatables
* IDEMPIERE-6255:Incorrect column count on datatables (language on csv preview)

IDEMPIERE-6296 -Fixed process workflow node using inactive parameters (#2534)

IDEMPIERE-6297 Fix RelatedInfoWindow Order By (#2529)

* Fix RelatedInfoWindow Order By

The info's default Order By clause must be separated by a comma if there is a user-entered order

* raise exception

---------

Co-authored-by: Carlos Ruiz <carg67@gmail.com>

IDEMPIERE-6297 Fix RelatedInfoWindow Order By (#2535)

Fix build error

IDEMPIERE-6294 default expression for multi-select fields (#2532)

* IDEMPIERE-6294 default expression for multi-select fields

* IDEMPIERE-6294 - Adjusts

IDEMPIERE-6295 OIDC SSO: logout not working for Amazon Cognito (#2533)

* IDEMPIERE-6295 OIDC SSO: logout not working for Amazon Cognito

* IDEMPIERE-6295 OIDC SSO: logout not working for Amazon Cognito

- Fix logout for keycloak and azure

IDEMPIERE-6307: MenuSearch doesn't display tooltip (#2545)

IDEMPIERE-6305 Improve some Error Messages (#2544)

* IDEMPIERE-6305 Improve some Error Messages

* - verify also if the message ends with :