How can I restrict the number of row fetched based on a filter [message #1766874] |
Wed, 28 June 2017 12:48 |
Vivek Kumar Messages: 2 Registered: June 2017 |
Junior Member |
|
|
Hello
I have a requirement where I have to restrict the number of rows fetched from DB based on user input.
I have created filter but not able to pass the filter parameter in Birt query. I was trying fetch first ? rows only and trying to pass this variable from user input. But sadly it didn't work.
My query is
SELECT DB2INST1.USER_DTL.EMAIL_ADDR, DB2INST1.USER_DTL.USER_LOGON_ROW_ID,
DB2INST1.AUDIT_TRAIL.AUDIT_REQ_TXT, DB2INST1.AUDIT_TRAIL.AUDIT_RESP_TXT,
DB2INST1.AUDIT_TRAIL.SRV_NM, DB2INST1.AUDIT_TRAIL.STAT_CD, DB2INST1.AUDIT_TRAIL.CREAT_TMS,
DB2INST1.AUDIT_TRAIL.HTTP_HDR, DB2INST1.AUDIT_TRAIL.AUDIT_TRAIL_ROW_ID
FROM
DB2INST1.AUDIT_TRAIL JOIN DB2INST1.USER_DTL ON DB2INST1.AUDIT_TRAIL.USER_LOGON_ROW_ID = DB2INST1.USER_DTL.USER_LOGON_ROW_ID
WHERE DB2INST1.AUDIT_TRAIL.CREAT_TMS BETWEEN ? AND ?
AND DB2INST1.USER_DTL.EMAIL_ADDR LIKE ? AND DB2INST1.AUDIT_TRAIL.SRV_NM LIKE ?
AND DB2INST1.AUDIT_TRAIL.STAT_CD LIKE ?
Please suggest
|
|
|
Powered by
FUDForum. Page generated in 0.03201 seconds