Function convertFilter

packages/powerbi/src/convertFilter.ts:8–36

(searchFilter: SandDance.searchExpression.Search, columns: powerbiVisualsApi.DataViewMetadataColumn[], data: object[])

import { SandDance } from '@msrvida/sanddance-explorer';

export function convertFilter(searchFilter: SandDance.searchExpression.Search, columns: powerbiVisualsApi.DataViewMetadataColumn[], data: object[]) {
    const selectedIds: powerbiVisualsApi.extensibility.ISelectionId[] = [];
    const filters: powerbiModels.IFilter[] = [];
    const groups = SandDance.searchExpression.ensureSearchExpressionGroupArray(searchFilter);
    groups.forEach(group =>
        group.expressions.forEach(ex => {
            if (!ex) return;
            if (ex.name === SandDance.constants.GL_ORDINAL) {
                // it would be ideal to filter to a single row identity, but the PoerBI API currently does not let us do that.
                // so, we will filter to data points that have the same values
                const dataPoint = getDataPoint(<number>ex.value, data);
                if (dataPoint) {
                    filterSimilar(dataPoint, columns, filters);
                    // then we will select this data point
                    selectedIds.push(dataPoint[SandDance.constants.FieldNames.PowerBISelectionId]);
                }
            } else {
                const column = columns.filter(c => c.displayName === ex.name)[0];
                if (column) {
                    const advancedFilter = convertExpressionToAdvancedFilter(ex, column);
                    if (advancedFilter) {
                        filters.push(advancedFilter.toJSON());
                    }
                }
            }
        }),
    );
    return { filters, selectedIds };
}

function getDataPoint(GL_ORDINAL: number, data: object[]) {
    for (let i = 0; i < data.length; i++) {