Hide blank values in SSPL

Apr 4, 2023 11:24AM

Summary:

Content (required):

I want to hide blank values in a SSPL - 'SomeSSPL' . This attributes shows the values from a data table column - DataTableCol3 - I tried the below code

{$and:[{DataTableCol1:"|SomeCPQ attr1|"},{DataTableCol2:"|SomeCPQ attr2|"},{DataTableCol3:{$ne:"" }}]}

This is written in the mongoDB filter section of the SSPL attribute 'SomeSSPL'. This SSPL has DataTableCol3 column under the *Display dropdown.

When I use the above code, it shows me 1 blank value. I am sure there are other ways to achieve this, kindly need your help

Version (include the version you are using, if applicable):

Hide blank values in SSPL

Howdy, Stranger!