Improve Performance using Search instead of Table/Table Direct

Description

All refernces of "Table Direct" in the document table must change to search also in tables with high volumen and parameters

Environment

None

Activity

Show:
Carlos Ruiz
June 27, 2020, 3:57 PM

The change of M_InOut.User1_ID is causing the following error:

  • role -> GardenWorld Admin

  • window -> Shipment (Customer)

  • create a new record

  • order = 80001

  • Save

  • Error -> Record not deleted - dependent record found: ERROR: insert or update on table "m_inout" violates foreign key constraint "celementvalueuser1_minout" - Detail: Key (user1_id)=(0) is not present in table "c_elementvalue".

Carlos Ruiz
June 27, 2020, 4:01 PM

Pull request https://github.com/idempiere/idempiere/pull/148
integrating fix from

Chuck Boecking
June 27, 2020, 5:27 PM

How do you plan to implement this? Change moving forward or update all fields?

Here is what I have used in the past:

coping for future reference:

Carlos Ruiz
June 27, 2020, 8:46 PM

Hi Chuck, this is already pushed in master (test/test-oracle/test-postgresql)

Your tests and feedback are welcome.

Regards,

Carlos Ruiz

Carlos Ruiz
July 3, 2020, 6:45 PM

The last change on WSearchEditor opened a new bug when importing CSV.

Example: importing the attached

in GardenWorld on window "Invoice (Customer)"

It is leaving this error in the log:

Assignee

Carlos Ruiz

Reporter

Juliana Corredor T.

Labels

Tested By

None

Fix versions

Priority

Major
Configure