Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

the escape character in the where clasue fileter on logical layer

island_manAug 7 2012 — edited Aug 7 2012
My application requires "WHERE Clause" filter on logical layer 's table where an in-list is passed from a session variable.

for example , I get an session named "UserList" as ( 'jack','ken');

and I want to filter the information by the Userlist, but it seems has have escape charater problem, the single quote will cause problem.
it work all right when I add " 'jack','ken' " manually in where caluse, but if I use VALUEOF(NQ_SESSION."userList") , it failed,


there are some information for your reference:
1. in the answer, I want to know the value of "UserList", here I show it in statc text: @{biServer.variables["NQ_SESSION.UserList"]}

it shows like below
jack','ken

2. in the session vailable initializaiton block, I test it , the "Userlist" work well, it get 'jack','ken' as we expected.

Edited by: island_man on Aug 7, 2012 12:26 AM

Edited by: island_man on Aug 7, 2012 12:27 AM
This post has been answered by Dpka on Aug 7 2012
Jump to Answer

Comments

User_L2G4Q

Reinstalled with previous release 18.1.2.1.0 and worked fine.

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 4 2012
Added on Aug 7 2012
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #in, #list
3 comments
83 views