related to issue 38442: fix typo

fixes issue 38442: replace setString(int, String) with setParameter(String, Object)

fixes issue 38442: replace setParameter(int, Object) with setParameter(String, Object)

fixes issue 38401: Wrong filter behavior depending on the grid configuration

Having a grid configuration which both enables lazy filtering and does not allow filtering foreign keys by its identifier, it was not possible to apply a filter in a foreign key combo using this mouse.

This was happening because when it is allowed to filter foreign keys by its identifier, there is some code that restores the filter editor with the previous criteria in case the entered criteria is not valid when the editor loses the focus (on blur).

This logic was causing the lose of the filter criteria because it was restoring it with an empty criteria (the grid was not containing any criteria applied because of the lazy filtering). Therefore, to fix this issue we are not restoring the criteria if the lazy filtering is enabled in the grid.

Merge back from main

Merge temporary head for 3.0PR18Q1.2

Added signature for changeset 9bad88c00b5d

Added tag 3.0PR18Q1.2 for changeset 650aaadd6b6c

Update AD_MODULE version to 3.0PR18Q1.2

fixes bug 38236: OBUISEL_Selector not displayed in tabs that shows 2.50 forms

In 2.50 forms displayed inside 3.0 windows, a request to load the JS static resources is done but the SessionDynamic request is not. As a result, the OB object was generated partially. This caused JS errors when referencing to the missing data (for example when trying to get a label from the OB.I18N object).

This issue was fixed partially on issue #37303. The problem here is still reproducible because when opening a 2.50 form inside a tab, the window.LayoutMDI_windowObj has not being initialized because the getFrame('LayoutMDI') is not being invoked.

To fix the problem, now we are directly invoking getFrame('LayoutMDI') to get the OB object.

Fixes Issue 38238. Do not group Invoices by Organization when not possible.

In case the orders belong to different Organizations and there has not
been an Organization selected manually for which to create the Invoice,
do not group by Organization since it is not possible from a functional
point of view.

* Order the results of the query by Organization
* Check group by Organization logic
* Use this logic to decide if the Invoice should be grouped by Organization
or not

Fixed 38370. Don't add new html mapping for new callouts.

Remove code to auto-insert into ad_model_object_mapping in ad_callout_trg.
As those mappings are no longer useful since 17Q1.

fixes 38407: error message activating heartbeat in PG10

Starting from PostgreSQL 10, server version string includes also package, being
a longer String it doesn't fit current column size.

Fixed by getting just the first word of the version (which is the actual server
version) skipping the rest that refers to the package.

Examples:

9.3.21 -> 9.3.21
10.3 (Ubuntu 10.3-1.pgdg16.04+1) -> 10.3
11devel (Debian 11~~devel~20180418.2231-1~573.git5372c2c.pgdg90+1) -> 11devel

Fixes issue 38240: Wrong average cost for production products, Total Movement
Quantity is not correct

Wrong average cost for production products, Total Movement Quantity and Total Stock
Valuation is not correct because the cost for production is calculated at client level
and the stock and stock valuation was filtering by Legal Entity.

Now the stock and stock valuation is filtered by client level for production products

Related to issue 38280. Code Review changes

* Removed unnecessary save, flush, refresh
* Changed variable name
* Formatted code

Fixes issue 38280:Relation between product and services is not copied when
cloning a sales order

Relation between product and services is not copied by Copy Record process of
Sales Order window

The Copy Record process now take into account the relation between product and
services

related to issue 38382: Add missing @Deprecated annotation

related to issue 38382: use named parameters instead of positional parameters

fixes issue 38382: Deprecate positional query parameters in OBQuery

- Deprecate OBQuery.setParameters(List) method.
- Declare OBQuery.getParameters() as private because it is only used internally.
- Deprecate OBDal.createQuery(Class, String List), which is making use of OBQuery.setParameters(List).
- Deprecate OBDal.createQuery(String, String, List), which is making use of OBQuery.setParameters(List).

Fixes issue 38146: OBQuery uses parameters in organization and client filters

Those HQL queries now use bind-variables in the default client and organization filter.

Fixes issue 38187: Enforce minimum password strength policy

[passwords] Removed unused signatures of goToUpdatePassword method.

[password] Grouping variable declarations

[passwords] Moving dialog callback declaration to start of function.

[passwords] Change password dialog when it fails is now shown as error instead of warn

[passwords] Adding flag to login response to determine error origin.

This flag is used to tell apart whether the response is an attempt to login
with an expired password or is an error after an attempt of changing the
password.

[passwords] Showing message popup when change password fails in user widget.

[passwords] Code review fixes.

- Changed change password widget labels

[passwords] Merge with pi

[passwords] Code review fixes.

- Adding missing javadoc to password checker and its test
- Refactoring password checker to make password length check as part of the checker
instead of a criterion.