Sounds like a good approach. And getting the output in xslt is not a problem.
Now, since I don't know the alias names of your docType properties I'm going to make some up. You'll need to modify according to your actual alias names. (I typed this in the forum so there's always a chance of a typo)
Code:<xsl:template match="/">
<xsl:for-each select="umbraco.library:GetXmlAll()/node [
@nodeTypeAlias='OccuranceDocType'
and data[@alias='MovieDate'] >= umbraco.library:GetDateTimeNow()
]">
<xsl:sort select="data[@alias='MovieDate']"/>
<xsl:sort select="data[@alias='MovieStartTime']"/>
<!-- assuming the above selected and then sorted all the movie occurances properly, display them -->
<xsl:value-of select="data[@alias='MovieDate']"/>
<xsl:value-of select="data[@alias='MovieStartTime']"/>
-
<xsl:value-of select="../@nodeName"/>
</xsl:for-each>
</xsl:template>
As you can see, there are only a few steps involved, though you can embellish to your heart's content :)
First, we select all the nodes in the content section of the proper docType (that is, @nodeTypeAlias). We further limit the list to only those nodes that are for today or in the future (I'll need to double-check that code, I may have made that function up... but the idea of what you want to do is at least correct).
Second, once we've got all the movie occurances for today and in the future, we sort them by date and then by time.
Third, we print out the result for each of those nodes, taking advantage of the fact that the parent of a MovieOccurance docType is a Movie docType. I've assumed you just use the node name for the movie title but if you've got a separate property on the Movie docType you'd just change the select to <xsl:value-of select="../data[@alias='MovieTitle']"/>
Hope that helps.
cheers,
doug.
By the way... if my xslt code above doesn't work you can start with a simpler version that will and then add to it to narrow down the output:
Code:<xsl:template match="/">
<xsl:for-each select="umbraco.library:GetXmlAll()/node [
@nodeTypeAlias='OccuranceDocType'
]">
<!-- assuming the above selected and then sorted all the movie occurances properly, display them -->
<xsl:value-of select="data[@alias='MovieDate']"/>
<xsl:value-of select="data[@alias='MovieStartTime']"/>
-
<xsl:value-of select="../@nodeName"/>
</xsl:for-each>
</xsl:template>
MVP 2007-2009 -
Percipient Studios