Get Intersect of Sequences in XPath for XSLT

mail4kaja · January 30th, 2009, 02:19 AM

Hello everyone...

I'm building a inventory kind of application where I'm building the Navigation using XSLT on my Data model. My model looks something similar to the following.

Code:

 
<MyStore>
 <Items>
  <Item itemId="1"><Name>Item One</Name>....</Item>
  <Item itemId="2"><Name>Item Name 2</Name>....</Item>
  <Item itemId="3"><Name>Item Name 3</Name>....</Item>
  <Item itemId="4"><Name>Item Four</Name>....</Item>
 </Items>
 <Categories>
   <Category catId="1">
     <Item ItemId="2"/>
     <Item ItemId="3"/>
  </Category>
   <Category catId="2">
     <Item ItemId="1"/>
     <Item ItemId="2"/>
     <Item ItemId="4"/>
  </Category>
 </Categories>
</MyStore>

I'm using backbase. I'm creating a listgrid for each category to list the items in it.

My XSLT looks likes this.

Code:

<xsl:for-each select"Categories/Category">
<!-- selecting @ItemId will give the list of ItemIds in THAT category -->
<b:listgrid>
<b:colgrid select="XPATH"/>
<!-- Here, I need to give an XPath that gives the list of ItemNames whose itemIds are present in Category -->
</b:listgrid>
</xsl:for-each>

I'm using for-each to process each category. I can get the list of ItemIds, but how to I get the XPath that gives the ItemNames of those Items.

Please help me..

Thanks in advance,

With regards,
R Kaja Mohideen

mrame · January 30th, 2009, 02:38 AM

Your question is not clear. Please post the xslt script you are using and also post the needed output from the input xml.

mail4kaja · January 30th, 2009, 03:07 AM

Thanks for your comment, updated my post.

mrame · January 30th, 2009, 04:21 AM

Try the below:

Code:

 
<xsl:template match="MyStore">
<xsl:for-each select="Categories/Category">
<b:listgrid>
<b:colgrid>
<xsl:for-each select="Item">
<xsl:if test="@ItemId = ../../../Items/Item/@itemId">
<xsl:variable name="id" select="@ItemId"></xsl:variable>
<xsl:value-of select="../../../Items/Item[@itemId = $id]/Name"/>
</xsl:if>
</xsl:for-each>
</b:colgrid>
</b:listgrid>
</xsl:for-each>
</xsl:template>

mrame · January 30th, 2009, 04:35 AM

You can also delete the xsl:if, if its not needed at that place.

mhkay · January 30th, 2009, 04:41 AM

Note that technically what you are looking for is a join, not an intersection. It helps to learn the terminology as your searches for information (in google or in the index of a good old book) are likely to be more successful.

I'm afraid I don't know what "backbase" is, and I'm therefore rather unclear whether you are looking for an XSLT solution or a pure XPath solution (and if so, whether XPath 1.0 or XPath 2.0). In XSLT, a solution like that from mrame works fine. In pure XPath 1.0, joins can be difficult unless you are able to bind variables.

mail4kaja · January 30th, 2009, 07:21 AM

Thanks mrame. But, I can't do any transform there inside colgrid. I just need a XPath that gives me the List of Item Names for that group. So that listgrid will populate its table column.

Code:

<b:colgrid select="XPATH"/>

mhkay, I think i need an XPath solution. May be in 1.0 or 2.0 ...

Please help me.

Thanks & Regards,
R Kaja Mohideen

mrame · February 2nd, 2009, 03:19 AM

As already said, post the needed output xml for the posted input xml. So that it wuold be easy for us to give the exact solution.