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 match the input value with two metadata feilds and retrive results.

Discussion in 'Oracle Webcenter Suite (formerly Oracle ECM)' started by lmohanrk, Mar 24, 2010.

  1. lmohanrk

    lmohanrk Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    HI,

    I am having a requirement like in a search profile if the user enter a value to one of the input feild I want to match the value in that particular feild as well as the another feild.

    I have two feilds like

    First Name
    Last Name
    In the search screen if the user provide a value to First Name=Mohan,I want to queriy where condition to be
    (where First Name=Mohan or Last Name=Mohan).

    Please let me know if you ever tried of similar requirement.
     
  2. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Create a Rule which is activated only on the search page and put the derived value for Field2 as the active value of field 1.
     
    lmohanrk likes this.
  3. lmohanrk

    lmohanrk Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    I tried that,It is not working.Please confirm if you are expecting the below statement in the derivved value of feild2
    <$dprDerivedValue=#active.xVendorAssetModelNo$>
    Also I have a question even it works it will insert the condition as "AND" but not "OR"
    (where First Name=Mohan and Last Name=Mohan) and not (where First Name=Mohan or Last Name=Mohan).