I would like to use in my filter a case statement that filter a list of values in case a object meet a condition. This is what I did:
?Property? = '10'
I only want to get information from the query when the department is 1,2,3 for property = 10 or 1 for any other property value. (Department is a varchar)
But I got a parsing error:
QE-DEF-0261 QFWP - Parsing text: DEPARTMENT IN (CASE WHEN ?Property? = '10' THEN ('1','2','3') ELSE '1' END)QE-DEF-0260 Parsing error before or near position: 14 of: "DEPARTMENT IN"QE-DEF-0261 QFWP - Parsing text: DEPARTMENT IN (CASE WHEN ?Property? = '10' THEN ('1','2','3') ELSE '1' END)RSV-SRV-0042 Trace back:RSReportService.cpp(779): QFException: CCL_CAUGHT: RSReportService::process()RSReportServiceMethod.cpp(265): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchWait_RequestRSASyncExecutionThread.cpp(788): QFException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(224): QFException: CCL_CAUGHT: RSASyncExecutionThread::run(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(838): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRunSpecification_RequestExecution/RSRenderExecution.cpp(606): QFException: CCL_RETHROW:
Any ideas? Thank you :)
This topic has been locked.
6 replies Latest Post - 2012-06-11T16:01:40Z by cindysol2000
Pinned topic How to get a list of values from a case statement
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-06-11T16:01:40Z at 2012-06-11T16:01:40Z by cindysol2000
Re: How to get a list of values from a case statement2012-06-09T02:34:51Z in response to cindysol2000That is probably my bad, should have stuck with the original. Please give the attached filter expression a try and let's see what happens.