wissel.net

wissel.net

Usability - Productivity - Business - The web - Singapore & Twins

What are you hiding from me?

By now you should be able to extract your database design as DXL. This opens a series of possibilities to run reports against your database to gain more insights into its design. Since Notes is around for so many years you will face the situation to inherit a database you haven't written. To understand its logic you need so see how Hide-when formulas have been used in the all over design. The following XSLT allows you to do this extraction.

Use it at a starting point and play with the layout. Ideas you could look at: Pack the whole report into a single table and load it into your favorite spreadsheet for sorting (a fancy Ajax lib could do that to).

<xsl:stylesheet version= "1.0" >
<xsl:output method= "xml" version= "1.0" encoding= "UTF-8" indent= "yes" />
<xsl:template match= "/" >
<html >
<head >
<title />
<style type= "text/css" />
</head>
<body >
<table >
<xsl:apply-templates select= "//d:form" />
<xsl:apply-templates select= "//d:subform" />
</table>
</body>
</html>
</xsl:template>
<xsl:template match= "d:form" >
<tr >
<th colspan= "3" >
<h1 > Form
<xsl:value-of select= "@name" />
</h1>
</th>
</tr>
<tr >
<th />
<th />
<th />
</tr>
<xsl:apply-templates select= "//d:pardef[d:code/@event='hidewhen']" />
</xsl:template>
<xsl:template match= "d:subform" >
<tr >
<th colspan= "3" >
<h1 > Subform
<xsl:value-of select= "@name" />
</h1>
</th>
</tr>
<tr >
<th />
<th />
<th />
</tr>
<xsl:apply-templates select= "//d:pardef[d:code/@event='hidewhen']" />
</xsl:template>
<xsl:template match= "d:pardef" >
<tr >
<td bgcolor= "#EEEEFF" >
<xsl:value-of select= "@id" />
</td>
<td bgcolor= "#EEFFEE" >
<xsl:value-of select= "d:code/@enabled" />
</td>
<td bgcolor= "#FFEEEE" >
<xsl:value-of select= "d:code[@event='hidewhen']/d:formula" />
</td>
</tr>
</xsl:template>
</xsl:stylesheet>

Posted by on 19 July 2006 | Comments (0) | categories: Show-N-Tell Thursday

Comments

  1. No comments yet, be the first to comment