Rate this page:

Content Property Index Key Configuration

A Content Property Index Key Configuration defines which values from your JSON content property object should be indexed by Confluence and made available to the CQL search syntax.

Each content property key will define one or more extractions which will allow for multiple values from your JSON content property to be used in CQL. Each extraction defines a single field that will be queryable using the relevant CQL syntax as seen below.

In the wordcount example, we store details of the page that describe the word and character counts.

After storing this JSON object as a content property:

1
2
3
4
5
6

 {
     "wordCount": 5
     "characterCount": 22
 }
 

We then define a series of extractions to allow access to the 'wordCount' and 'characterCount' properties.

1
2
3
4
5
6
7
8
9

 {
   "propertyKey": "wordcount_addon",
   "extractions": [
     { "objectName": "wordCount", "type": "number" },
     { "objectName": "characterCount", "type": "number" }
   ]
 }
 

You can access this property in your CQL queries as:

1
2
3

 space = currentSpace() and content.property[wordcount_addon].wordCount <= 1000
 

This is constructed using the following:

1
2
3

 content.property[propertyKey].objectName
 

You can simplify the CQL syntax even further by defining an alias for the extraction:

1
2
3
4
5
6
7
8

 {
   "propertyKey": "wordcount_addon",
   "extractions": [
     { "objectName": "wordCount", "type": "number", alias: "wordcount" }
   ]
 }
 

This allows you to refer to your data using the alias:

1
2
3

 space = currentSpace() and wordcount <= 1000
 

Important: the alias must also be globally unique. Prefixing it with the name of your add-on is the best way to ensure this.

Example

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
{
  "propertyKey": "attachment",
  "extractions": [
    {
      "objectName": "attachment.size",
      "type": "number"
    },
    {
      "objectName": "attachment.type",
      "type": "string",
      "alias": "contentType",
      "uiSupport": {
        "defaultOperator": "~",
        "name": {
          "value": "Content Type",
          "i18n": "attachment.type.name"
        },
        "tooltip": {
          "value": "Content Type Tooltip",
          "i18n": "attachment.type.tooltip"
        },
        "dataUri": "/data/content-types",
        "valueType": "string"
      }
    },
    {
      "objectName": "attachment.updated",
      "type": "date"
    }
  ]
}

Properties

extractions
Type
Required
Yes
Description

The list with references to values of JSON objects which will be indexed and the types of referenced values.


propertyKey
Type
Max length
100
Required
Yes
Description

The key of the property from which the data is indexed. Only alphanumeric characters are allowed, and it must be globally unique. Prefixing it with the name of your add-on is the best way to ensure this.


Rate this page: