# GetAdvancedSearchValues - Advanced Documentation

## Overview

Executes advanced search queries with aggregate calculations on specified fields across multiple saved searches. Used primarily by KPI dashboard widgets to display calculated metrics and summary statistics.

## Parameters

- **Requests** - array of `AdvancedSearchValueRequest` objects, each specifying a `SearchID` and a `Fields` list with aggregate functions
- **PersonID** - ID of the person executing the searches

## Supported Aggregates

- `count` - number of rows
- `sum` - sum of numeric field values
- `average` - average of numeric field values
- `min` - minimum numeric field value
- `max` - maximum numeric field value
- Default (unrecognized) - falls back to `count`

## Return Structure

Returns `AdvancedSearchValueResult` objects grouped by `SearchID`, each containing a list of `AdvancedSearchValue` entries (Name + Value).

## Implementation Details

- Runs searches in parallel using `AsParallel().Select()` - each request gets its own `UnitOfWork` with a separate database connection
- Each parallel thread validates the user's company access independently
- Requires current person login and valid company selection
- All Requests must have at least one Field; throws `RadoloException` if Requests is empty or any Request has no Fields