Can't get column widths right in query | jdutra | 2011-12-09 13:38 |
Status: Closed | ||
I have a very simple query: SELECT Result AS "Flu Type", COUNT(ParticipantId) AS "Number of Positives" FROM "rtPCR Result Dataset" WHERE Result<>'Negative' GROUP BY Result with the following Metadata <ns:tables xmlns:ns="http://labkey.org/data/xml" xmlns="http://labkey.org/data/xml/query"> <ns:table tableName="PCR_Positives" tableDbType="NOT_IN_DB"> <ns:columns> <ns:column columnName="Flu Type"> <ns:displayWidth>400</ns:displayWidth> </ns:column> <ns:column columnName="Number of Positives"> <ns:displayWidth>100</ns:displayWidth> </ns:column> </ns:columns> </ns:table> </ns:tables> Basically, I would like the Flu Type to have enough room that it will fit on one line. The Number of Positives is a number less than 100, and doesn't need much room at all. However, no matter what displayWidths I put in the metadata, the Flu Type column stays tiny. I have successfully used metadata very similar to the above in other queries, and it has worked. In fact, if I add a random column to this query, and give that column a displayWidth, it works. But the displayWidth on the two existing columns does not seem to work. A picture of the resulting query is attached. Any suggestions would be appreciated! - Jen |
||