Answered
XMLDataSet Filter
This should be simple, but I just can't find the answer at
the moment. I am trying to apply a filter to a spry table using a
XMLDataSet by selecting a value in a Spry validation select.
The XMLdata that drives the table is as follows
var ds2 = new Spry.Data.XMLDataSet("Data/NetballDatafeed190401.xml", "NetballList/NetballProducts[SubType='{ds3::Type}']",{sortOnLoad:"SubType",sortOrderOnLoad:"ascending"});
One of the fields in the XML table is SubType and so I am using [SubType='{ds3::Type}']" to dynamically set this up as I change the drop down selection.
The spry drop down selection is defined as
<div spry:region="ds3">
<select name="select" onchange="ds3.setCurrentRow(this.value)" spry:repeatchildren="ds3">
<option value="{ds_RowID}}">{Type}</option>
</select>
</div>
On loading the table shows the selection of data I want, however once I select a value from the dropdown list the table goes blank. The ds3 dataset that drives the dropdown list has 1 field which is all the different options to filter ds2 on.
Any help or different solutions would be gratefully received
The XMLdata that drives the table is as follows
var ds2 = new Spry.Data.XMLDataSet("Data/NetballDatafeed190401.xml", "NetballList/NetballProducts[SubType='{ds3::Type}']",{sortOnLoad:"SubType",sortOrderOnLoad:"ascending"});
One of the fields in the XML table is SubType and so I am using [SubType='{ds3::Type}']" to dynamically set this up as I change the drop down selection.
The spry drop down selection is defined as
<div spry:region="ds3">
<select name="select" onchange="ds3.setCurrentRow(this.value)" spry:repeatchildren="ds3">
<option value="{ds_RowID}}">{Type}</option>
</select>
</div>
On loading the table shows the selection of data I want, however once I select a value from the dropdown list the table goes blank. The ds3 dataset that drives the dropdown list has 1 field which is all the different options to filter ds2 on.
Any help or different solutions would be gratefully received
AdChoices