Default behavior

Window

Open window

• Sometime when open a window (From menu or favorite) it can either "new record" or "view old record":

What is logic for type of window is open?

SELECT 
	COUNT(*) 
FROM 
	C_Order 
WHERE 
	((C_Order.IsSOTrx='Y')) AND 
	(Processed='N' OR Updated>SysDate-1) AND 
	C_Order.AD_Client_ID IN(0,11) AND 
	C_Order.AD_Org_ID IN(50007,0,50004,50005,50006,50000,50001,50002,11,12) AND  
	(C_Order.C_Order_ID IS NULL OR C_Order.C_Order_ID NOT IN ( 
		SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 259 AND AD_User_ID <> 100 AND IsActive = 'Y' )
	)

it's easy. before open window, Idempiere count record will query. when count is 0, window open in new state when count > 0, window open in view old record

default query for document is simple, display unprocess record or processed in preview day