4 Replies Latest reply: Jan 3, 2013 10:09 AM by Don Kerr RSS

    ArrayCollection all items in string

    Don Kerr Community Member

      I'm trying to find all vehicles that have a string of accessories.

       

      I have a comma sep string of optioncodes that represent selectedItems from an options List

      optionsString:String = leather,stripes, ...

       

      I have an ArrayCollection called vehicleOptions that contains a list of vehicle options one row per option

      VIN1,optioncode

      VIN1,optioncode

      VIN2,optioncode

      VIN2,optioncode

      VIN3,optioncode

      ...

       

      I need to retrieve all vehicles (VINs) that have, not one, but ALL of the optioncodes contained in the selected optioncodes string. 

       

      Any recommendations on how to do this?

       

      Once I have a list of VINs, this will allow me to filter down another List of vehicles on the lot by only the vehicles that have ALL the selected options.

       

      Thanks!

       

      Don