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> |
|||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||