to get row_count without using retrieve activity

0
Hello Everyone, for retrieve activity i'm using below x-path  [(PPSC.INIT_PPSC/PPSC.PPSC/EN_CLOSURE_STATUS=  'CLOSED' or PPSC.INIT_PPSC/PPSC.PPSC/EN_CLOSURE_STATUS= 'CL_WITH_EXC')and (EN_REQUEST_STATUS='PPSC_Closed')]   but i don't want to use retrieve activity only to get total count of records returned after applying that x-path filter as it is consuming time to retrieve but data set is bigger one which cause delay in response so i want to get the count using any alternative method and i tried countrowsoqlstatement java action here i'm facing issue if the input query  passing as string 'select req_num from ppsc.init' it is working fine and able to fetch the count but if i include where condition facing internal server error could you please suggest me on this.  
asked
0 answers