Find the JSON Objects for the filters-v2 Property

The filters-v2 property requires an array of FilterControl JSON objects. Use the JSON tab in the workbook editor to get the initial filter syntax.

If the Developer option isn't displayed in the workbook's Menu, then you need to enable it. See Enable Oracle Analytics Developer Options.

1. Go to your Oracle Analytics home page and open the workbook containing the filters that you want to embed.
2. Click Edit to enter the workbook in author mode.
3. Click the workbook's Menu and then click Developer.
4. In the Developer window, click the JSON tab.
5. Copy the contents of the JSON tab and paste them into a text editor.
6. In the text editor, search for the filterControlCollections section.
7. Within the filterControlCollections section, locate filterControls. Within the children subsection locate the filter definition. Note that each definition starts with a unique filterID.

   For example:

   {
      "filterControlCollections": {
         "children": [
            {
               "name": "canvas 1",
               "filterControls": {
                  "children": [
                     {
                        "filterID": "a18ae41b-5a32-409b-a4e7-61df959dcbcd",
                        "columnID": "OrderPriority",
                        "type": "saw:columnFilterControl",
                        "filterControlConfig": {
                           "_version": "1.0.9",
                           "settings": {
                              "filterModelClassName": "obitech-listfilter/listfilter.ListFilterModel",
                              "location": "filter_bar"
                           }
                        },
                        "address": 0.0001,
                        "formula": {
                           "expr": {
                              "children": [],
                              "type": "sawx:sqlExpression",
                              "expression": "XSA('90e7ee56-5b6c-4106-bc9d-a23a9b38ba94'.'sr_sample_order_lines_2023').\"sample_order_lines2023\".\"Order Priority\""
                           }
                        },
                        "filterOperator": {
                           "op": "in"
                        },
                        "filterControlDefaultValues": {
                           "children": [
                              {
                                 "text": "High"
                              }
                           ],
                           "type": "specificValue"
                        },