Failing to hide column when PIVOT is used

LabKey Support Forum (Inactive)
Failing to hide column when PIVOT is used Will Holtz  2016-03-23 18:06
Status: Closed
 
In the following code, I set metadata to hide a column, but the column is still displayed. If the PIVOT line is commented out, then the column does get hidden. I am testing this on Labkey r41716 with Postgres v9.5. Is this an expected limitation of the PIVOT or has something gone wrong?

thanks!
-Will

<div id="MyDiv"></div>
<script type="text/javascript">
Ext4.onReady(function() {
    var qwp1 = new LABKEY.QueryWebPart({
        renderTo: 'MyDiv',
        schemaName: 'Core',
        sql: `
            SELECT
                myGroup,
                attribute,
                AVG(value) as meanValue
            FROM
                (SELECT
                    'cats' AS myGroup,
                    'tails' AS attribute,
                    1 AS value
                )
            GROUP BY
                myGroup,
                attribute
            PIVOT meanValue BY attribute;
        `,
        metadata: {type: 'xml', value:
            `<tables xmlns="http://labkey.org/data/xml">
                <table tableName="MyQuery" tableDbType="NOT_IN_DB">
                    <columns>
                      <column columnName="myGroup">
                        <columnTitle>A Hidden Column</columnTitle>
                          <isHidden>true</isHidden>
                       </column>
                    </columns>
                </table>
            </tables>
            `
        }
    });
});
</script>
 
 
Jon (LabKey DevOps) responded:  2016-03-25 11:30
Hi Will,

I'm suspecting this might be broken. Even with the PIVOT, the other XML controls work without issue, like the columnTitle.

I'll setup a bug to get this investigated further.

Regards,

Jon
 
Jon (LabKey DevOps) responded:  2016-03-25 11:40
Hi Will,

I've created bug https://www.labkey.org/issues/home/Developer/issues/details.view?issueId=26041 to track this issue.

Regards,

Jon
 
Will Holtz responded:  2016-03-25 11:44
Thanks Jon!

-Will
 
Jon (LabKey DevOps) responded:  2016-10-05 23:05
Hi Will,

This has been fixed in 16.3 r46715

Regards,

Jon