Subject:Help to group using WYSIWYG Author:Shalini venkateswaran Date:06 Jul 2005 04:56 PM
Need to understand how I can group using wysiwig part of tool if at all.
I have a requirement for this, i saw samples but now gui.
<data>
<record>
<KEY xml:lang="en_US">1</KEY>
<PET xml:lang="en_US">notapuppy</PET>
<ISSUE_DATE xml:lang="en_US">June 29, 2005</ISSUE_DATE>
<FULL_PATH xml:lang="en_US">notapuppy.xls</FULL_PATH>
<ACTIVE xml:lang="en_US">0</ACTIVE>
</record>
<record>
<KEY xml:lang="en_US">3</KEY>
<PET xml:lang="en_US">notapuppy</PET>
<ISSUE_DATE xml:lang="en_US">July 5, 2005</ISSUE_DATE>
<FULL_PATH xml:lang="en_US">filename.xls</FULL_PATH>
<ACTIVE xml:lang="en_US">0</ACTIVE>
</record>
</data>
Needs to show up as
Subject:Help to group using WYSIWYG Author:Ivan Pedruzzi Date:06 Jul 2005 11:24 PM
Hi Shalini,
Here what I did
- drag & drop the element "record" to the canvas and click "Add Table"
- drag & drop the element "PET" into the first cell
- right click in the second cell then click "Insert Table" (1 row 2 columns)
- drag & drop the element "FULL_PATH" in the first cell of the inner table
- drag & drop the element "ISSUE_DATE" in the second cell of the inner table
switch to XSLT source
- define the xsl key to implement the grouping
- add the predicate to the for-each loop to restrict the loop to the group
- add an inner for-each loop to pull the group values
Subject:Help to group using WYSIWYG Author:Shalini venkateswaran Date:07 Jul 2005 12:31 PM
Ivan
Thank you very much that helped.
I am sure this was not my last post. Have some many to many grouping problems, where the table column names have to be built dynamically.
I'm trying to figure out if I want to retrieve the data as one big xml (denormalized) or 3 diff ones. Will post something soon
As a famous saying goes,
I'll be back