2 Replies Latest reply on Mar 6, 2019 6:00 PM by user1254328

    content quer

    user1254328

      Hello,

       

      we are using 12.2.1.3

       

      within portal we have configured 4 UCM connections. Each are going to different UCM.  Of-course one of them is Active / Default

       

      we are dropping a CP TaskFlow on directly on portal page. we do not want to use the Content Presenter Configuration as ours is a pretty custom cmis query. so we use Content Presenter Configuration merely so select the UCM Repository from the dropdown. name of repo we select is   NonDefaultUCM.

       

      That is the reason - Instead of clicking edit  of CP Tasklow ...   we go to   Parameters.

       

      Now per oracle doc

       

      1>    Data Source = here u type CMIS custom query

        2>   Data Source Type = here select Query Expression

       

      so at point 1 textfield box do we simply type   SELECT * FROM ora:t:IDC:GlobalProfile WHERE  cmis:createdBy ='POMPOS'   ?

       

      Reason for asking is if we type cmis and click ok we notice in the Content Repository Configuration it will automatically will change the UCM Repository to DefaultUCM. why ?

      bcaz we do not want to run our custom select against DefalutUCM. We had selected it to run against NonDefaultUCM.

       

      why does using Parameter option changes the Repository ?  Alternatively, what is there a way to specify in SELECT query that it MUST run against NonDefaultUCM ?

       

      Thanks