# PluginVisualTableQuerySortProperty

The table query sorting options for the plugin visual.

- Source: Generated code
- Type last changed: v2.172.0 · 7 Dec 2024

## 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.CfnDashboard.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

- `itemsLimitConfiguration`: [IResolvable](/cdk/api/v2/docs/aws-cdk-lib.IResolvable.html) | [CfnDashboard.PluginVisualItemsLimitConfigurationProperty](/cdk/api/v2/docs/aws-cdk-lib.aws_quicksight.CfnDashboard.PluginVisualItemsLimitConfigurationProperty.html) — The maximum amount of data to be returned by a query.

- `rowSort`: [IResolvable](/cdk/api/v2/docs/aws-cdk-lib.IResolvable.html) | [IResolvable](/cdk/api/v2/docs/aws-cdk-lib.IResolvable.html) | [CfnDashboard.FieldSortOptionsProperty](/cdk/api/v2/docs/aws-cdk-lib.aws_quicksight.CfnDashboard.FieldSortOptionsProperty.html)[] — Determines how data is sorted in the response.