Remove hardcoded values for InfoInvoiceWindow (BPartnerID / IsSOTrx) and InfoPaymentWindow (IsSOTrx)

Description

None

Environment

None

Activity

Show:
Nicolas Micoud
October 27, 2017, 3:27 PM

Hi ,
The patch removes hardcoded values and replace them with default values on the InfoColumn

Regards,

Nicolas

Norbert Bede
September 3, 2020, 6:18 PM

hi

After upgrade to 7.1z we recognize frequent parsing error message in log, would be greate fix it.

GridField.defaultFromSQLExpression: (IsVendor) - Default SQL variable parse failed: @SQL=SELECT CASE '@IsSOTrx@' WHEN '' THEN '' WHEN 'N' THEN 'Y' ELSE 'N' END AS DefaultValue FROM DUAL [322]

thanks.
norbert

Norbert Bede
September 4, 2020, 2:24 PM

Hi

looks me there is oracle syntax? (i mean DUAL) in Postgres migration scripts.

norbert

Nicolas Micoud
September 4, 2020, 2:29 PM

Hello Norbert,

AFAIR, the table DUAL has been added years ago in PG schema, so migration script can be registered using the same query

Nicolas

Norbert Bede
September 4, 2020, 2:33 PM

Hello Nicolas.

thanks. an error log is reproducible in the latest 7.1z test.idempiere.org - then another parsing issue exists.

GridField.defaultFromSQLExpression: (IsVendor) - Default SQL variable parse failed: @SQL=SELECT CASE '@IsSOTrx@' WHEN '' THEN '' WHEN 'N' THEN 'Y' ELSE 'N' END AS DefaultValue FROM DUAL [322]

Assignee

Nicolas Micoud

Reporter

Nicolas Micoud

Labels

Tested By

None

Priority

Major
Configure