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.

Make sure to copy each required FilterControl JSON object exactly as it is exported, then use the array as the value of the V2 model property bound to filters-v2. Dontt change generated identifiers, formulas, or `address` values unless you understand the effect on the filter definition.

For the V2 <oracle-dv> binding and initialization example, see Use the filters-v2 Property to Pass Filters.

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"
                        },