OLAP - Case sensitive

OLAP - Case sensitive

Posted by: anaprstojevic on 4 December 2024, 7:49 am EST

• 

  anaprstojevic

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 4 December 2024, 7:49 am EST - Updated 4 December 2024, 7:54 am EST

  I am using PivotEngine and CollectionView as data source. I noticed that data in Pivot are case-sensitive. Is there a way to turn it off, or more precisely, so that the data is case insensitive.?

  An example:

  In my example, I want to have one row for Dad and dad.

• 

  akshay.rajput

  

  • Post Options:
  • Link
    Copy

  Posted 5 December 2024, 5:45 am EST

  Hi Ana,

  I would request you to update the getValue method so for PivotField class so the returned value for Buyer field is Case Insensitive. Sample Code:

  import * as wjOlap from '@mescius/wijmo.olap';
  wjOlap.PivotField.prototype.getValue = function (e, t) {
      var i = this._binding,
        o = null;
      e && (o = e[i.path]);
      if (typeof o == 'string') {
        if (i.path == 'buyer')
          o = o.charAt(0).toUpperCase() + o.slice(1).toLowerCase(); //Modify Buyer Field
      }
      return t && 'string' != typeof o
        ? wjcCore.Globalize.format(o, this._format)
        : o;
    };
  
  

  For reference, please refer to the following sample application: https://stackblitz.com/edit/js-yedzmc?file=index.js

  I hope this helps!