generator-where-constrain

where=where SOHSTA:`A` AND SOqty>poqty  and SUPPLIER like `^'+parent.currentEntity+'^` and SOP_CUR like `^'+parent.currentCurrency+'^` and FIND_IN_SET(TRIM(SODP_RecordID),"'+parent.currentChoose+'"):0 AND CONFIRM:1   and PVIA like `^'+parent.currentVIA+'^` and  IF(`'+parent.currentVIA2+'`:`X`,PVIA<>` `,TRUE)


where=where status:`D` and PARENT_RECORDID : '+parent.RECORDID+'

#where=where SOqty>poqty  and SUPPLIER like `^'+parent.currentEntity+'^` and FIND_IN_SET(TRIM(SODP_RecordID),"'+parent.currentChoose+'"):0

where=where SOqty>poqty  and SUPPLIER like `^'+parent.currentEntity+'^` and FIND_IN_SET(TRIM(SODP_RecordID),"'+parent.currentChoose+'"):0