function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Raviraj KhareRaviraj Khare 

Boolean value binding on table properties - Data type issue

I have defined a toggle control for user to select whether the table should be pivoted or not.  Here is the code of my static (Toggle) object: 
"static_1": {
                "broadcastFacet": true,
                "columns": {},
                "label": "Display Mode",
                "selectMode": "singlerequired",
                "type": "staticflex",
                "values": [
                    {
                        "Display": "Pivoted",
                        "value": true,
                        "value2": false
                    },
                    {
                        "Display": "Non-Pivoted",
                        "value": false,
                        "value2": true
                    }
                ],
                "numbers": [],
                "strings": [],
                "groups": []
            },
Ignore the value2 for now.  I plan to use them for other stuff.
 
Then, in my table properties, I have defined this static control as the "pivoted" value: 
...
        "minColumnWidth": 40,
        "mode": "variable",
        "numberOfLines": 1,
        "pivoted": "{{cell(static_1.selection,0,\"value\").asObject()}}",
        "showActionMenu": true,
        "showRowIndexColumn": false,
        "verticalPadding": 8,
...

Once I have made this change, the dashoard correctly allows me to toggle the pivoted view.  But when I try to "save" the dashboard, I receive the following error:
 
  Value does not match expected type at [line:1, column:1529]

I even tried using SAQL to ensure I'm selecting a BOOLEAN value: 
q = foreach q generate 'ROLL_IND' as 'ROLL_IND', (case when 'ROLL_IND' == \"C\" then true else false end) as 'booleanField';

and then using this booleanfield value in the property: 
...
        "minColumnWidth": 40,
        "mode": "variable",
        "numberOfLines": 1,
        "pivoted": "{{cell(lens_2.result, 0, \"booleanField\").asObject()}}",
        "showActionMenu": true,
        "showRowIndexColumn": false,
        "verticalPadding": 8,
...

But all in vain.  I still receive the same error:
  Value does not match expected type at [line:1, column:1529]


Has anyone else come across such requirement and  have got it to work successfully?

Any help / hints would be appreciated.

Regards,
Raviraj Khare