Formatting table results

When you are displaying a table result based on an SQL query, you have the same render hints that are offered as part of dbwql.

To use these hints, add a “result-table-format” tag to the result.

<result>
   <sql>select a, b, c from sometable</sql>
   <result-type>TABLE</result-type>
   <result-table-format>
      <columns>
         <column>
            <number>2</number>
            <hashtag>#width(200)</hashtag>
         </column>
      </columns>
   </result-table-format>
</result>

The previous definition will force the second column of the result to a width of 200.

For a complete list of available hashtags, see the dbwql specification

← Management / Result types →