Flexmonster Software License Agreement (“Agreement”) has been revised and is effective as of January 8, 2025.
The following modifications were made:
The modified version of Agreement is available here.
Downloading, installing, and/or continuing to use Flexmonster Software after January 8, 2025, constitutes Licensee’s acceptance of the terms and conditions of the modified version of Agreement. If Licensee does not agree to any of these terms and conditions, they must cease using Flexmonster Software and must not download, install, use, access, or continue to access Flexmonster Software. By continuing to use Flexmonster Software or renewing the license or maintenance after the effective date of these modifications to Agreement, Licensee accepts and agrees to be bound by the terms and conditions of the modified Agreement.
An object used in the custom data source API requests. It contains a query filter.
{
field: FieldObject,
include: MemberFilterObject[],
exclude: MemberFilterObject[],
query: {
(condition): string | number | string[] | number[]
},
value: {
field: FieldObject,
func: string
}
}| Property/Type | Description |
|---|---|
| field FieldObject | The field to apply the filter to. |
| include MemberFilterObject[] | optional Field members to include. |
| exclude MemberFilterObject[] | optional Field members to exclude. |
| query Object | optional A conditional filter. |
| query.(condition) String | Number | String[] | Number[] | Value for the condition, where condition to apply is (condition). |
| value Object | optional The value to which a conditional filter is applied. |
| value.field FieldObject | The value by which the data should be filtered. |
| value.func String | The aggregation function name. For each field, the list of supported aggregations is defined in the response to the /fields request. Supported values may include: "sum", "count", "distinctcount", "average", "median", "product", "min", "max", "stdevp", "stdevs", "none". Note: for the fields of the "number" type, Flexmonster Pivot supports built-in front-end aggregations. |
1. Example of the "query" with an array of FilterObjects that describes a conditional filter:
"query": {
"filter": [{
"field": {
"uniqueName": "city"
},
"query": {
"begin": "toro"
}
}],
"aggs": {
"values": [{
"func": "sum",
"field": {
"uniqueName": "price"
},
}],
"by": {
"rows": [{
"uniqueName": "city"
}]
}
}
}2. Example of the "query" with an array of FilterObjects that describes a value filter:
"query": {
"filter": [{
"field": {
"uniqueName": "city"
},
"query": {
"top": 3
},
"value": {
"func": "sum",
"field": {
"uniqueName": "price"
}
}
}],
"aggs": {
"values": [{
"func": "sum",
"field": {
"uniqueName": "price"
}
}],
"by": {
"rows": [{
"uniqueName": "city"
}]
}
}
}/handshake request
/fields request
/members request
/select request for pivot table
/select request for flat table
/select request for drill-through view