Skip to Main Content
Forums

Application Development 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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

IN cmis query

user1254328Mar 22 2019 — edited Apr 8 2019

Hello,

we have webcenter content and portal 12.2.1.3

SELECT * FROM ora:t:IDC:GlobalProfile WHERE ora:p:xRegistrationName  IN  ( 'Yes' , 'No' )   will fetch us records.

BUT

SELECT * FROM ora:t:IDC:GlobalProfile WHERE ora:p:xRegistrationIdentifierNumber  IN  (  45789 ,  23567 , 33445, 65432 )   -  why this query wont fetch us any records where we are expecting it to fetch 4 records. ?

Comments

Processing

Post Details

Added on Mar 22 2019
#webcenter, #webcenter-content
13 comments
249 views