thanks for your reply.. :) now its solved the problem. actually Extbase added the pid in where clause(SQL statement). that's why it was not showing the result. i have added one line : $query->getQuerySettings()->setRespectStoragePage(FALSE); now its working fine. Thanks, Raju Makwana