Codes for Search Light results

bmirzai
bmirzai
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

  • bmirzai
    bmirzai

    @Jirapongse

    Thanks for your help. In my original question I forgot to mention that I also need value descriptions.

    For example what does mean:

    "AdjustmentFactorCode": "Q",

    I'll be glad if you help me find descriptions for other values of these fields.

  • Jirapongse
    Jirapongse
    @bmirzai

    Sorry. I am unable to find the descriptions of the AdjustmentFactorCode.

    You need to contact the content support team directly via MyRefinitiv for the descriptions.

Categories