C_Order Open Quote

14 views

Skip to first unread message

unread,

Dec 16, 2025, 5:19:10 AM (3 days ago) Dec 16

to iDempiere

dunno ....

C_Order.DocStatus in ('IP','CO') AND issotrx='Y' AND C_Order.updated >= (NOW() - INTERVAL '2 year')

we find its only 5000 orders listed max.

Therefore we filter now - 2 years on updated

to list orders needed !

Many standard dynamic validations come with that problem on heavily loaded C_Order tables !

(speaking idempiere 7.1 :=) )

Have a lot of fun !

Florian

Reply all

Reply to author

Forward

0 new messages