where 1=1

${if(find(org_tree,"0099,0199,0299,0399,0499")>0,"and LEVEL_SCD_ORG_NO in('"+ REPLACE(org_tree ,",",",")+"')","and  ORG in ('"+org_tree+"')")}

=sql("FRDemo", "SELECT * FROM YourTable WHERE " +

    if(${org_tree} in ('0099','0199','0299','0399','0499'),

        "LEVEL_SCD_ORG_NO in ('" + REPLACE(${org_tree}, ",", "','") + "')",

        "ORG in ('" + ${org_tree} + "')"

    ), 3)

你的org_ tree是一个字符串或是数组，参考下面的格式

WHERE 1=1

${if(count(GREPARRAY(split(org_tree,',') ,inarray(item,array('0099','0199','0299','0399','0499'))>0))>0,"LEVEL_SCD_ORG_NO in ('"+ REPLACE(org_tree ,",","','")+"')"," ORG in ('"+org_tree+"')")}