Following SQL Query which is use for approval Query in Approval Process creating Good Issue Document for specific item group in SAP Business One.
SELECT DISTINCT 'TRUE'
from IGE1
left join OITM on $[IGE1.Itemcode]=OITM.Itemcode Where $[OITM.ItmsGrpCod] in ('105','103')
SELECT DISTINCT 'TRUE'
from IGE1
left join OITM on $[IGE1.Itemcode]=OITM.Itemcode Where $[OITM.ItmsGrpCod] in ('105','103')