Codes for Search Light results

bmirzai
bmirzai Newcomer
in Refinitiv Data Platform

Hi,

I am investigating RDP search light and wondering where I can find list of all codes for the following fields: AdjustmentFactorCode, RCSCurrency, Unit. For example, all these fields can be found in results of next query:

{
    "View": "SearchAllLight",
    "Filter": "RIC eq 'aXZCGDPD/CA'",
    "Select": "_debugalllight"
}

Can you help me with this?

Tagged:

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    @bmirzai

    Thanks for reaching out to us.

    If you mean the possible values of those fields, you can use the "GroupBy" or "Navigators" property.

    The "AdjustmentFactorCode" field supports the "GroupBy" property and the "RCSCurrency" and "Unit" fields support both the "Navigators" and "GroupBy" properties. 

     "AdjustmentFactorCode": {
          "Type": "String",
          "Searchable": true,
          "Sortable": true,
    "Groupable": true,
          "Exact": true,
          "Symbol": true
        },
    ...
        "RCSCurrency": {
          "Type": "String",
          "Searchable": true,
    "Navigable": true,
          "Groupable": true,
          "Exact": true
        },
    ...
       "Unit": {
          "Type": "String",
          "Searchable": true,
          "Sortable": true,
    "Navigable": true,
          "Groupable": true,
          "Exact": true
        },

    The request with the "GroupBy" property looks like this:

    {
      "View": "SearchAllLight",
      "GroupBy": "AdjustmentFactorCode",
      "Filter": "AdjustmentFactorCode ne null",
      "GroupCount": 1,
      "Select": "RIC,DocumentTitle,AdjustmentFactorCode,RCSCurrency,Unit",
      "Top": 10000
    }

    The requests with the "Navigators" property look like this:

    {
      "View": "SearchAllLight",
      "Navigators": "RCSCurrency(buckets:1000)",
      "Select": "RIC,DocumentTitle,AdjustmentFactorCode,RCSCurrency,Unit",
      "Top": 0
    }
    {
      "View": "SearchAllLight",
      "Navigators": "Unit(buckets:1000)",
      "Select": "RIC,DocumentTitle,AdjustmentFactorCode,RCSCurrency,Unit",
      "Top": 0
    }

    I hope that this information is of help.

Answers

Categories