PluginVisualTableQuerySortProperty Struct
The table query sorting options for the plugin visual.
Example
ts
// The code below shows an example of how to instantiate this type.
// The values are placeholders you should change.
import { aws_quicksight as quicksight } from 'aws-cdk-lib';
const pluginVisualTableQuerySortProperty: quicksight.CfnAnalysis.PluginVisualTableQuerySortProperty = {
itemsLimitConfiguration: {
itemsLimit: 123,
},
rowSort: [{
columnSort: {
direction: 'direction',
sortBy: {
columnName: 'columnName',
// the properties below are optional
dataSetIdentifier: 'dataSetIdentifier',
topicIdentifier: 'topicIdentifier',
},
// the properties below are optional
aggregationFunction: {
attributeAggregationFunction: {
simpleAttributeAggregation: 'simpleAttributeAggregation',
valueForMultipleValues: 'valueForMultipleValues',
},
categoricalAggregationFunction: 'categoricalAggregationFunction',
dateAggregationFunction: 'dateAggregationFunction',
numericalAggregationFunction: {
percentileAggregation: {
percentileValue: 123,
},
simpleNumericalAggregation: 'simpleNumericalAggregation',
},
},
},
fieldSort: {
direction: 'direction',
fieldId: 'fieldId',
},
}],
};
Properties
itemsLimitConfigurationoptionalIResolvable | CfnAnalysis.PluginVisualItemsLimitConfigurationPropertyitems_limit_configurationoptionaltyping.Union[IResolvable, PluginVisualItemsLimitConfigurationProperty]itemsLimitConfigurationoptionalIResolvableItemsLimitConfigurationoptionalIResolvableItemsLimitConfigurationoptionalinterface{}#The maximum amount of data to be returned by a query.
rowSortoptionalIResolvable | IResolvable | CfnAnalysis.FieldSortOptionsProperty[]row_sortoptionaltyping.Union[IResolvable, typing.List[typing.Union[IResolvable, FieldSortOptionsProperty]]]rowSortoptionalIResolvableRowSortoptionalIResolvableRowSortoptionalinterface{}#Determines how data is sorted in the response.