I wish :-( That was the original code and gives a runtime error of: lstRepRankDrill[0].record.filterFunction = filterRepRankDtlChnl; TypeError: Error #1089: Assignment to lists with more than one item is not supported.
--- In [email protected], "Tracy Spratt" <tr...@...> wrote: > > 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" <tracy@> 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. > > > > > > > > > >
