FilterField
| Field | NULL | Description | Note |
|---|---|---|---|
| filterId string (GUID) | The id of the filter | ||
| reportFieldAlias string | The alias of the field | ||
| reportPartTitle string | The report part title | ||
| querySourceFieldId string (GUID) | The id of the query source field | ||
| querySourceType string | Either “Table”, “View”, “Stored Procedure” or “Function” | ||
| querySourceId string (GUID) | Y | The id of the query source | |
| relationshipId string (GUID) | Y | The id of the relationship if this field is in a relationship | |
| alias string | The alias of the field | ||
| position integer | The position in the list of filters | ||
| visible boolean | Is the filter field visible | ||
| required boolean | Is the filter field required | ||
| cascading boolean | Whether common filter field will be cascaded | ||
| operatorId string (GUID) | Y | The id of the operator | |
| operatorSetting string | The operator setting | ||
| value string | The value for the filter field and the selected operator | ||
| dataFormatId string (GUID) | Y | The id of the display format for the filter field | |
| sortType string | Either “Unsorted”, “Ascending” or “Descending” | ||
| fontFamily string | The font family | ||
| fontSize integer | The font size | ||
| textColor string | The text color | ||
| backgroundColor string | The background color | ||
| fontBold boolean | Is the text in bold | ||
| fontItalic boolean | Is the text in italic | ||
| fontUnderline boolean | Is the text underlined | ||
| querySourceUniqueName string | A unique name for query source | ||
| querySourceFieldName string | The name of query source field | ||
| comparisonFieldUniqueName string | The unique name for comparison field | ||
| isNegative boolean | Whether this filter field is indeterminate |
Inherited fields:
Entity
| Field | NULL | Description | Note |
|---|---|---|---|
| id string (GUID) | The id of this object Example: 572bd576-8c92-4901-ab2a-b16e38144813 | Allow null incase insert a new entity | |
| state integer | The entity state of this object
| ||
| deleted boolean | Is this object deleted | ||
| inserted boolean | Is this object inserted | ||
| version string | Y | The version | |
| created datetime in ISO 8601 format | Y | The created datetime | |
| createdBy string | The creator | ||
| modified datetime in ISO 8601 format | Y | The modification datetime | |
| modifiedBy string | The user who last modified this object |