public getColumnFieldNamesAndValues(cell) {
    const columnValues = cell.column.field.split('-');
    const columnFieldNames = [];
    
    // Recursive function to traverse the child levels in column hierarchy
        const traverseChildLevels = (level, names, index) => {
            names.push(level.memberName);
            if (level.childLevel && index<columnValues.length) {
                traverseChildLevels(level.childLevel, names, ++index);
            }
        };

        // Start traversal from the top-level column configuration
        this.pivotConfigHierarchy.columns.forEach(column => {
            traverseChildLevels(column, columnFieldNames,1);
        });

        // Create a Map of field names to corresponding values
        const columnMap = new Map();
        columnFieldNames.forEach((fieldName, index) => {
            columnMap.set(fieldName, columnValues[index]);
        });

        console.log("Column Field Names and Values:", Array.from(columnMap.entries()));
        return columnMap;
    }

I have also prepared a sample on StackBlitz. Please feel free to test it, and don’t hesitate to reach out if there’s anything more you’d like to discuss.

Best Regards,
Arkan Ahmedov

Infragistics

Hello Walter,

As per your request, I’ve implemented the following solutions to help you retrieve column names, row names, and filter information from the clicked cell in the IgniteUI Pivot Grid.

1. Retrieving Clicked Cell's Column and Row Names

In the onCellClick event, I’ve written a method that retrieves the column and row names when a user clicks on a cell. Here is a brief summary of the implementation:

• Column Names: We extract the clicked column’s field and split it to obtain the nested levels.
• Row Names: We retrieve the row hierarchy by traversing the data view and capturing all the dimension values up to the top-level row.
  
  

  public onCellClick(event) {
      let cc: IgxGridCell = event.cell as IgxGridCell;
      let idx: number = cc['_rowIndex'];
    
      let r = this.grid1.dataView[idx];
      let rowValuesArray = [];
      rowValuesArray.push(r.dimensionValues.entries());
      
      for (let i = r.level; i > 1; i--) {
          while (i == r.level) {
              r = this.grid1.dataView[--idx];
          }
          rowValuesArray.push(r.dimensionValues.entries());
      }
      rowValuesArray = rowValuesArray.reverse();
      let columnValues = cc.column.field.split('-').reverse();
  
      console.log(columnValues);
      console.log(rowValuesArray);
  
      this.processFilterExpressionTree();
  }

2. Extracting Filtering Information

To handle the filtering tree, I've implemented the following function which allows you to inspect the current filtering expressions applied to the grid. This function loops through the filter tree, and if any filtering has been applied, it will log the conditions, fields, and values.

This will help you extract all the necessary information from the filtering tree, including the conditions and values of the filters that have been applied.

public processFilterExpressionTree() {
    const filterTree = this.grid1.filteringExpressionsTree;

    if (filterTree && filterTree.filteringOperands.length > 0) {
        for (let i = 0; i < filterTree.filteringOperands.length; i++) {
            const operand = filterTree.filteringOperands[i];

            if (this.isFilteringExpressionsTree(operand)) {
                console.log(`Filtering Field: ${operand.fieldName}`);
                for (let j = 0; j < operand.filteringOperands.length; j++) {
                    const innerOperand = operand.filteringOperands[j];
                    if (!this.isFilteringExpressionsTree(innerOperand)) {
                        console.log(`Condition: ${innerOperand.condition.name}`);
                        console.log(`Field: ${innerOperand.fieldName}`);
                        console.log(`Values:`);
                        if (innerOperand.searchVal instanceof Set) {
                            for (const value of innerOperand.searchVal) {
                                console.log(value);
                            }
                        } else {
                            console.log(innerOperand.searchVal);
                        }
                    }
                }
            } else {
                console.log("Unknown operand type detected.");
            }
        }
    } else {
        console.log("No filters are currently applied.");
    }
}

StackBlitz Sample

I have also created a sample on StackBlitz for you to test and review. Please feel free to run the sample and see if it meets your requirements.

Also, regarding future inquiries, if you encounter any issues similar to this one, please continue creating support cases as you've done here, rather than reaching out via Discord. This way, we can better track the status of your requests and provide more structured assistance.

Looking forward to your feedback!

Best Regards,

Arkan Ahmedov

Infragistics