![]() |
||||||||||||
Go ![]() | New ![]() | Search ![]() | Notify ![]() | Tools ![]() | Reply ![]() | ![]() |
Platinum Member |
Hi, I have a requirement where i need to use LIKE operator in where clause. I figured out how to use it. --other where clause-- AND DIM_LOCATION.ADDRESS_LINE_1 LIKE '%&ADDRESS|%' The address parameter is not a mandatory input and if the user is not filtering for Address it will pass _FOC_NULL and in that case my whole report given empty data because the where clause filter for --other where clause-- AND DIM_LOCATION.ADDRESS_LINE_1 LIKE '%_FOC_NULL%' I think it should be AND DIM_LOCATION.ADDRESS_LINE_1 LIKE '%_FOC_NULL%',but when the user filters for some address then it should be AND. Any logical workaround to tackle this situation?This message has been edited. Last edited by: srajeevan, WF8202M,Windows 7,8,10 HTM,PDF,EXCEL | ||
|
Virtuoso |
Can you use a second WHERE ADDRESSLINE LIKE instead of using AND? That way what happens to the second where test doesn't effect the first one. WHERE first condition; -IF &ADDRESS EQ _FOC_NULL GOTO SKIP; WHERE second condition; -SKIP WebFOCUS 8206, Unix, Windows | |||
|
Platinum Member |
Thanks BabakNYC it worked. WF8202M,Windows 7,8,10 HTM,PDF,EXCEL | |||
|
Powered by Social Strata |
![]() | Please Wait. Your request is being processed... |
|