Collection loader displaying values without query

Support
#1

Hi,

I am creating query for collection loader from controller . if some values are present load the query or display no values but values are still displayed even loader is not loaded.
in else i am not loading any data still data is displayed
else{
}

if(listOFVertical.size() > 0) {
                casesesDl.setQuery("select e from Cases e where e.portfolio IN (" + values + ") and e.deleteFlag = :deleteFlag order by e.lastModifiedDate desc");
                casesesDl.setParameter("deleteFlag", Constants.DELETE_FLAG_F);
                casesesDl.load();
            }else{

            }


<loader id="casesesDl">
                <query>
                    <!--<![CDATA[ select e from cases e order by e.lastModifiedDate desc]]>-->
                </query>
            </loader>
#2

If you don’t set a query text, the loader will load all instances of this entity.
So if you want to show an empty table, set the query to something like this:

} else {
    casesesDl.setQuery("select e from Cases e where 1=0");
    casesesDl.load();