1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to change Query of Dynamic List on Run Time in Site Studio 10gr4

Discussion in 'Oracle Webcenter Suite (formerly Oracle ECM)' started by harmaildhiman, Jul 19, 2010.

  1. harmaildhiman

    harmaildhiman Active Member

    Messages:
    34
    Likes Received:
    0
    Trophy Points:
    80
    Hi,

    I need to Query of Dynamic List on Run Time in Site Studio 10gr4 Template while
    editing Placeholder.

    e.g. Placeholder1 contain Dynamic List Element which contains a query to fetch
    Doc's on Page, we need to make query dynamic to fetch data on placeholder
    editing for different pages:

    On page /abc/doc, Placeholder should fetch Documents
    On Page /abc/pdf, Placeholder should fetch PDF's

    Means I need to change query dExtention='doc' on doc section, dExtention='pdf'
    on pdf section

    Please provide solution.

    Ragards,
    Harry
     
  2. jbecerra

    jbecerra Active Member

    Messages:
    6
    Likes Received:
    1
    Trophy Points:
    65
    Hi Harry,

    The Dynamic lists gets executed in the Region template not the placeholder.

    Edit your Region template and look for the code "<!--$executeService('SS_GET_SEARCH_RESULTS')-->")
    justs before this add something like this:
    <!--$ssQueryText = "Your base query here.. remember to encode < > characters"-->
    <!--$if strEquals(nodeId, "doc")-->
    <!--$ssQueryText = ssQueryText & "&lt;AND&gt; dExtention &lt;MATCHES&gt; `doc`"-->
    <!--$else-->
    <!--$ssQueryText = ssQueryText & "&lt;AND&gt; dExtention &lt;MATCHES&gt; `doc`"-->
    <!--$endif-->
    <!--$QueryText = eval(ssQueryText)-->