Ah this makes total sense - thanks Tracy will try that now
--- In [email protected], "Tracy Spratt" <tr...@...> wrote:
>
> This returns ans XMLList: "lstRepRankDrill[0].record" You need a collection
> to use filter.
>
>
>
> Assign that XMLList to an XMLListCollection and use that as the data
> provider.
>
>
>
> Tracy Spratt,
>
> Lariat Services, development services available
>
> _____
>
> From: [email protected] [mailto:[email protected]] On
> Behalf Of chigwell23
> Sent: Friday, August 28, 2009 12:39 PM
> To: [email protected]
> Subject: [flexcoders] Re: Apply filterFunction to datagrid XMLListCollection
> dataprovider question
>
>
>
>
>
> 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 flexcod...@yahoogro <mailto:flexcoders%40yahoogroups.com> ups.com,
> "Tracy Spratt" <tracy@> 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: flexcod...@yahoogro <mailto:flexcoders%40yahoogroups.com> ups.com
> [mailto:flexcod...@yahoogro <mailto:flexcoders%40yahoogroups.com> ups.com]
> On
> > Behalf Of chigwell23
> > Sent: Friday, August 28, 2009 2:53 AM
> > To: flexcod...@yahoogro <mailto:flexcoders%40yahoogroups.com> ups.com
> > 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.
> > > > >
> > > >
> > >
> >
>
