Ok ,you are not applying the filter to the dataProvider but rather to the parent that contains it. Put "lstRepRankDrill[0].record" and filter that.
Tracy Spratt, Lariat Services, development services available _____ From: [email protected] [mailto:[email protected]] On Behalf Of chigwell23 Sent: Friday, August 28, 2009 2:53 AM To: [email protected] Subject: [flexcoders] Re: Apply filterFunction to datagrid XMLListCollection dataprovider question 1. Datagrid displays fine 2. Datagrid dataprovider = lstRepRankDrill[0].record which is _inside_ the lstRepRankDrill XMLListCollection. This XML hierarchy format is returned by myFlexSQL web service against SQLServer2005. 3. trace(lstRepRankDrill[0].record.toXMLString()) gives the 60 "rows" of data that appear in the datagrid. 4. The XMLListCollection format: lstRepRankDrill (mx.collections.XMLListCollection) ...[0] (XML) ......<results> .........<record> ............<chnl_cd> ............<rep_nm> .........<record> .........<record> etc Code: - Datagrid declaration <mx:DataGrid dataProvider="{lstRepRank[0].record}" </mx:DataGrid> - load XMLListCollection with back end result set lstRepRankDrill = new XMLListCollection(myFlexsql.xmlData.results); - add filter lstRepRankDrill.filterFunction = filterRepRankDtlChnl; - filter code private function filterRepRankDtlChnl(item:XML):Boolean{ ...trace(item.toXMLString()); ...if(item.results.record.chnl_cd == "PREM") return true; ......else return false; } NOTE: trace(item.toXMLString()); in filter code prints all the data, not just one "row". Trace= item (XML) ...<results> ......<record> ......<record> etc all 60 of them. So even though the grid data is fine, the filter is getting passed all the data, and the filter gets called once. I wonder if it is because the data is hierarchical and there is a discrepancy between the dataprovider and the filter owner. The dataprovider is _inside_ the lstRepRankDrill XMLListCollection as lstRepRankDrill[0].record. The filter is placed on the outside XMLListCollection : lstRepRankDrill.filterFunction = filterRepRankDtlChnl; Its almost like where the filter is placed (XMLListCollection rather than dataprovider subnode lstRepRankDrill[0].record) is causing all the data to be forwarded into filter param item, and passed only once. --- In flexcod...@yahoogro <mailto:flexcoders%40yahoogroups.com> ups.com, "Tracy Spratt" <tr...@...> wrote: > > Lets clarify terminology. "dataProvider" must always be a list of some > kind, like an array, and XMLList an ArrayCollection or an XMLListCollection. > It can not be a single XML node. > > > > This expression should return an XMLList: lstRepRankDrill[0].record > > > > If you trace(lstRepRankDrill[0].record.toXMLString()); //what do you see? > > > > Does your DG display correctly without the filter? > > > > Post the declaration for the dataGrid. > > > > Tracy Spratt, > > Lariat Services, development services available > > _____ > > From: flexcod...@yahoogro <mailto:flexcoders%40yahoogroups.com> ups.com [mailto:flexcod...@yahoogro <mailto:flexcoders%40yahoogroups.com> ups.com] On > Behalf Of chigwell23 > Sent: Thursday, August 27, 2009 2:09 PM > To: flexcod...@yahoogro <mailto:flexcoders%40yahoogroups.com> ups.com > Subject: [flexcoders] Re: Apply filterFunction to datagrid XMLListCollection > dataprovider question > > > > > > thanks for your time Tracy, yes absolutely the whole shooting match is sent > to the _one_ call to the function i.e. lstRepRankDrill, which is actually > more than the dataprovider which is {lstRepRankDrill[0].record}. I know that > the fact there is only one call to the filter is significant, but do not > know why, unless it is because I have to put the filter on > lstRepRankDrill.filterFunction = filterRepRankDtlChnl; and it is > hierarchical. Obviously I cannot put the filter on lstRepRankDrill[0].record > as it is XML and not an XMLListCollection. Am using DG not ADG if that makes > any difference. Eventually found 2 other Google questions out there with the > same scenario - one call to the filter with the whole XMLListCollection > being passed. No answers to them :-( > > --- In flexcod...@yahoogro <mailto:flexcoders%40yahoogroups.com> ups.com, > "Tracy Spratt" <tracy@> wrote: > > > > I don't use ADG all that much, but the filter functions should get a > > "record" node for each call of the filter function. Have you used > > toXMLString() to trace out the item? Inside the filter function you can > use > > any e4x expressions to traverse the xml, down into the child nodes or even > > up to parent nodes. > > > > > > > > I am pretty sure you are not getting the entire dataProvider in the > > function. Do the trace. > > > > > > > > Tracy Spratt, > > > > Lariat Services, development services available > > > > _____ > > > > From: flexcod...@yahoogro <mailto:flexcoders%40yahoogroups.com> ups.com > [mailto:flexcod...@yahoogro <mailto:flexcoders%40yahoogroups.com> ups.com] > On > > Behalf Of chigwell23 > > Sent: Thursday, August 27, 2009 4:25 AM > > To: flexcod...@yahoogro <mailto:flexcoders%40yahoogroups.com> ups.com > > Subject: [flexcoders] Re: Apply filterFunction to datagrid > XMLListCollection > > dataprovider question > > > > > > > > > > > > I wonder if is even possible to use the filter function with hierarchical > > XML, as all of the examples I have seen are of array collections or flat > > XML? > > > > This I think is the problem - the complete data provider is being passed > > into the item parameter of the filter i.e. the xml hierarchy in its > > entirety. I am presuming that the filter wants one "row" at a time so it > can > > do its compare. Where do I have control of this? I am not sure I do since > > the only code is > > > > lstRepRankDrill.filterFunction = filterRepRankDtlChnl; > > > > The data provider is > > > > dataProvider="{lstRepRankDrill[0].record}" in order to dig into the XML > > hierarchy to get to the data. (Wrapper nodes are returned by SQL back end. > > > > > --- In flexcod...@yahoogro <mailto:flexcoders%40yahoogroups.com> ups.com, > > "Tracy Spratt" <tracy@> wrote: > > > > > > Break the code into smaller pieces and debug to see what is wrong. > > > > > > > > > > > > Tracy Spratt, > > > > > > Lariat Services, development services available > > > > > > _____ > > > > > > From: flexcod...@yahoogro <mailto:flexcoders%40yahoogroups.com> ups.com > > [mailto:flexcod...@yahoogro <mailto:flexcoders%40yahoogroups.com> ups.com] > > On > > > Behalf Of chigwell23 > > > Sent: Thursday, August 27, 2009 2:40 AM > > > To: flexcod...@yahoogro <mailto:flexcoders%40yahoogroups.com> ups.com > > > Subject: [flexcoders] Apply filterFunction to datagrid XMLListCollection > > > dataprovider question > > > > > > > > > > > > > > > > > > private function filterRepRankDtlChnl(item:Object):Boolean{ > > > if(item.results.record.chnl_cd == "PREM") return true; > > > else return false; > > > } > > > > > > Filter is not filtering and I think it maybe item.results.record.chnl_cd > - > > > the item:Object is in this format: > > > > > > item > > > ...<results> > > > ......<record> > > > .........<chnl_cd> > > > .........<rep_nm> etc > > > > > > What is the correct "path" for chnl_cd and might this be the problem? > TIA, > > > > > > Mic. > > > > > >
