You could do a basic "drill" down scenerio, or simply filter the records.
Use Drill down: Data A: A list of agents and other "stuff", and ID Data b: A more detailed view of a Typically a single record. But not only. The details could be a list of tickets for that agent. Basically the second list needs to contain a foriegn key of the agent id. Use a filter if all you want to do is refine the results and not look at additional details. Client side filtering is easy, check out dev net or docs for examples. Process: Load the data Store the data (arraycollection works nicely) Display data (in a grid) Setup another control (combo) to display a distinct list of agents. That combo's dataprovider could be from a "select distinct" in sql and a second remoting call. Or do what I like to do, copy the original data to array and filter the list down to a single record per agent. Now you have a distinct list of agents and ids, and the user can select an agent, call another method to filter the main data collection. I will tell you I searched flex blogs for weeks to find the equiv of a select distinct filter. I did not have any luck. So I was able to find a javascript code snip that did the task. My big tip is this, if you can't find a method in the native language, look at other languages and see how it's done. Javascript has the same kinds of datatypes (ie ARRAYS, lists) and similar methods, split, join etc. Just find a snip that works there and update the syntax to actionscript. Learn how filters work, they are essential for managing RIA's, as they can save a ton of trips back and forth from the server. Good luck. --- In flexcoders@yahoogroups.com, "Don Kerr" <[EMAIL PROTECTED]> wrote: > > Basic question...I think... > > > I have a grid of agent name and a grid of tickets. I'd like the user > to select an agent and filter the tickets down to just the selected > agent's tickets. > > > I'm using remoteobject talking to a Cold Fusion CFC. I'm new to AS > and I'm trying to learn how to pass the selected agent name to the > query and return the new results to the ticketgrid. > > > In general, What do I add to the MXML in the agentgrid? > > In general, What Actionscript do I need? > > > I think I see how to modify the CFC side, but not the Flex Builder 2 > MXML/AS side. > > > If this is not the best way to do this, I'm open to suggestions. > > Thanks, > > Don > -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/flexcoders/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/flexcoders/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
