1 Reply Latest reply on Feb 14, 2020 9:49 AM by Srinath Menon-Oracle

    Get_Search_results service in WCC 11g is giving incorrect results when sorted using alphanumeric strings with decimal numbers

    4035615

      I am using GET_SEARCH_RESULTS service in WebCenter Content to get some results and using dDocTitle as sort field and Desc sort order

       

      Result are as follows:

      1. ABC using 1.4

      2. ABC using 1.3

      3. ABC using 1.2

      4. ABC using 1.11

      5. ABC using 1.1

      6. ABC using 1.0

       

      Expected result:

      1. ABC using 1.11

      2. ABC using 1.4

      3. ABC using 1.3

      4. ABC using 1.2

      5. ABC using 1.1

      6. ABC using 1.0

       

      Search engine is set as OracleTextSearch

      Any suggestions???